Pre-General Availability: 2023-05-24
To configure a basic connection to a MySQL server instance running locally or remotely:
mysqlfrom the Database Type list. Provide a caption and a description to identify the connection.
In the Basic tab, enter the host name, protocol, user account information, and password.
Host Name or IP Address
The host name or IP address of the MySQL server. The host name
localhostmight resolve to
::1on your host, so note this when checking permissions.
Establishes the connection using classic MySQL protocol.
Establishes the connection using X Protocol.
The TCP/IP port on which MySQL Server is listening. The default values are:
3306 for classic MySQL protocol
33060 for X Protocol
The MySQL user account to use for the connection.
Optional password for the account used. If you enter no password here, you are prompted to enter the password when the MySQL Shell for VS Code extension attempts to establish the connection. MySQL Shell for VS Code can store the password for a connection using a secret store, such as a keychain.
Removes a stored password.
When the connection to the server is established, this option sets the schema that becomes the default schema for use in other parts of MySQL Shell for VS Code. For simplicity, you can leave the default schema value blank during the initial setup and set the default value later, as needed.