The Default 'Mysql' Database is not accessible
Posted on 2004-09-16
I have been looking everywhere to figure out my problem. This is a Windows 2000 machine using mysql 4.0.18. The problem seems to be that the mysql database, the one installed and created by default, is not showing up when you do a "Show DATABASES" at the mysql prompt. When looking in the \mysql\data directory there is a \mysql directory and it appears that all the tables are all there.
If that is not the problem then somehow the root permissions have disappeared.
* When using MySQL Control Center 0.9.4-beta, It does not allow me access into "User Administration" and gives a "You don't have enough privileges to access this section", I am logged in as root. It allows me to see the other two databases, and allows me to go into "Server Administration"
* When trying to add users using the GRANT command it says "ERROR 1045: Access denied for user: 'root@servername' (Using password: NO)" where servername is the DNS name of the server.
* A PHP application is not able to read the privileges or user database.
I believe this is probably an easy question, but I am fairly new with mySQL administration.