Mysql Error: Lost Connection to Mysql during query
 

Hi guys,
I am a newbie to linux and I just manage to get some basic commands running on a Red Hat 8 box. So please be detailed in explaining to me. I finished installing Red hat 8 along with Mysql, PHP, Apache etc. I am not able to connect to the mysql database from any machine on the network though I am able to log on to mysql locally on the linux box. I am also able to access mysql via php installed on the same box. But from any other mac on the network it gives an error "Lost connection to mysql during query". I have checked up the mysql users table and it enables all hosts (%) with the root user name and null pass. Can anyone give me any possible solns. Also I am able to connect to mysql via ssh login as well.

Thanks

Probably MySQL doesn't accept network connections (for security reasons). You need to take a look at /etc/my.cnf (or the path the my.cnf is located within your distribution).

If you come accross skip-networking erase that part since it disables network access ... for more information please consult www.mysql.com

Thanks for the reply. I checked out my.cnf. It is not having any thing like skip-networking. Please let me know if there are any other possible solns.

post your my.cnf

This is the my.cnf file in my /etc directory:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
port=3306
skip-innodb

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

what does /var/log/mysqld.log say? anything interesting? did you do flush privileges after granting access?