How do I allow MySQL access to Virtualmin from another server on the same network?

3 posts / 0 new
Topic locked
Last post
#1 Fri, 06/01/2012 - 10:12
-eclipse-

How do I allow MySQL access to Virtualmin from another server on the same network?

Hi All

I have tried to get this working without luck. I need to grant access to the MySQL database within the Virtualmin instance from another web server on the same network. I have tried to locate the "bind-address" variable in the my.cnf file located in /etc/ but there was none, so I added the "bind-address" variable with the 0.0.0.0 in IP as mentioned in the following post :

http://www.virtualmin.com/node/18444

I have also added 2 new FireWall accept rules to allow port 3306 in both TCP and UDP. After that I restarted the MySQL service.

But I am still not able to telnet to the server on port 3306 from the other server on the same network.

What do I miss to get this one working??

Thanks in advance.

  • Tim
Fri, 06/01/2012 - 10:35
-eclipse-

Hi All

I found this topic : https://www.virtualmin.com/node/22295

But he ended up disabling "IPTABLES" (firewall). When I stop "IPTABLES" I can connect to the MySQL Server from another server??

What do I miss in the FireWall settings since the access rule I have done doesn't work.

Thanks in advance.

  • Tim
Fri, 06/01/2012 - 10:41
-eclipse-

Hi All

Sorry for my post. The accept rule was placed under the last incoming rule called "Run chain RH-Firewall-1-INPUT Always". I moved the rule above this one, and now it works when "IPTABLES" (firewall) is running :)

  • Tim
Topic locked