Skip to main content

MySQL Database Connection Instructions (Mac)

1. After completing the MySQL Workbench installation, you will launch the application and see the initial launch screen.

 

 mysql_database_mac_1.png
2. You need to add a database connection. If you are adding more than one connection, please follow these steps for each database. Click on the +.

 

mysql_database_mac_3.png

3. You will need to input the following information to connect to your Temple hosted database.

 

* Connection Name: pldcphhsap02.temple.edu
* Hostname:pldcphhsap02.temple.edu
* Port: 3306 
* Username: your AccessNet
mysql_database_mac_4.png

4. Once you enter required information, click on the Test Connection button.

 

 mysql_database_mac_5.png

5. You should be prompted to enter a password. Enter the password provided by your instructor. If you do not see this window then something has been typed incorrectly.

 

 mysql_database_mac_6.png

6. If the connection is successful you will see this Warning window. This is normal due to the version of SQL database we are using and is actually not a problem. Click Continue Anyway.

 

 mysql_database_mac_7.png
7. You should see this window for a successful MySQL connection. Click OK.  mysql_database_mac_8.png

8. The database connection is not yet saved. Click OK again for the connection settings to be saved.

 

 mysql_database_mac_9.png
9. You can now launch the database connection by clicking on the database name.  mysql_database_mac_10.png