Mysql之重置密码

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