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

迈不过友情╰ 2022-02-19 08:43 430阅读 0赞

### 注：如果忘记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了。