mtxr / vscode-sqltools

Database management for VSCode
https://vscode-sqltools.mteixeira.dev?utm_source=github&utm_medium=homepage-link
MIT License
1.52k stars 306 forks source link

when i enter the password for connecting mysql and when i click test connection nothing is happening #1299

Open S0ULC0DER opened 8 months ago

S0ULC0DER commented 8 months ago

Describe the bug A clear and concise description of what the bug is.

To Reproduce Steps to reproduce the behavior:

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. See error

Expected behavior A clear and concise description of what you expected to happen.

Screenshots If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

Additional context Add any other context about the problem here.

S0ULC0DER commented 8 months ago

mysql latest version windows

S0ULC0DER commented 8 months ago

when i use 3306 as port nothing happens but when i use 33060 as port number it takes a long time and says Connection lost: The server closed the connection.

S0ULC0DER commented 8 months ago

[1710872733204] INFO (ext): EXECUTING COMMAND => sqltools.getConnections [1710872733206] INFO (ls): REQUEST RECEIVED => connection/GetConnectionsRequest [1710872746515] INFO (ext): EXECUTING COMMAND => sqltools.selectConnection [1710872746515] INFO (ext): EXECUTING COMMAND => sqltools.getConnections [1710872746516] INFO (ls): REQUEST RECEIVED => connection/GetConnectionsRequest [1710872746517] INFO (ext): EXECUTING COMMAND => sqltools.getConnections [1710872746518] INFO (ls): REQUEST RECEIVED => connection/GetConnectionsRequest [1710872746518] INFO (ls): REQUEST RECEIVED => connection/GetConnectionPasswordRequest [1710872748700] INFO (ls): REQUEST RECEIVED => connection/ConnectRequest [1710872748700] INFO (ls): Connection instance created for sql1. 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 [1710872748715] ERROR (ls): {"code":-1,"data":{"driver":"MySQL","driverOptions":{"mysqlOptions":{"authProtocol":"default","enableSsl":"Disabled"}}},"name":"Error"} ns: "conn" [1710872748715] ERROR (ls): Connecting error: {"code":-1,"data":{"driver":"MySQL","driverOptions":{"mysqlOptions":{"authProtocol":"default","enableSsl":"Disabled"}}},"name":"Error"} ns: "conn-manager" [1710872748715] ERROR (ls): Open connection error ns: "conn-manager" [1710872748716] ERROR (ext): ERROR: Error opening connection Unknown database 'def', {"code":-1,"data":{"driver":"MySQL","driverOptions":{"mysqlOptions":{"authProtocol":"default","enableSsl":"Disabled"}}}} ns: "error-handler" [1710872754132] INFO (ext): EXECUTING COMMAND => sqltools.showOutputChannel

Fludem commented 7 months ago

Would you mind sharing your settings with any sensitive information redacted?