0/ Setup remote connection On database server sudo ufw allow from to any port 3306 sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
Change bind-address = mysqlx-bind-address =
1/ Add new user and grant for new DB CREATE DATABSE zein_mochida; CREATE USER 'zein'@'' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON zein_mochida.* TO zein@''; FLUSH PRIVILEGES;