mysql5.7修改密码最佳实践

环境信息

ubuntu@VM
-0
-7
-ubuntu:~/blog$ lsb_release -a
No
 LSB modules are available.
Description:    Ubuntu 
.04
.4
 LTS
ubuntu@VM
-0
-7
-ubuntu:~/blog$ mysql 
--version
mysql  Ver 
.14
 Distrib 
.7
.38
, 
for
 Linux (x86_64) 
using
  EditLine 
wrapper

修改配置文件

在[mysqld]块内加上skip-grant-tables，然后保存退出，sudo service mysql restart重启mysql

sudo vim 
/etc/my
sql
/mysql.conf.d/my
sqld.cnf
[mysqld]
#
# * Basic Settings
#
user            = mysql
pid-file        = 
/var/
run
/mysqld/my
sqld.pid
socket          = 
/var/
run
/mysqld/my
sqld.sock
port            = 
basedir         = /usr
datadir         = 
/var/
lib/mysql
tmpdir          = /tmp
lc-messages-dir = 
/usr/
share/mysql
skip-external-locking
skip-grant-tables

重设密码

终端输入mysql -u root直接进入mysql，执行如下语句

use mysql;
update
user
set
 authentication_string=
password
("新密码") 
where
user
="root";
flush 
privileges
;

然后quit退出mysql

还原配置文件

重新回到刚才的配置文件，将加进去的skip-grant-tables注释掉即可。