Linux下mysql5.7直接修改root密码

##先修改配置文件
mysql]# vi /etc/my.cnf   


[mysqld]
#skip-grant-tables----------在这里加上这句，修改完密码后再重复此步骤，把这句删除
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
--：wq 保存
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> desc user;


mysql> update user 
    -> set authentication_string=password('123456')
    -> where user='root' and host='localhost';
Query OK, 1 row affected, 1 warning (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 1


[root@hadoop102 mysql]# vim /etc/my.cnf
##删除skip-grant-tables代码
[root@hadoop102 mysql]# systemctl restart mysqld
[root@hadoop102 mysql]# mysql -uroot -p
Enter password: