keep getting error #0
| User, date | Message |
|---|---|
|
Written by ploppy
9 months ago Category: Creating a connection 2 posts since Sun, 02 Sep 12 |
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. |
|
Written by ansgar
9 months ago 3952 posts since Fri, 07 Apr 06 |
You could post the text of the error message. Did you know that, in any Windows error popup dialog, you can press Ctrl+C to get the message into your clipboard. |
|
Written by ploppy
8 months ago 2 posts since Sun, 02 Sep 12 |
good idea. here is the error: [Window Title] Error [Content] SQL Error (2003) in statement #0: Can't connect to MySQL server on 'xx.xxx.xxx.xx' (10061) [OK] |
|
Written by ansgar
8 months ago 3952 posts since Fri, 07 Apr 06 |
Ok, I guess you entered the right IP or hostname. You said ploppy wrote: 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. |
|
Please login to leave a reply, or register at first. |