distal-attribute
distal-attribute
distal-attribute
distal-attribute

Oops ! Can't connect to my MySQL Server using HeidiSQL !!!

User, date Message
Written by Null4Ever
3 years ago
Category: Creating a connection
2 posts since Mon, 26 Sep 11
Hi everyone,

Can someone try to explain to the newbee that I'm where I'm wrong ?

I've a problem to connect to my MySQL Server when using HeidiSQL when in the same time I can connect to PhpMyAdmin.

Here is my configurations :

The MySQL Server is installed on a PC with Ubuntu 10.04 LST and the LAN IP address of this PC is : 192.168.10.51

HeidiSQL is installed on a second PC with MS Windows 7 Ultimate 64 bits, and the IP address of this second PC is : 192.168.10.23 (of course on the same physical LAN than the MySQL Server).

From my Windows PC, I can access to the PHPMyAdmin program of the MySQL Server via Firefox with the following address : http://192.168.10.51/phpmyadmin/

However, I can't access to the MySql Server when using HeidySQL even when using the right user ID and Password.

When I try to connect, I receive the following error message : "SQL Error (2003) : Can't connect to MySQL Server on '192.168.10.51' (10061)" as you can see with the following screen capture.

http://www.as2.com/linux/ubuntu-10.04/img/heidi-01.html

Your help will be very appreciated.

Thank you in advance for your time.

Cheers.
Written by Null4Ever
3 years ago
2 posts since Mon, 26 Sep 11
Oops, sorry the link is here :

http://www.as2.com/linux/ubuntu-10.04/img/heidi-01.html

TIA for your help.
Written by ansgar
3 years ago
4940 posts since Fri, 07 Apr 06
Analyze the root user and its privileges. Check if it may connect from "%" or at least from "192.168.10.%". The error looks exactly as it if that's not the case. Or did you even use different usernames in PMA and HeidiSQL?
 

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