SSMS to web hosted MySQL

AHarvey

AHarvey

AHarvey

Soldato
Joined
6 Mar 2008
Posts
10,078
Location
Stoke area
Hi all,

I'm having some issues I hope you can help me with.

I'm with Krystal hosting and I've created a MySQL database on there via CPanel. I've created a user and I've given my home IP MySQL access.

I am using the latest version of SSMS and I am just unable to connect.

Details I have are:
IP_ADDRESS of my webhost
DBASE_NAME
SQL_ADMIN_NAME
SQL_ADMIN_PWD

So I've set SSMS to connect to a Server Type of Database Engine
Authentication is SQL Server Authentication

Login and Password are those of the SQL_ADMIN account

Server Name, I've tried just the IP_ADDRESS as well as variations of the IP_ADDRESS\DBASE_NAME but I get one of 2 errors:

named pipes provider error 40 (this is just IP address)
SQL network interfaces error 26

Any advice?

PS, Yes I've also contacted their support who advised me to allow my IP which I'd already done.
 

AHarvey

AHarvey

AHarvey

Soldato
OP
Joined
6 Mar 2008
Posts
10,078
Location
Stoke area
They sent me details and a port over, URL is for the same IP address I have and the port is 3306.

Still couldn't connect via SSMS but I've installed DBeaver and it downloaded, installed and connected in less than 5 minutes.

guessing it's a problem with SSMS and MySQL connections, something to troubleshoot later on.
 

Shoeyuk

Shoeyuk

Shoeyuk

Associate
Joined
31 Jan 2018
Posts
539
Location
Bury St Edmunds
Didn’t think that SSMS had native support for MySQL, although I did hear once you could look at setting up an connection using the MySQL ODBC driver and add a linked server to SSMS but never tried it as deemed it was just faster to use the two separate programs.
 
You must log in or register to reply here.
Back
Top Bottom