1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

SSMS to web hosted MySQL

Discussion in 'HTML, Graphics & Programming' started by AHarvey, Apr 28, 2018.

  1. AHarvey

    Sgarrista

    Joined: Mar 6, 2008

    Posts: 8,929

    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.
     
  2. AHarvey

    Sgarrista

    Joined: Mar 6, 2008

    Posts: 8,929

    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.
     
  3. Shoeyuk

    Gangster

    Joined: Jan 31, 2018

    Posts: 212

    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.
     
  4. Dj_Jestar

    Caporegime

    Joined: Oct 18, 2002

    Posts: 28,283

    Location: Back in East London

    SSMS does not support MySQL. It does, however, support ODBC - so create a DSN with MySQL drivers and you should be able to do some stuff through that.

    e: just noticed I'm just echoing the above.
     
  5. touch

    Capodecina

    Joined: Oct 28, 2006

    Posts: 10,530

    Location: Sufferlandria

    I like MySQL Workbench best for MySQL databases.
     
  6. billysielu

    Sgarrista

    Joined: Aug 9, 2009

    Posts: 9,781

    Location: Oxfordshire

    +1