Article ID: 602, created on Oct 6, 2008, last review on May 9, 2014

  • Applies to:
  • Plesk for Linux/Unix


Warning: mysql_list_dbs(): Unable to save MySQL query result /var/www/html/phpmyadmin/libraries/common.lib.php on line 1246

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/phpmyadmin/libraries/common.lib.php:1246) in /var/www/html/phpmyadmin/libraries/ on line 14


#1227 - Access denied. You need the SHOW DATABASES privilege for this operation

What can I do to solve this problem?


Log into Mysql with root privileges and perform the following:

mysql> use mysql;

mysql> update user set Show_db_priv = 'Y' where user like 'web%';

mysql> alter table user modify Show_db_priv enum('N','Y') default 'Y';

mysql> flush privileges;

mysql> exit

29d1e90fd304f01e6420fbe60f66f838 a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF