hello
as a new user to heidi, i am trying to work out why i cannot create connection between my pc and server. I have entered all the correct credentials from pc but what I did notice was on the server it is currently setup for localhost and also there is no port # allocated. how do in check wahat i need to be setup on server machine to create connection? Many thanks
I am using centos6 with control panel.
PS: also I cannot seem to attach a pic here to show problem.
keep getting error #0
Ok, I guess you entered the right IP or hostname. You said
That may be the cause. You must check that on server shell, by examining your mysql.cnf/ini file. Find the setting for "skip-networking".
Or, if that's not set at all or is set to "0", then start a command line shell on MySQL and fire a
Then, if the "Host" column shows some specific IP address, localhost or whatever, that's the cause why you cannot connect from other remote computers.
on the server it is currently setup for localhost
That may be the cause. You must check that on server shell, by examining your mysql.cnf/ini file. Find the setting for "skip-networking".
Or, if that's not set at all or is set to "0", then start a command line shell on MySQL and fire a
SELECT Host, User FROM mysql.users WHERE User='yourusername'
Then, if the "Host" column shows some specific IP address, localhost or whatever, that's the cause why you cannot connect from other remote computers.
Since this is the top google result for
"
[Window Title]
Error
[Content]
SQL Error (2003) in statement #0: Can't connect to MySQL server on 'localhost' (10061)"
, I will leave my resolution here:
Try increasing the plink.exe timeout under the SSH tunnel tab of the Heidi SQL session manager window. At the default 4 seconds, I received this error. After increasing the timeout to 8 seconds, I was able to connect.
"
[Window Title]
Error
[Content]
SQL Error (2003) in statement #0: Can't connect to MySQL server on 'localhost' (10061)"
, I will leave my resolution here:
Try increasing the plink.exe timeout under the SSH tunnel tab of the Heidi SQL session manager window. At the default 4 seconds, I received this error. After increasing the timeout to 8 seconds, I was able to connect.
I found a problem of caching the server's host key... HeidiSQL doesn't spot this and prompt the user to accept it into PuTTY/Plink's local cache on the first connection.
There are two solutions:
[1] Manually establish the SSH connection using PuTTY first, in order to get the key into the local cache
or
[2] Follow the instructions on http://caseymclaughlin.com/articles/ssh-tunnels-with-plink-and-heidisql to use plink to get the server key in the cache.
There are two solutions:
[1] Manually establish the SSH connection using PuTTY first, in order to get the key into the local cache
or
[2] Follow the instructions on http://caseymclaughlin.com/articles/ssh-tunnels-with-plink-and-heidisql to use plink to get the server key in the cache.
That's a different error to the error #0 that this thread is covering. Try looking at this solution for error 10060: http://forums.mysql.com/read.php?34,49742,239961
Please login to leave a reply, or register at first.