如果您在 MySql 5.7.+ 中遇到同样的问题：

Access denied for user 'root'@'localhost'

这是因为MySql 5.7默认允许使用socket连接，这意味着你只需使用sudo mysql连接即可。如果你运行sql：

SELECT user,authentication_string,plugin,host FROM mysql.user;

然后你就会看到它：

+------------------+-------------------------------------------+-----------------------+-----------+ | user | authentication_string | plugin | host | +------------------+-------------------------------------------+-----------------------+-----------+ | root | | auth_socket | localhost | | mysql.session | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost | | mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost | | debian-sys-maint | *497C3D7B50479A812B89CD12EC3EDA6C0CB686F0 | mysql_native_password | localhost | +------------------+-------------------------------------------+-----------------------+-----------+ 4 rows in set (0.00 sec)

要允许使用 root 和密码进行连接，请使用命令更新表中的值：

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Current-Root-Password'; FLUSH PRIVILEGES;

然后再次运行 select 命令，您将看到它已更改：

+------------------+-------------------------------------------+-----------------------+-----------+ | user | authentication_string | plugin | host | +------------------+-------------------------------------------+-----------------------+-----------+ | root | *2F2377C1BC54BE827DC8A4EE051CBD57490FB8C6 | mysql_native_password | localhost | | mysql.session | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost | | mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost | | debian-sys-maint | *497C3D7B50479A812B89CD12EC3EDA6C0CB686F0 | mysql_native_password | localhost | +------------------+-------------------------------------------+-----------------------+-----------+ 4 rows in set (0.00 sec)

就是这样。您可以在运行并完成sudo mysql_secure_installation命令后运行此过程。

对于 mariadb，请使用

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('manager');

设置密码。 更多信息请访问https://mariadb.com/kb/en/set-password/

使用重置root密码的说明- 但我们不会重置 root 密码，而是将强制将一条记录插入 mysql.user 表

在初始化文件中，使用它来代替

INSERT INTO mysql.user (Host, User, Password) VALUES ('%', 'root', password('YOURPASSWORD')); GRANT ALL ON *.* TO 'root'@'%' WITH GRANT OPTION;