Add the following line in your /etc/csf/csf.allow on both the server,
vi /etc/my.cnfport = 3306
bind-address=YOUR-SERVER-IP
# skip-networking -- Hash this entry
/etc/init.d/mysql restart
Grant access to remote IP address
Login to MySQL
mysql -u root –p mysql
If the remote Ip is 123.12.12.21
then use the below command
GRANT ALL ON db.* TO dbuser@'123.12.12.21' IDENTIFIED BY 'PASSWORD';
Then, allow access using the below command,
tcp|in|d=3306|s=192.168.x.x
tcp|out|d=3306|d=192.168.x.x
Restart csf with : csf -r
vi /etc/my.cnfport = 3306
bind-address=YOUR-SERVER-IP
# skip-networking -- Hash this entry
/etc/init.d/mysql restart
Grant access to remote IP address
Login to MySQL
mysql -u root –p mysql
If the remote Ip is 123.12.12.21
then use the below command
GRANT ALL ON db.* TO dbuser@'123.12.12.21' IDENTIFIED BY 'PASSWORD';
Then, allow access using the below command,
tcp|in|d=3306|s=192.168.x.x
tcp|out|d=3306|d=192.168.x.x
Restart csf with : csf -r