mysql ERROR 1045 (28000): Acces

1. 问题

• ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
• 我之前装过 数据库，数据库服务也在，就是连接不上，密码输入也连接不上，可能库被人改了什么。
  所以想重置一下密码。

2. 解决

• vim /etc/my.cnf文件；在[mysqld]后添加 skip-grant-tables（登录时跳过权限检查）

  
  QQ截图20230103133148.png

root@Verde-SICC-DB002:~# cat /etc/mysql/my.cnf
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
# 
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#

!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
[mysqld]
skip-grant-tables
root@Verde-SICC-DB002:~# 

• 重启MySQL服务：

sudo systemctl restart mysqld

• 修改密码
  输入：

set password for 'root'@'%'=password('jidianke#!_%0103');

如果报：ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

修改密码.png

• 输入：

 flush privileges;

• 再次修改密码

set password for 'root'@'%'=password('jidianke#!_%0103');

• 输入：

 flush privileges;

• 别忘了把my.cnf 中的 skip-grant-tables 注释掉

  
  注释.png
• 重启mysql

sudo systemctl restart mysql

重启mysql.png