Php Admin


#1

I am confused about something and hoped someone can help.

Assume I have these sql data bases set up:

database1.domain.com
name: name1
pass: pass1

AND

database2.domain.com
name: name2
pass: pass2

If I go to database1.domain.com with my web browser and log in as name1, I can see BOTH databases with phpadmin

AND

If I go to database2.domain.com with my web browser and log in as name2, I can see BOTH databases with phpadmin

What’s the point of having different credentials for each DB if I can see them all with any one log on?


#2

when you go to the mysql section on your dh control panel, do both databases show both users? each user should only see the databases they have been given access to. multiple users can be given access to a particular database though.


#3

No - each data base shows the one user


#4

The db1.domain.com & db2.domain.com URIs point to the same location. It seems some crosstalk is going on.

The only suggestion I could think of off the top of my head is to click on each user link at https://panel.dreamhost.com/index.cgi?tree=goodies.mysql and just double check which databases they have access to at the user level.

After that, you could try clicking the Modify Database button to the right of each affected DB, then Modify Now at the following page. Maybe that will update something, somewhere (like when performing a domain refresh).


#5

Do you have access to both DBs when you log into mysql from the command line?