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

Cannot connect to another server on the network.

User, date Message
Written by rzlines
4 years ago
Category: Creating a connection
3 posts since Mon, 12 Apr 10
I have installed Heidi on 2 computers on an internal network. These computers also have XAMPP installed on both computers. I am able to successfully connect to the MySql databases hosted on the same computer.

When I try to connect to the MySQL databases which are hosted on the 2nd computer via IP, I get an error saying that I'm not allowed to connect to that database. When i connect to the same database on the other computer via PhpMyAdmin(i use the local IP to connect)it connects successfully. I have set all the firewall permissions to allow Heidi on the network.
Written by ansgar
4 years ago
4936 posts since Fri, 07 Apr 06
pma connects from localhost to localhost in your case. Your MySQL users are restricted to connect from localhost only. Just allow "%" as hostname for these user accounts and the other pc should be able to connect.
Written by rzlines
4 years ago
3 posts since Mon, 12 Apr 10
How do allow % as a hostname? Is this a setting in heidi or apache.
Written by ansgar
4 years ago
4936 posts since Fri, 07 Apr 06
In MySQL's user accounts. You can manage your users in Heidi via "Tools" > "User manager". Then, click on the user which cannot connect and set its host to "%".
Written by rzlines
4 years ago
3 posts since Mon, 12 Apr 10
Thanks a lot that worked! happy
Written by stu
2 years ago
1 posts since Tue, 13 Mar 12
I have the same issue between 2 pcs, windows vista containing a vm of debian running xampp. 2 different IPaddresses. Im trying to manage the mysql on linux from windows. (as well as PMA) I tried setting the 3 instances of root in users "host" to % and it didnt work.
 

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