I have just installed mysql on windows xp. I followed the manual that came with it. I followed these instructions...
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 can be >used by anyone to access the test database, 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
Now I have no privileges to do anything in MySql. i have ibviously done something wrong! When I try to connect to the console by typing...
c:/mysql/bin/mysql -u=root -p=leinadg
I get the error -
Access Denied for user '=root@localhost' (Using Password 'YES')
I dont know what to do - please help
