mysql remote connection

For a remote database setup since MySQL must be able to listen for an external IP address where the server can be reached. To enable this, open up your mysqld.cnf file: sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf It will look like this: . . . lc-messages-dir = /usr/share/mysql skip-external-locking # # Instead of skip-networking the default is now to listen only on…