Error setting up connection

User, date Message
Written by James_DG
11 months ago
Category: Creating a connection
1 posts since Mon, 07 Oct 13
Hi guys,

When trying to export my files and trying to open them in HeidiSQL I continuously get an error message:

Can't connect to mySQL server on 'localhost'(10061)

Having read the other topics I've tried different ways to log in without luck.

My hosting provider informed me I should use the following login info:

Name of host/IP: localhost
Username: username_name-database
Password: password as was created.

On the other hand I've read some threads here mentioning to use the following info:
Name of host/IP:
Username: root
Password: password as was created/or blank.

All options above all not working though. Am I missing something here?

Looking forward to your reply. Thanks in advance.

Written by ansgar
11 months ago
5023 posts since Fri, 07 Apr 06
Can you connect with any other MySQL client?

If yes, please verify the port on which the server runs. Default is 3306, but it's possible to change that in your my.ini (or my.cnf) on your local MySQL server.
Written by jfalchMoney, Euro
11 months ago
406 posts since Sat, 17 Oct 09
Both localhost and designate your computer, ie the one that you are working on. Since you mention a hosting provider, I assume that you do not have a mysql server running on your computer, but want to access a database server on another computer (run by the hosting provider).
ask your provider if you are supposed to access that database by an ssh tunnel; that´s the only context in which using localhost would make sense to me. if so, let them tell you the ssh server to contact, and your username and password for it (probably different from your mysql user name and password); select connection type "mysql (ssh tunnel") in heidsql´s session manager, then enter the ssh on the second tab and retry.

Please login to leave a reply, or register at first.