##先修改配置文件
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:
版权声明：本文为m0_64483804原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。