Browsing All Posts published on »April, 2014«

Enable remote connection for MySQL, multiple connections

April 1, 2014

0

1. edit /etc/mysql/my.cnf and set bind-address to 0.0.0.0. 2. if skip-networking is present, comment it out or remove it 3. restart and test: service mysql restart mysql -u remote_user_on_remote_system -pPASSWORD -h remote_system_url database_name Warning: your database security is compromised. Everyone could access it now, provided they’d know username and password. Lets limit this with firewall. […]