> I am writing multi-thread C codes to connect to MySQL, but something =
> strange happened:
> I have to put the mysql_real_connect in a while loop, and exit only if =
> it succeed.
> This is because sometimes I will get the error: Can't connect to local =
> MySQL server through socket '/tmp/mysql.sock' (146), and I have to retry =
> several times.
> Can anybody tell me how to solve it? It is a little "expensive" to do a =
> while loop......
> I am running mysql-3.22.23b on Solaris 7x86, and the client library is =
> compiled with thread option.
> The mysql is started with max_connections =3D 200, and the client =
> program has only 50 threads.
> Thanks in advance.
(~) perror 146
Try increasing the mysqld 'back_log' variable. If this doesn't help you have
to check your man pages for the reason of 'connection refused' to a