phpbbmyadmin lists databases not belonging to logged-in user

fuzzymonkey

Well-Known Member
Jun 11, 2004
61
0
156
phpmyadmin lists databases not belonging to logged-in user

On the upgrade to 10.8.0-STABLE 15, mysql v. 4.0.25-standard, phpMyAdmin shows all databases on the server, not just those the logged-in user has permission to access.
 
Last edited:

ChemicalWH

Active Member
Mar 4, 2004
40
0
156
The problem actually came back after what i posted before. the same thing would not solve it again.

i found the following solution somewhere else:

in mysql mode, run:

UPDATE mysql.user SET Lock_tables_priv = 'N', Create_tmp_table_priv = 'N' WHERE
User != 'root'; FLUSH PRIVILEGES;

This solved it for me.