sudo mysql_secure_installation
修改vim /etc/my.cnf
在文档内搜索mysqld定位到[mysqld]文本段,(如果没有此字段,打开/etc/mysql/mysql.conf.d/mysql.cnf),在文件中添加skip-grant-tables,如下
[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
skip-grant-tables
然后执行service mysql restart,输入mysql,此时不需要密码即可登陆
use mysql;
update user set password=password("*******") where user=root; # ******为密码,如果此行执行失败,执行下一行,如果成功,跳过下一行;
update user set authentication_string=password('*******') where user=root;
flush privileges; #立即生效
quit