解决Mysql登陆出现ERROR

解决Mysql登陆出现ERROR 1045: Access denied for user: 'ODBC@localhost' (Using password: YES)
Code:

# mysqladmin -uroot password "youpassword" #设置root帐户的密码
# mysql -uroot -p
# 输入你设置的密码
mysql>use mysql;
mysql>delete from user where password=""; #删除用于本机匿名连接的空密码帐号
mysql>flush privileges;
mysql>quit

然后再以root登录
mysql> SET PASSWORD FOR root=PASSWORD('new_password');
posted @ 2005-08-10 21:16  dkcndk  阅读(226)  评论(0编辑  收藏  举报