According to the mySql manual, you should set a password for all users and remove the row in the mysql.user table that has
Host=’localhost’ and User = ''. You’re also supposed to add a password for the root user. I followed these instructions but now can’t logon:

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 am logging on to my laptop and according to the mySql documentation (3.1 Connecting to and disconnecting from the Server) I should only need a hostname if the server runs on a machine other than the one where I log on. However, I’m getting the error message below.

C:\mysql\bin>mysql -u root -p
Enter password: *********

ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

How can I resolve this? FYI, the operating system is Windows NT.

Also, according to the mySql documentation (Connector/ODBC with VB – ADO, DAO, and RDO) in the connection string you should specify a username and password. Will any username and password that has been granted privileges be sufficient or is there supposed to be one username and password for a particular database?

Robin

You can configure user accounts to only have access to specific databases. I don't know why you're getting an access denied message -- did you properly add a root account, verify the password, and allow it to connect from localhost?


Take care,

Nik
http://www.bigaction.org/

This problem was resolved by re-installing mysql, executing the following commands in the Command Prompt, and turning the machine off and then back on!

Robin
***************

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
C:\> mysqladmin --user=root --password=your_password shutdown



:)

I have a similar problem. BUT

I can connect just fine using the command prompt and I get the error when using PHP/IIS.



Any ideas???