#######MySQL ALLOW REMOTE ACCESS####### Allowing remote connection to MySQL server (running on Debian-based distribution): 1. # vi /etc/my.cnf 2. Once file opened, locate line that read as follows: [mysqld] 3. Make sure line skip-networking is commented (or remove line) and add following line: bind-address=YOUR-SERVER-IP 4. # /etc/init.d/mysql restart 5. $ mysql -u root -p mysql mysql> GRANT ALL ON NetMon.* TO 'test_user'@'192.168.1.1' IDENTIFIED BY 'test_pass'; mysql> exit 6. For Linux firewall: # /sbin/iptables -A INPUT -i eth1 -s 192.168.2.0/24 -p tcp --destination-port 3306 -j ACCEPT # service iptables save 7. Testing, from the remote system: $ mysql -u test_user ???h 192.168.1.1 ???p
dmx2io2