mtxr / vscode-sqltools

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

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

Open GusarevKirill opened 1 year ago

GusarevKirill commented 1 year ago

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

Additional context Add any other context about the problem here.

jacrys commented 1 year ago

try adding a connectionTimeout to your settings for the connection

GusarevKirill commented 1 year ago

try adding a connectionTimeout to your settings for the connection

It didn't help