linux centos7下mysql5.7忘记密码解决方法

注：如果忘记mysql密码，或者密码输入提示错误

解决方法

1、修改配置文件，在配置文件中添加skip-grant-tables，就可以不用密码进入mysql

vi /etc/my.cnf

#配置文件内容如下：

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/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

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
#user=root

#忘记密码
skip-grant-tables


log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

innodb_thread_concurrency=10
wait_timeout=2880000 
interactive_timeout = 2880000
max_allowed_packet=200M
net_buffer_length=1000000

[mysqldump]
#使用定时任务自动备份数据库使用
user=root
password=Abc123456

2、重启mysql

systemctl restart mysqld

3、进入mysql

#无需输入密码，直接回车进入mysql
mysql -uroot -p

4、修改管理员密码

#修改root密码
update mysql.user set authentication_string=password('Abc123456') where user='root';
flush privileges;

5、添加新用户，可以%外网访问

#新增用户
GRANT ALL PRIVILEGES ON *.* TO 'jason'@'%' IDENTIFIED BY 'Abc123456' WITH GRANT OPTION;
FLUSH PRIVILEGES;

6、然后修改配置文件，注释  #skip-grant-tables

7、再重启mysql ：systemctl restart mysqld；就可以使用之前添加的账号密码登录mysql了。