Need Help Setting Up Separate MySQL Database Server

Portal Home > Knowledgebase > Articles Database > Need Help Setting Up Separate MySQL Database Server

Posted by BamaStangGuy, 04-05-2012, 01:01 PM
I am trying to setup a dedicated MySQL server that my Web Server can connect to but I am having issues and I think it may be iptables related. This is on Centos 6 Here is what I have done so far: 10.179.133.27 = Web Server Private IP 10.179.130.242 = Database Server Private IP Installed MySQL and have it running successfully. I have created the database and imported the data I need into it. I can query the database fine from the database server. I then created a user and gave it permission for that database. 10.179.133.27 is my webserver private IP. This is the iptables on my database server: Web Server iptables: My xenforo config: Trying to connect via web server: my.cnf file: What am I missing or doing wrong?
Posted by LnxtecH, 04-05-2012, 09:27 PM
Stop firewall on both servers and then try. We can then see if its a firewall issue or not.
Posted by dewaforex, 04-05-2012, 09:34 PM
you're wrong in there, you should put your database IP when create user.
Posted by jeff1987, 04-06-2012, 02:39 AM
dewaforex is right. Also I would say I had some issues while having that reject-with icmp-host-prohibited rule in iptables and had to remove it while configuring remote mysql. Thanks Jeff