Allow remote connection to MySQL

mysql-remote.sh

1. Edit the config file
vi /etc/mysql/mysql.conf.d/mysqld.cnf

Change
bind-address            = 127.0.0.1
to
bind-address            = 0.0.0.0

2. Restart mysql
systemctl restart mysql

3. Login to the server and create user
mysql -uroot -pinfop

CREATE USER 'root'@'localhost' IDENTIFIED BY 'infop';
CREATE USER 'root'@'%' IDENTIFIED BY 'infop';

GRANT ALL ON *.* TO 'root'@'localhost';
GRANT ALL ON *.* TO 'root'@'%';

FLUSH PRIVILEGES; 
EXIT;