MySQL show database right problem

kilgore · Unread post by **kilgore** » Sat Mar 12, 2005 1:50 pm

Hello,

I'm getting a quite big problem with user right in MySQL. Some customers have installed their own phpMyAdmin on their account and when they login with one user/pass they created in Plesk, they can see all the databases on the MySQL server.

In the Plesk DB Admin there isn't any problem.

I suppose it's a user MySQL right problem but I don't know how to fix it.

Any help appreciated,

Kilgore

Unread post by **scott** » Sun Mar 13, 2005 4:50 pm

thats a "feature" of mysql, the PSA version gets around this by modifying phpmyadmin so you cant see the other db's

kilgore · Unread post by **kilgore** » Mon Mar 14, 2005 3:09 am

Ok so I don't want all users to see all database I need to unauthorize user to install their own phpMyAdmin

.

The risk looks minor so...

Regards,

Kilgore

cauw · Unread post by **cauw** » Sun Mar 27, 2005 8:04 am

Is there no way to dissable this so they can not see the databases on the server except their own?

Unread post by **scott** » Sun Mar 27, 2005 10:24 am

you might want to check with the phpmyadmin, or mysql.com websites about that

cauw · Unread post by **cauw** » Sun Mar 27, 2005 4:12 pm

i found a solution but after that i get the next problem, i used --skip-show-database option, but after that the phpmyadmin scripts installed by some users on their webspace gives them:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/dutchzone.be/subdomains/test/httpdocs/libraries/dbi/mysql.dbi.lib.php on line 118

Think i'm getting crazy about this :s

Hope somone has a solution...