This has been frustrating me all day. I am trying to install MySQL and use it with Navicat but have been unable to do so.
I have installed MySQL and have the MySQL service up and running in XP. But I cannot connect to the service using Navicat. I get a "2003 - Can't connect to MYSQL server on 'localhost' (10061).
I've went through the some guides on how to install MySQL from this website and used Navicat's support on getting started with Navicai. Have followed all the instructons and have left every thing on default upon installing.
In Navicat, the connection properties are such:
Hostname/ IP address: localhost
The port 3306 is open and accepting connection to my ip addres.
So what is the problem here?
pass: the pasword for my root