Home > Archive > PHP SQL > July 2007 > mysql server 4.1 can't connect no matter what
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
mysql server 4.1 can't connect no matter what
|
|
| Nospam 2007-07-14, 7:01 pm |
| 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...
| |
|
| On Sat, 14 Jul 2007 19:50:20 GMT, Nospam wrote...
>
>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...
>
>
>
I think you need to format your connection command a little differently.
Maybe...
mysql -u root -p mysql
The "-p" should prompt you for a password to access, and the table you want to
update your MySQL password is usually in the "mysql" database.
Tom
--
Basic Accounts $5.95 / month or $39.95 / 12 months
http://newsguy.com/overview.htm
|
|
|
|
|