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