Step 1: Open MySQL Workbench client.
Step 2: Click New Connection towards the bottom left of MySQL Workbench.
Step 3: In the “Set up a New Connection Dialogue” box, Type your Database connection credentials. The credentials will be like the following:
+++
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
+++
Step 4: Type your password and click the “Save Password in Vault” check box.
Step 5: Click Ok.
Step 6: Click Ok again to accept the connection settings.
Step 7: Now you will see the databases list in the area on the left.