Unable to connect to MySQL Service using Toad for MySQL

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Unable to connect to MySQL Service using Toad for MySQL

Postby vanalljc » 31. December 2010 17:49

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
vanalljc
 
Posts: 2
Joined: 31. December 2010 17:19

Re: Unable to connect to MySQL Service using Toad for MySQL

Postby JonB » 31. December 2010 23:44

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!
:mrgreen:
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: Unable to connect to MySQL Service using Toad for MySQL

Postby vanalljc » 02. January 2011 17:33

Thanks Jon,
Hadn't even thought about the hosts file not having the ipv4 entry. :oops:
much appreciated
J
vanalljc
 
Posts: 2
Joined: 31. December 2010 17:19


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 70 guests