VSCode中SQLTools连接MySQL遇Access denied错误,求解决方法
MySQL连接权限错误排查请求
我是MySQL初学者,在Windows系统的VSCode中执行建表操作,SQL代码如下:
CREATE TABLE Users( id INT PRIMARY KEY AUTO_INCREMENT, email VARCHAR(255) NOT NULL UNIQUE, bio TEXT, country VARCHAR(2) );
执行时触发以下错误:
Error fetching records. Access denied for user 'Save password'@'localhost' (using password: YES)
来源:SQLTools(Extension)
输出栏日志如下:
[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的“Help!”按钮跳转的错误帮助页面不存在,请求帮忙解决该问题。
内容的提问来源于stack exchange,提问作者William V. West
相关产品推荐
相关产品推荐

