我是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,但未找到页面。非常感谢,希望你今天过得愉快。
1条答案
按热度按时间yhuiod9q1#
连接设置中的用户名应该与MySQL用户名相同。要查找用户名,请运行MySQL 8.0命令行客户端,输入MySQL密码,然后运行以下命令:
这将返回
MySQL的用户名是@localhost之前的内容
所以在VScode SQLTool设置中输入这个,它就会工作。