CPanel Database

Host: localhost

Username: dcgmizx_bigdaddy

Failed

VPS Database

Host: 103.124.172.125

Username: tajeem_bdg

Timeout
VPS Connection Timeout - Troubleshooting Steps
  1. Check if VPS is reachable: ping 103.124.172.125
  2. Check if MySQL port is open: telnet 103.124.172.125 3306
  3. On VPS, run these commands:
    # 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
                        
  4. From CPanel, test connection: mysql -h 103.124.172.125 -u tajeem_bdg -p