Posted at October 23, 2015 at 8:28 am by InterServer Staff
If phpmyadmin shows all the databases on a server when it should only show the users databases do the following:
First be sure a MySQL root password is set.
Add safe-show-database in the mysqld section of /etc/my.cnf
Then restart mysql.
If this does not work do the following:
mysql -u root -p mysql
update `user` set Create_tmp_table_priv = ‘N’, Lock_tables_priv = ‘N’ where user <> ‘root’;
Go back to shell and run mysqladmin reload
If you get an error about a column not found run the following:
mysql_fix_privilege_tables [mysql root password]
then rerun the update command.
You can skip to the end and leave a response. Pinging is currently not allowed.