luoya,
Wednesday, October 02, 2002, 8:32:21 AM, you wrote:
ll> I have Mysql 3.23.52-max-nt on Win2K. I¡¯d like to set a password for root
ll> so I use the following commands:
ll> mysql> use mysql
ll> Database changed
ll> mysql> update user set password=password('l05m')
ll> -> where host='localhost' and user='root';
ll> Query OK, 1 row affected (0.00 sec)
ll> Mysql prompt a password be set. So I use the following commands to reload
ll> system parameters:
ll> C:\mysql\bin>mysqladmin reload
ll> But mysql shows:
ll> mysqladmin: connect to server at 'localhost' failed
ll> error: 'Access denied for user: 'ODBC@localhost' (Using password: NO)'
It means that anonymous user doesn't have RELOAD_priv.
ll> then I use the new password to start mysql.
ll> C:\mysql\bin>mysql -hlocalhost -uroot -p
ll> Enter password: ****
ll> mysql shows:
ll> ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
ll> Does anybody give help for me?
You enter new 'root' password, bun new privileges take effect only
after restart mysql daemon, or after mysqladmin reload, or after
mysqladmin flush-privileges, or after FLUSH PRIVILEGES command if you
update grant tables manually.
So, you should use
mysqladmin -uroot -hlocalhost reload
if 'root' didn't have a password before or if 'root' had a password
mysqladmin -uroot -hlocalhost -p reload
and enter old 'root' password
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
