Steps to connect to your database remotely via MySQL Workbench Print

  • 0

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.


Was this answer helpful?

« Back