Mysql“using password: YES”的解决

错误代码 1045
Access denied for user 'root'@'localhost' (using password:YES)

解决方法：重置root用户密码

ps -ef | grep -v grep | grep  mysql | awk '{print $2}' | xargs kill -9
mysqld_safe --skip-grant-tables &
mysql -uroot -p
update user set password=password('123456') where user = 'root';