Skip to main content

MySQL Database Connection

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

 

 MySQL_Database_step1_initial_launch.png

2. You need to add a database connection. If you are adding more than one connection, please these steps for each database. You can either click on the + or click on the Database dropdown menu and select Connect to Database.

 

 MySQL_Database_step2_connect_to_database.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

Note: If you have not had an account created for you, you will not be able to connect to the database.

 

 MySQL_Database_step3_connect_to_database.png

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

 

 MySQL_Database_step4_connect_to_database.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_step5_connect_to_database.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_step6_connect_to_database.png

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

 

 MySQL_Database_step7_connect_to_database.png

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

 

 MySQL_Database_step8_connect_to_database.png

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

 

 MySQL_Database_step9_connect_to_database.png
Back to top