一. 修改配置文件
首先找到mysql的配置文件，如: /etc/my.cnf
在[mysqld]字段下新增如下内容，然后保存退出。
skip-grant-tables
然后重启mysql服务
service mysqld restart
二. 修改root密码
使用空密码登陆mysql
mysql -uroot -p -- 不输入密码直接回车
USE mysql;
UPDATE user SET Password = password('YourPassword') where user = 'root';
flush privileges;
exit
测试记录:
[root@******~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.16-log MySQL Community Server (GPL)
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql [(none)]>
mysql [(none)]> 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 [mysql]> UPDATE user SET Password = password('abc123') where user = 'root';
Query OK, 5 rows affected (0.00 sec)
Rows matched: 5 Changed: 5 Warnings: 0
mysql [mysql]> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql [mysql]> exit
Bye
首先找到mysql的配置文件，如: /etc/my.cnf
在[mysqld]字段下删除如下内容，然后保存退出。
skip-grant-tables
然后重启mysql服务
service mysqld restart
最后就可以用修改的密码登陆mysql了。