Total Pageviews

Wednesday, October 13, 2010

cannot see database cPanel for domain

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 . 


–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.

No comments:

Post a Comment