duranduran
Oct 14 2004, 01:27 PM
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
Oct 14 2004, 04:11 PM
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
Oct 17 2004, 07:50 PM
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.