Please follow the below steps to connect MySQL database remotely.
Step 1: Login to the cPanel and click Remote MySQL
Step 2: Enter the IP address (ISP IP from where you are trying to access) and click Add host
Step 3: Try to access the database by using the third-party applications like MySQL Workbench or SQL management Studio for MySQL.
Use the following configuration settings for connecting to your database:
Host name = (use the server IP address)
Database name = (cpanelUsername_databaseName)
Database username = (cpanelUsername_databaseUsername)
Database password = (the password you entered for that database user)
MySQL Connection Port = 3306