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 enables you to quickly connect to your MySQL databases. To do this, follow these steps:
- Start MySQL Workbench.
- From the workspace page, click the + icon next to MySQL Connections. The Setup New Connection dialog appears.
- In the Connection Name text box, type a name for the connection.
- In the Connection Method list box, select Standard (TCP/IP).
- On the Parameters tab, in the Hostname text box, type example.com, where example.com represents your domain name.
- Confirm that the Port text box is set to 3306.
- 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.
- 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.
Click Password text box, type the password for the username you specified in step 7., and then in the
To have MySQL Workbench remember your password, select the Save password in keychain check box.
If you receive a connection warning about incompatible or nonstandard server versions, click .
- 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.
- Click . MySQL Workbench saves the new connection on the workspace page.
- To open the connection, click it on the workspace page. You can now run queries, create tables, and more.
To download MySQL Workbench and view the online documentation, please visit http://dev.mysql.com/downloads/tools/workbench.
- Remote MySQL connections
There are two options for connecting to MySQL databases remotely. Learn about them and how to set them up here.
- Remote MySQL access
You can use cPanel to configure remote access to your MySQL databases. With remote access enabled, external hosts can access your MySQL databases.
- Connecting to MySQL from the command line
You use the mysql program to connect directly to MySQL from the command line. Learn how here.