mysqladmin: connect to server at ‘localhost’ failed
error: ‘Access denied for user ‘root’@‘localhost’ (using password: YES)’ //此处yes可能是no
网上找到的方法操作很简单,如下:
mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD(‘newpassword’) where USER=‘root’ and host=‘root’ or host=‘localhost’; //把空的用户密码都修改成非空的密码就行了。
mysql> FLUSH PRIVILEGES; //也可以重启数据库生效