DrAxeman Posted February 12, 2003 Share Posted February 12, 2003 When ever I try to connect to my MySQL server from a remote client I get the error: ERROR 2013: Lost connection to MySQL server during query when I check the MySQL log it says: Number of processes running now: 1 mysqld process hanging, pid 3131 - killed 030212 14:49:14 mysqld restarted /usr/libexec/mysqld: ready for connections ANY and ALL suggestions will be appreciated. I have spent FAR too much time on this. Dr. Axeman Link to comment https://forums.phpfreaks.com/topic/145-mysql-connection-error/ Share on other sites More sharing options...
DrAxeman Posted February 12, 2003 Author Share Posted February 12, 2003 All of this happens when: [root@vergason phpMyAdmin-2.3.2]# mysql -u alex -h 192.168.0.203 ERROR 2013: Lost connection to MySQL server during query (NOTE: a password is required) Link to comment https://forums.phpfreaks.com/topic/145-mysql-connection-error/#findComment-433 Share on other sites More sharing options...
effigy Posted February 12, 2003 Share Posted February 12, 2003 does that command ever prompt you for a password? if not, add a -p switch. you may also take a look at your my.cnf regarding timeouts - i do not know much regarding remote issues :shock: Link to comment https://forums.phpfreaks.com/topic/145-mysql-connection-error/#findComment-434 Share on other sites More sharing options...
DrAxeman Posted February 12, 2003 Author Share Posted February 12, 2003 It never asked for a password. It just kicks out the error. When I use the -p option it will ask for one, and then give the error. I can connect from the console of my MySQL server. Link to comment https://forums.phpfreaks.com/topic/145-mysql-connection-error/#findComment-435 Share on other sites More sharing options...
DrAxeman Posted February 13, 2003 Author Share Posted February 13, 2003 Some versions of MySQL will crash when attempting to perform a DNS lookup. Hence it was crashing when trying to resovle alex.vergason.com... when I places the placed the following entry into the /etc/hosts file everything worked just fine. 192.168.0.77 alex.vergason.com Strange, but a workaround none the less. Dr. Axeman - Really a Linux Geek, wannabe MySQL geek. Link to comment https://forums.phpfreaks.com/topic/145-mysql-connection-error/#findComment-439 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.