CODEWITHSUNDEEP
mysqlvisual-studio-code
Dameon Quispe-Julian
Dameon Quispe-Julian

Reputation: 41

client option 'pooling.maxidletime' does not support value 'nan'

Using VS Code MySQL, I get this error:

client option 'pooling.maxidletime' does not support value 'nan'

The issue is coming from the SQLTools extension connection on VS Code.

Upvotes: 4

Views: 10178

Answers (2)

Johnny Joca
Johnny Joca

Reputation: 1

  • Go to the client command line, type your password.
  • Type create database database_name and press enter.
  • Go to VS Code and tap in the SQL icon at your left or right.
  • Create a new connection.
  • Select MySQL.
  • Provide the details, make sure that your database name is, as mentioned above, database_name, and make sure that user is the same as when you're installing MySQL, the same goes to the password.
  • Select connect now.
  • Type your SQL code.
  • Save it. 2 files will pop up, and that's normal.
  • Click run on active connection.

Upvotes: 0

6seafu66
6seafu66

Reputation: 11

Try adding the connectionTimeout parameter in your connection settings, like so:

{
  "mysqlOptions": {
    "authProtocol": "xprotocol"
  },
  "previewLimit": 50,
  "server": "localhost",
  "port": 33060,
  "driver": "MySQL",
  "name": "MySQL_v8",
  "database": "some-db",
  "username": "root",
  "password": "123456789",
  "connectionTimeout": 15
}

More on this in here.

Upvotes: 1

Related Questions