Connect to MySQL using MySQL Workbench

MySQL Workbench is installed on the computers in the King William labs, and also on the CMS virtual desktop. Please see the instructions below for connecting to your MySQL database in it.

1. Open up MySQL Workbench, then click the plus sign next to ‘MySQL Connections’.

2. Fill in the details (as shown). Replace the username shown with your own username. Click the ‘Test Connection’ button, then click the ‘OK’ button.

3. Double click the connection on the home screen, then enter your password when prompted.

4. You should now be able to query your database.

Comments are closed.