Help - Search - Members - Calendar
Full Version: Problem With the new phpmyadmin
The Planet Forums > Control Panels > cPanel/WHM
duranduran
Hi,

If i access a cpanel account, and access the phpmyadmin, all bds from all users in all server are shown. Users from anothers ress. accounts too.
theuruguayan
new phpmyadmin and mysql?

if it new mysql you should do the following:

mysql_fix_privilege_tables AQUI_TUPASSWORD_ROOTMYSQL

then:

mysql mysql -u root -p


update `user` set Create_tmp_table_priv = 'N', Lock_tables_priv = 'N' where user <> 'root';
flush privileges;
q

restart MYSQL.
duranduran
The solution:

Include this in your /etc/my.cnf and try accessing the databases again:

[mysqld]
safe-show-database

restart the MySQL as well:
/scripts/restartsrv_mysql will do that.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2009 Invision Power Services, Inc.