Vscode-mssql: Cannot connect to MySQL Server

Created on 7 Dec 2018  路  2Comments  路  Source: microsoft/vscode-mssql

  • MSSQL Extension Version: 1.4.0
  • VSCode Version: 1.29.1
  • OS Version: Windows 10

Steps to Reproduce:

  1. I did everything that is said here https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-develop-use-vscode?view=sql-server-2017
  2. But I always get an error: mssql: Error 2: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I can connect to MySQL via MySQL Workbench without any problem using localhost:3306 (host), root (login), password. But when I type it in VS Code it won't work.
What else I tried as a host: localhost; localhost,3306; root@localhost; the name of the computer. With some combinations, I get another error "mssql: Error 53: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)".
My login and password are 100% correct.
What am I doing wrong? I would appreciate any help a lot. The extension is too cool to give up, I realy need it.

Most helpful comment

@r1msky-dev this extension only supports Microsoft SQL Server, not MySQL, so unfortunately you'll need to look for another extension if you want to use vscode with MySQL.

If you're having trouble connecting to Microsoft SQL Server though let me know

All 2 comments

@r1msky-dev this extension only supports Microsoft SQL Server, not MySQL, so unfortunately you'll need to look for another extension if you want to use vscode with MySQL.

If you're having trouble connecting to Microsoft SQL Server though let me know

I am having trouble connecting to the mysql server.

Was this page helpful?
0 / 5 - 0 ratings

Related issues

Raymondd picture Raymondd  路  4Comments

leonardder picture leonardder  路  5Comments

casraysa picture casraysa  路  7Comments

ransagy picture ransagy  路  8Comments

GabrielDuarteM picture GabrielDuarteM  路  6Comments