Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
1 of 5 tasks
S0ULC0DER opened this issue Mar 19, 2024 · 4 comments
Labels
mysql MySQL / MariaDB driver triage

Comments

@S0ULC0DER
Copy link

S0ULC0DER commented Mar 19, 2024

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):

  • SQLTools Version [e.g. v0.17.x]
  • VS Code Version: [e.g 1.x.y]
  • OS: [e.g. Windows, Linux, Mac]
  • Driver:
    • PostgreSQL/Redshift
    • MySQL/MariaDB
    • MSSQL/Azure
    • SQLite
    • Other? Which...
  • Database version: [e.g. MySQL v5.6, PostgreSQL vX...]

Additional context
Add any other context about the problem here.

@S0ULC0DER
Copy link
Author

mysql latest version windows

@S0ULC0DER
Copy link
Author

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
Copy link
Author

[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

@gjsjohnmurray gjsjohnmurray added the mysql MySQL / MariaDB driver label Apr 11, 2024
@Fludem
Copy link
Contributor

Fludem commented Apr 27, 2024

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
mysql MySQL / MariaDB driver triage
Projects
None yet
Development

No branches or pull requests

3 participants