1.先停止資料庫伺服器 service mysqld stop 2.vim /etc/my.cnf 3.配置文件添加skip-grant-tables [root@VM_0_8_centos ~]# vim /etc/my.cnf # For advice on how to change sett ...
1.先停止資料庫伺服器
service mysqld stop
2.vim /etc/my.cnf
3.配置文件添加skip-grant-tables
[root@VM_0_8_centos ~]# vim /etc/my.cnf # For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html [mysqld] # # 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 # # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock skip-grant-tables 此處!!!!!! # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0
4.重啟資料庫
systemctl restart mysql
5.登錄資料庫
mysql -uroot -p
如果詢問密碼,直接空密碼登錄
6.set password for root@localhost = password('123456');括弧裡面的密碼你自己修改。
7.mysql -uroot -p123456 登錄成功