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: 127.0.0.1
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.
James.
Error setting up connection
Both localhost and 127.0.0.1 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.
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.