Unable to connet to MySQL server

brunomydac · Post by **brunomydac** » Fri 26 Dec 2008 05:41

Hi.

I"m evaluating the Devart products.

I have installed the MySQL Server (5.1) and am running it as a Service on an Win XP machine. It is working fine, I can control using the command line.

I installed the trial version of your MyDAC components (for D5). I am able to connect to the server, and a test database.

However, I am also trying 'dbForge Studio for MySQL' (which I just downloaded .. v 3.10.205). I am unable to connect to the MySQL server. I always get this message :

"Can't connect to MySQL server on 'localhost' (10061)"

I did shut down all firewall and anti-virus, but it still does the same thing.

Any recommendations?

Thanks!

Duke · Post by **Duke** » Fri 26 Dec 2008 08:06

If I understood correctly you situation was the following: you had local MySQL server and it was running. You tried to create connection in dbForge Studio for MySQL and specified 'localhost' value for host parameter and got the error message.
Then check MySQL port setting to make sure that right port number is specified for connection.

brunomydac · Post by **brunomydac** » Fri 26 Dec 2008 19:55

Hi again.

The default port, 3306, is being used, by both the server, and my attempts to connect using dbForge.

What is very strange is that I am able to establish the connection programmatically (Delphi 5, MyDac), using the same port, same user (root) etc.

thanks.. Bruno

Duke · Post by **Duke** » Thu 08 Jan 2009 11:20

The only thing I can suggest in this situation is that you played with security settings and left incorrect values. This may result in such error.
Or, maybe, there are facts that I don't know about the situation.