Oops ! Can't connect to my MySQL Server using HeidiSQL !!!
| User, date | Message |
|---|---|
|
Written by Null4Ever
2 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
2 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
2 years ago 4026 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. |