Enable MYSQL Remote Connection

Step Step Enable

MYSQL ENABLE REMOTE CONNECTION

SELECT user, host, plugin from mysql.user;

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
bind-address            = 0.0.0.0 (ubah dari 127.0.0.0 ke 0.0.0.0)

CREATE USER 'zeffry'@'%' IDENTIFIED WITH mysql_native_password BY 'YOUR-STRONG-PASSWORD';
GRANT ALL PRIVILEGES ON *.* TO 'zeffry'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit;

sudo ufw allow from 103.191.92.211 to any port 3306