mysql修改root用户密码

【版本】

 5.6.42

【修改密码】

# 修改配置文件

[root@xiel ~]# vim /etc/my.cnf
  1 # For advice on how to change settings please see
  2 # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
  3
  4 [mysqld]
  5 skip-grant-tables
  6 #
  7 # Remove leading # and set to the amount of RAM for the most important data
  8 # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
  9 # innodb_buffer_pool_size = 128M
 10 #
 11 # Remove leading # to turn on a very important data integrity option: logging
 12 # changes to the binary log between backups.
 13 # log_bin
 14 #
 15 # Remove leading # to set options mainly useful for reporting servers.
 16 # The server defaults are faster for transactions and fast SELECTs.
 17 # Adjust sizes as needed, experiment to find the optimal values.
 18 # join_buffer_size = 128M
 19 # sort_buffer_size = 2M
 20 # read_rnd_buffer_size = 2M
 21 datadir=/var/lib/mysql
 22 socket=/var/lib/mysql/mysql.sock

重启mysqld

[mysqld]后面加上skip-grant-tables

# 修改user表，更新密码

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> UPDATE user SET authentication_string = password('123') WHERE User='root';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 4  Changed: 0  Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)