Web Hosting Talk : Web Hosting Main Forums : Dedicated Server : Help Phpmyadmin Shows All Databases On The Server !!!

[hoot]

I have already got phpmyadmin running on my server in advanced auth mode and everything is fine but one of my customers has just installed it in normal mode and he can see all the databases on the server !!!!!

Is there a way to stop people who install phpmyadmin on their own accounts from seing all the databases on the server and what they contain??
Is there a problem with my mysql settings? if so How do I fix this ???

hoot

[alchiba]

Make sure MySQL root has a password.

Oops, just realized this is the RaQ forum. Not sure how MySQL is initially configured on these guys, but a password is the first thing to make sure of.

[hoot]

It does then when a user connects with his password as he has to fill in his password and username to get phpmyadmin to work !

Thanks,
Hoot

[hypernatic.net]

Hi,

Had the same problem... It has something to do with permissions...

Homer posted some instructions at my request

Here, I hope they work for you as well...

http://www.hostingdiscussions.com/sh...p?threadid=210

If not let me know and I'll ask what's wrong...

[coolprojects]

Hi,

You have to remove privileges of users which states they have access to *.*

In cpanel server you can grab all privileges using

/scripts/grabmysqlprivileges

and then remove lines which shows access to *.*

Then drop all database privileges using the script,

/scripts/cleanmysqlprivileges

Then reapply the privileges except the *.* privilege

Thanks