ubuntu无法登陆mysql_更新ubuntu之后无法登陆mysql

Ubuntu 14.04&＃xff0c;更新一些软件之后莫名其妙的mysql无法登陆了&＃xff0c;一直显示&＃xff1a;“Access denied for user [email protected]”

重置root密码后就好了&＃xff0c;重置方法&＃xff1a;

You have to reset the password! steps for mac osx(tested and working) and ubuntu

Stop MySQL

$ sudo service mysql stop

Start it in safe mode:

$ sudo mysqld_safe --skip-grant-tables

(above line is the whole command)

This will be an ongoing command until the process is finished so open another shell/terminal window, log in without a password:

$ mysql -u root

mysql> UPDATE mysql.user SET Password&＃61;PASSWORD(‘password‘) WHERE User&＃61;‘root‘;

Start MySQL

sudo service mysql start

your new password is ‘password‘.

参考自&＃xff1a;

评论里说这么整不安全&＃xff0c;帖子里还有更安全的方法&＃xff0c;没有深究。

-------

这里是类似的问题&＃xff1a;https://bugs.launchpad.net/ubuntu/&＃43;source/mariadb-10.0/&＃43;bug/1447808

原文&＃xff1a;https://www.cnblogs.com/robotech/p/10206610.html