Unable to connect to MySQL Service using Toad for MySQL

[vanalljc]

Hi,
I'm hoping someone can help me with a small configuration(?) issue. I've been using Toad for MySQL for some time now, and have recently installed XAMPP on my home pc. The XAMPP installation went flawlessly, I've installed MySQL as a service, created a root password, edited the config.inc.php file and can admininster databases without issue through phpMyAdmin. That said, I'm much more comfortable working in Toad, and would like to continue using it. Unfortunately, I cannot seem to connect to the MySQL service

What I can not do;
Connect to the MySQL service (installed with XAMPP) using Toad for MySQL. I get the following error message -- "Unable to connect to any of the specified MySQL hosts."

What I can do:

Start or stop the MySQL service from Toad,
- the status of the service changes in XAMPP Control Panel
- the status of the service changes in Windows Task Manager
Connect to MySQL using phpMyAdmin
Connect to production server over VPN using Toad

Installation:
Vista Home Premium (32 bit)
XAMPP version 1.7.3
Toad for MySQL 5.0.0.345

The long and short of it is Toad works, XAMPP works, I just can't get them to play well together. Has anyone had this issue and been able to resolve it?
Thanks, and a Happy New Year to all.
J

[JonB]

Its probably one of two things, both IP/Socket related.

1st - does your hosts file contain a line like this?

localhost 127.0.0.1

If not, add one - the MS DNS resolver defaults to resolving localhost to the IPv6 address ::1

If you already had that line, or it does not fix the issue:

2nd - MySQL works with two kinds of sockets - the MySQL socket, which is a LOCAL socket (and the default in XAMPP), and its TCP/IP socket which is host/IP oriented. That error message might mean Toad is looking for a hostname in DNS resolvable/TCP/IP format.

Although this was NOT the problem in this topic, I have all the changes for MySQL to work with TCP/IP sockets needed in the thread.
viewtopic.php?f=16&t=42567&p=167604&hilit=+socket#p167604

Good Luck & Happy New Year!

[vanalljc]

Thanks Jon,
Hadn't even thought about the hosts file not having the ipv4 entry.
much appreciated
J