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
Vista Home Premium (32 bit)
XAMPP version 1.7.3
Toad for MySQL 126.96.36.1995
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.