解决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');
原文地址:https://www.cnblogs.com/dkblog/p/1981009.html