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

Error opening connection Client option 'pooling.maxIdleTime' does not support value 'NaN' #1075

Open
1 of 5 tasks
GusarevKirill opened this issue Dec 30, 2022 · 2 comments
Open
1 of 5 tasks
Labels

Comments

@GusarevKirill
Copy link

GusarevKirill commented Dec 30, 2022

Describe the bug
I installed an extension and driver into VS Code but can't connect to MySQL. Error: "Error opening connection Client option 'pooling.maxIdleTime' does not support value 'NaN'". Also I tryed 33060 port and xprotocol auth method but i see the same error.

To Reproduce
Steps to reproduce the behavior:

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

Expected behavior
I want connect to my MySQL database.

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

Desktop (please complete the following information):

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

Additional context
Add any other context about the problem here.

@jacrys
Copy link

jacrys commented Jan 13, 2023

try adding a connectionTimeout to your settings for the connection

@GusarevKirill
Copy link
Author

try adding a connectionTimeout to your settings for the connection

It didn't help

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants