Connecting to a MySQL cartridge from your local machine using MySQL Workbench
In the Accessing a MySQL database from your local machine recipe, we showed you how to connect to the MySQL database from the mysql
command line from your local machine using port forwarding. In this recipe, you will learn how to connect to the MySQL database from MySQL Workbench. MySQL Workbench is a visual database design tool that integrates SQL development, administration, database design, creation, and maintenance into a single integrated development environment for the MySQL database system.
Getting ready
To complete this recipe, you will need an application with a MySQL cartridge. Please refer to the Adding a MySQL cartridge to your application recipe of this chapter to learn how to install the MySQL cartridge. Also, you will need MySQL Workbench on your local machine. You can download MySQL Workbench from the MySQL official website at http://dev.mysql.com/downloads/tools/workbench/.
How to do it…
Follow these...