Hello everyone.
This will be my first post here 🙂
OK, I d/loaded mysql onto my XP system and followed every step in the manual from installing the package, to installing the server service, to starting the service and succesfully ran the tests to see if mysql was working fine.
When I came to this point, C:> C:\mysql\bin\mysql mysql which purpose is to resolve access/priviledges issues...
From the manual
The default privileges on Windows give all local users full privileges to all databases without specifying a password. To make MySQL more secure, you should set a password for all users and remove the row in the mysql.user table that has Host='localhost' and User=''.
You should also add a password for the root user. The following example starts by removing the anonymous user that has all privileges, then sets a root user password:
C:> C:\mysql\bin\mysql mysql
mysql> DELETE FROM user WHERE Host='localhost' AND User='';
mysql> QUIT
C:> C:\mysql\bin\mysqladmin reload
C:> C:\mysql\bin\mysqladmin -u root password your_password
...I got the following error:
ERROR 1044: Access denied for user: '@' to database 'mysql'
Looks like I'm caught in a loop and how do I get out of it? I'm pretty positive that I've followed every step in the installation guide...
Thanx. 🙂
