TMyConnection.Open is too slow

[devweb]

Hello,

When I try to Open TMyConnection on design mode, it took too much time, I use the direct mode with user has all the privilege for the database I want to use, when I change the host to "localhost" instead of computer name and using Root user, it's open very fast, why if I use the computer name instead of localhost, opening connection is slow?

btw, I don't run any firewall

Regards,

[tltmusashi]

if u use remote DB, u must set params on MySQL my.ini
write this on the end of file

Code: Select all

#Don't cache host names.
skip-host-cache
#Don't resolve hostnames. All hostnames are IP's or 'localhost'.
skip-name-resolve

[devweb]

thanks tltmusashi,

however, i'm still facing the same problem, I just use the mysql and mydac on the same Pc, and don't connect to remote db, it's strange that it's too slow to open connection even i dont' have any tables on the db

[Dimon]

It is possible that it is related to problems with network.
Try connecting to MySQL server with Telnet using computer name. If connection opens too slow, try changing network settings.