Host: localhost
Username: dcgmizx_bigdaddy
Host: 103.124.172.125
Username: tajeem_bdg
ping 103.124.172.125
telnet 103.124.172.125 3306
# Check if MySQL is running
sudo systemctl status mysql
# Allow remote connections
sudo sed -i 's/bind-address.*/bind-address = 0.0.0.0/' /etc/mysql/mysql.conf.d/mysqld.cnf
sudo systemctl restart mysql
# Grant remote access to user
mysql -u root -p
GRANT ALL PRIVILEGES ON tajeem_bdg.* TO 'tajeem_bdg'@'%' IDENTIFIED BY 'tajeem_bdg';
FLUSH PRIVILEGES;
# Open firewall port
sudo ufw allow 3306/tcp
sudo ufw reload
mysql -h 103.124.172.125 -u tajeem_bdg -p