Posted by Nospam on 07/14/07 19:50

For some strange reason mysql server 4.1 won't connect, it use to be for it
to work I had to load an init file:
C:\mysql\bin\mysqld-nt --init-file=C:\mysql-init.txt

containing:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('password');

and then type on my ms-dos console:

[PATH TO MYSQL BINS]/mysqld-nt --skip-grant-tables

Then open another command prompt and run 'mysql -u root' and run the
following query:


UPDATE mysql.user SET Password='newpass' WHERE User='root' AND
Host='localhost';


Then shutdown the server, and restart it normally. You should then be able
to connect with 'mysql -u root'.

I have had to do this everytime to connect to mysql server 4.1. Now it
doesn't work at all each time it says can't connect error 20003...

[Back to original message]