Reply to comment

Enable remote access to MySQL the easiest way

Submitted by david on Thu, 13/03/2008 - 09:18
in

Due to specific necessities in a project that dbloop is developing, we need to enable remote access to MySQL database form the other machines in our LAN. It isn't so easy to find good information about this issue. There are many posts but don't give clear info about how to solve it. Finally, a post gives us the solution.

Simply opening port access to 3306 (default port for MySQL service) in the IPtables files. Run the following command from the operating system console.

iptables -I RH-Firewall-1-INPUT -p tcp --dport 3306 -j ACCEPT

You need also to define database users giving the "Server" values as "%", hostname, or MySQL server IP.

We make it work on Fedora Linux.

Hope it works.

Reply