when i enter the password for connecting mysql and when i click test connection nothing is happening
S0ULC0DER opened this issue · 4 comments
Describe the bug
A clear and concise description of what the bug is.
To Reproduce
Steps to reproduce the behavior:
- Go to '...'
- Click on '....'
- Scroll down to '....'
- 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.
mysql latest version windows
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.
[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
Would you mind sharing your settings with any sensitive information redacted?