MySQL -获取记录时出错,用户“保存密码”@“localhost”的访问被拒绝

omvjsjqw  于 12个月前  发布在  Mysql
关注(0)|答案(1)|浏览(137)

我是MySQL的初学者。我在Windows上使用VsCode,并在9:23将代码复制到Youtube教程中:[youtube](https://youtu.be/Cz3WcZLRaWc?t=563)下面是代码:
CREATE TABLE Users( id INT PRIMARY KEY AUTO_INCREMENT, email VARCHAR(255) NOT NULL UNIQUE, bio TEXT, country VARCHAR(2) );
当运行时,我遇到了这个错误:
获取记录时出错。用户“保存密码”@“localhost”访问被拒绝(使用密码:资料来源:SQLTools(扩展)
输出栏返回以下消息:

[1697130812674] INFO  (ext): EXECUTING COMMAND => sqltools.getConnections
[1697130812675] INFO  (ls): REQUEST RECEIVED => connection/GetConnectionsRequest
[1697130812676] INFO  (ls): REQUEST RECEIVED => connection/ConnectRequest
[1697130812677] INFO  (ls): Connection instance created for test.
ns: "conn-manager"
Ignoring invalid configuration option passed to Connection: authProtocol. This is currently a warning, but in future versions of MySQL2, an error will be thrown if you pass an invalid configuration option to a Connection
Ignoring invalid configuration option passed to Connection: enableSsl. This is currently a warning, but in future versions of MySQL2, an error will be thrown if you pass an invalid configuration option to a Connection
[1697130812680] ERROR (ls): {"code":-1,"data":{"driver":"MySQL","driverOptions":{"mysqlOptions":        {"authProtocol":"default","enableSsl":"Disabled"}}},"name":"Error"}
ns: "conn"
[1697130812680] ERROR (ls): Connecting error: {"code":-1,"data":{"driver":"MySQL","driverOptions":    {"mysqlOptions":{"authProtocol":"default","enableSsl":"Disabled"}}},"name":"Error"}
ns: "conn-manager"
[1697130812680] ERROR (ls): Open connection error
ns: "conn-manager"
[1697130812679] ERROR (ext): ERROR: Error fetching records. Access denied for user 'Save password'@'localhost' (using password: YES), {"code":-1,"data":{"driver":"MySQL","driverOptions":{"mysqlOptions":{"authProtocol":"default","enableSsl":"Disabled"}}}}
    ns: "error-handler"

如何解决此问题?VSCode上的“帮助!”按钮打开了此网站https://vscode-sqltools.mteixeira.dev/connections/mysql#Error,但未找到页面。非常感谢,希望你今天过得愉快。

yhuiod9q

yhuiod9q1#

连接设置中的用户名应该与MySQL用户名相同。要查找用户名,请运行MySQL 8.0命令行客户端,输入MySQL密码,然后运行以下命令:

SELECT CURRENT_USER();

这将返回

+----------------+
| CURRENT_USER() |
+----------------+
| username@localhost |
+----------------+
1 row in set (0.01 sec)

MySQL的用户名是@localhost之前的内容
所以在VScode SQLTool设置中输入这个,它就会工作。

相关问题