|
|
Posted by Tom on 07/17/07 17:36
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
Navigation:
[Reply to this message]
|