mysql server 4.1 can"t connect no matter what
am 14.07.2007 21:50:20 von GonzosezFor 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...