Using MySQL client applications

Last modified: Friday November 24th, 2023

In this article, you will find how to use MySQL client applications to access and manage your MySQL databases.

MySQL client applications

MySQL provides a GUI (graphical user interface) client application that can be used to manage the database. MySQL Workbench is an integrated tooling environment that allows you to manage databases, run queries, and more. It replaces the old MySQL GUI Tools application package, which is no longer actively developed.

MySQL Workbench is free to download and use. There are versions for Microsoft Windows, Mac OS X, Linux, and other operating systems.

Connecting to databases with MySQL Workbench

MySQL Workbench allows you to quickly connect to MySQL databases. In this article we cover two methods:

  • Direct connection: This method establishes a direct connection from your computer to the MySQL server.
    Before you can establish this type of connection, you must allow MySQL remote access to your IP address. See this article for information on how to do this.
  • SSH connection: This method uses SSH to establish a secure connection from your computer to the MySQL server.

1 Method: Direct connection

Please follow these steps to configure a direct connection to MySQL:

  1. Start MySQL Workbench.
  2. Click the + icon next to MySQL Connections from the workspace page, and the Setup New Connection dialog appears.
  3. Type a name for the connection in the Connection Name text box.
  4. Select Standard (TCP/IP) in the Connection Method list box.
  5. In the Hostname text box on the Parameters tab, type example.com, where example.com is your domain name.
  6. Confirm that the Port text box is set to 3306.
  7. Type one of the following usernames in the Username text box:
    • Your Beehosting (cPanel) account username:  With this username, you can access all MySQL databases in your hosting account.
    • A MySQL database username you created in cPanel:  With this username, you can access all MySQL databases for which the specified user has been granted privileges.
  8. Type the name of the MySQL database that you want to access in the Default Schema text box. Also, you can leave this text field empty to select a database later.
  9. Click Test Connection, and type the password for the username you specified in step 7 in the appears Password text box.
    Select the “Save password in keychain” checkbox to have MySQL Workbench remember your password.
  10. Click OK.
    If you get a connection warning about incompatible or non-standard server versions, click Continue Anyway.
  11. If the connection is successful, you will receive a message that the connection to MySQL was successful. If you don’t receive such a message, check the values in steps 4 through 9 and try again.
  12. Click OK. MySQL Workbench saves the new connection on the workspace page.
  13. To open a connection, click it on the workspace page. Now you can run queries, create tables, and more.

2 Method: SSH connection

Please follow these steps to connect securely to your MySQL databases using an SSH tunnel:

  1. Start MySQL Workbench.
  2. Click the + icon next to MySQL Connections from the workspace page, and the Setup New Connection dialog appears.
  3. Type a name for the connection in the Connection Name text box.
  4. Select Standard (TCP/IP) over SSH in the Connection Method list box.
  5. Type example.com:7822 (where example.com is your domain name) in the SSH Hostname text box.
  6. Type your Beehosting (cPanel) account username in the SSH Username text box.
  7. Type localhost in the MySQL Hostname text box.
  8. Confirm that the MySQL Server Port text box is set to 3306.
  9. Type one of the following usernames in the Username text box:
    • Your Beehosting (cPanel) account username:  With this username, you can access all MySQL databases in your hosting account.
    • A MySQL database username you created in cPanel:  With this username, you can access all MySQL databases for which the specified user has been granted privileges.
  10. Click Test Connection, and the Open SSH Tunnel dialog box appears.
  11. Type your Beehosting (cPanel) account password in the Password text box.
    Select the “Save password in keychain” checkbox to have MySQL Workbench remember your password.
  12. Click OK, and the Connect to MySQL Server dialog box appears.
  13. Type the password for the username you specified in step 9 in the Password text box.
    Select the “Save password in keychain” checkbox to have MySQL Workbench remember your password.
  14. Click OK.
  15. If the connection is successful, you will receive a message that the connection to MySQL was successful. If you don’t receive such a message, check the values in steps 4 through 9 and try again.
  16. Click OK on the Setup New Connection dialog box.
  17. Now you can run queries, create tables, and more. For example, on the workspace page, under Open Connection to Start Querying, double-click on the connection name you provided in step 3. MySQL Workbench will connect to your account and display your databases.

 

More Information

To download MySQL Workbench and view the online documentation, please visit http://dev.mysql.com/downloads/tools/workbench.

Was this article helpful?
Views: 301

10 Years Beehosting!
Celebrate with 70% OFF + FREE Site Transfer.

Beehosting.pro website uses cookies

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information that you’ve provided to them or that they’ve collected from your use of their services.

Menu