Connect to MYSQL Remotely

Edit the my.cnf file

# vi /etc/my.cnf

[mysqld]
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
language        = /usr/share/mysql/English
bind-address    = 65.55.55.2
# skip-networking     <-- make sure to comment out this line

Restart  mysql service

service mysqld restart

———– and that’s it 🙂 enjoy ——————–

Leave a comment

Up ↑