While accessing Phpmyadmin via Cpanel , under databases it shows ” No Database ” . But you can see the databases while accessing through WHM.

This can be due to many reasons . One of the reason I found is because the user doesn’t have SHOW DATABASES privilege .

From the server my.cnf remove the line

skip-show-database

Restart Mysql

Try to access Phpmyadmin .

About skip-show-database from Mysql Reference Manual .

–skip-show-database

With this option, the SHOW DATABASES statement is allowed only to users who have the SHOW DATABASES privilege, and the statement displays all database names. Without this option, SHOW DATABASES is allowed to all users, but displays each database name only if the user has the SHOW DATABASES privilege or some privilege for the database. Note that any global privilege is considered a privilege for the database.

Tags: logicsupport review, no database, phpmyadmin, server management, technical support

This entry was posted on Monday, November 30th, 2009 at 8:48 am and is filed under Cpanel. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.