SSMS to web hosted MySQL

[AHarvey]

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]

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.