Knowledge Base

How to use MySQL client applications

This article describes how to use MySQL client applications to access and manage your MySQL databases.

MySQL client applications

MySQL provides GUI (graphical user interface) client applications that you can use for database management:

  • MySQL Workbench: This integrated tools environment enables you to manage databases, run queries, and much more. It replaces the older MySQL GUI Tools application bundle, 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.

MySQL Workbench

MySQL Workbench enables you to quickly connect to your MySQL databases. To do this, follow these steps:

  1. Start MySQL Workbench.
  2. From the workspace page, click the + icon next to MySQL Connections. The Setup New Connection dialog appears.
  3. In the Connection Name text box, type a name for the connection.
  4. In the Connection Method list box, select Standard (TCP/IP).
  5. On the Parameters tab, in the Hostname text box, type example.com, where example.com represents your domain name.
  6. Confirm that the Port text box is set to 3306.
  7. In the Username text box, type one of the following usernames:
    • Your A2 Hosting (cPanel) account username: With this username, you can access all of the MySQL databases on your hosting account.
    • A MySQL database username you created in cPanel: With this username, you can access all of the MySQL databases for which the specified user has been granted privileges.
  8. In the Default Schema text box, type the name of the MySQL database that you want to access. Alternatively, you can leave this text box blank to select the database later.
  9. Click Test Connection, and then in the Password text box, type the password for the username you specified in step 7.

    To have MySQL Workbench remember your password, select the Save password in keychain check box.
  10. Click OK.

    If you receive a connection warning about incompatible or nonstandard server versions, click Continue Anyway.
  11. If the connection is successful, you receive a Successfully made the MySQL connection message. If you do not receive this message, check the values you specified in steps 4 to 9, and then try again.
  12. Click OK. MySQL Workbench saves the new connection on the workspace page.
  13. To open the connection, click it on the workspace page. You can now run queries, create tables, and more.

 

 

More Information

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