Hi,
I have Mysql 3.23.52-max-nt on Win2K. I¡¯d like to set a password for root
so I use the following commands:
mysql> use mysql
Database changed
mysql> update user set password=password('l05m')
-> where host='localhost' and user='root';
Query OK, 1 row affected (0.00 sec)
Mysql prompt a password be set. So I use the following commands to reload
system parameters:
C:\mysql\bin>mysqladmin reload
But mysql shows:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'ODBC@localhost' (Using password: NO)'
then I use the new password to start mysql.
C:\mysql\bin>mysql -hlocalhost -uroot -p
Enter password: ****
mysql shows:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
Does anybody give help for me?
Thanks for any suggestions,
Alice
_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php