Use the mysqladmin command line program to reset the root user's
password and then try getting back in. Details of how to use it are in
the manual and clearly explain what needs to be done. Cheers.
-----Original Message-----
From: ABCC electronics [mailto:elec...@scf.sk.ca]
Sent: Friday, March 05, 2004 3:32 PM
To: win...@lists.mysql.com
Subject: Can't access 'mysql' database
I seem to have done something horrible to the mysql user database; I
can't seem to connect to it to do privilege changes etc....
C:\mysql\bin>mysql -u root -p
Enter password: *******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 4.0.18-max-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use mysql;
ERROR 1044: Access denied for user: 'root@localhost' to database 'mysql'
what the heck could I have done and how to I recover from this!!
Scot.
4 messages in com.mysql.lists.win32RE: Can't access 'mysql' database
