Remote access ot Mysql on Centos

[onmoon]

Finally moved to linux --centos 5.3 32bit. The installation is very easy and straight. Got everything done, PHP, Mysql, Apache, not the latest version, but working. Now, I want to remotely access this machine's Mysql database, but failed. Googled, not very helpful because I'm really new to linux. Seems many factors could affect this, such as firewall (say iptables), the privileges of mysql.

Please help or post some userful information here.

[oracleguy]

The first place I would check is your MySQL configuration file. Network access can be enabled and disabled there. I don't know where it is on CentOS though. The file is called my.cnf, it might be under /etc/mysql but if it isn't, you can search for it.

[onmoon]

oracleguy, thank you for your reply.

Many people say I need to comment on the line "--skip-networking", but I didn't find this line with my.cnf. So I think the network access is enabled..

[onmoon]

And I also tried to give the remote address privileges within mysql.

mysql> grant all privileges on *.* to 'myuser'@'192.168.*.*' identified by 'mypwd';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

The cmd lines above is to grant my on of my lan IP, I also did one on a remote IP address, neither of them worked.

[onmoon]

More symptoms:

After some unsuccessfully config and restart, I tried to access that machine via port 80, HTTP. I will open a PHP file via Wan or Lan, and the PHP will connect Mysql. The PHP scripts only work when I set the server host as "localhost", if not, such as its own LAN IP, the scripts will return errors like:

Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /var/www/html/test.php on line 19

[oracleguy]

What happens when you try to connect to the MySQL server from a different computer on the network? Does it say the connection was refused or timed out or did it give you an access denied message?

[onmoon]

What happens when you try to connect to the MySQL server from a different computer on the network? Does it say the connection was refused or timed out or did it give you an access denied message?

Thank you for the reply. it is solved, but I didn't do anything, strange. After restart, it's just working as expected. but it doesn't need a restart...