====== MySQL Database Connection Instructions (Mac) ====== ^ ^ ^ | 1 | After completing the MySQL Workbench installation, you will launch the application and see the initial launch screen. | {{:it:student:mysql_instructions:step1_initial_launch.png?direct|}} | | 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**. | {{:it:student:mysql_instructions:screen_shot_2020-01-08_at_4.59.12_pm.png?direct|}} {{:it:student:mysql_instructions:screen_shot_2020-01-08_at_4.59.26_pm.png?direct|}}| | 3 | You will need to input the following information to connect to your Temple hosted database. * Connection Name: cph-hsap.tu.temple.edu * Hostname:cph-hsap.tu.temple.edu * Port: 3306 * Username: your AccessNet | {{:it:student:mysql_instructions:screen_shot_2020-01-08_at_4.40.52_pm.png?direct|}}| | 4 | Once you enter required information, click on the **Test Connection** button. | {{:it:student:mysql_instructions:screen_shot_2020-01-08_at_4.26.40_pm.png?direct|}} | | 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. | {{:it:student:mysql_instructions:screen_shot_2020-01-08_at_4.28.15_pm.png?direct|}}| | 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**. | {{:it:student:mysql_instructions:screen_shot_2020-01-08_at_4.28.58_pm.png?direct|}}| | 7 | You should see this window for a successful MySQL connection. Click **OK**. | {{:it:student:mysql_instructions:screen_shot_2020-01-08_at_4.29.13_pm.png?direct|}}| | 8 | The database connection is not yet saved. Click **OK** again for the connection settings to be saved. | {{:it:student:mysql_instructions:step8_connect_to_database.png?direct|}} | | 9 | You can now launch the database connection by clicking on the database name. | {{:it:student:mysql_instructions:step9_connect_to_database.png?direct|}} |