====== MySQL Database Connection Instructions ====== ^ ^ ^ | 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:step2_connect_to_database.png?direct|}}| | 3 | You will need to input the following information to connect to your Temple hosted database. * Connection Name: cph-hsap.temple.edu * Hostname:cph-hsap.temple.edu * Port: 3306 * Username: your AccessNet | {{:it:student:mysql_instructions:step3_connect_to_database.png?direct|}}| | 4 | Once you enter required information, click on the **Test Connection** button. | {{:it:student:mysql_instructions:step4_connect_to_database.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:step5_connect_to_database.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:step6_connect_to_database.png?direct|}} | | 7 | You should see this window for a successful MySQL connection. Click **OK**. | {{:it:student:mysql_instructions:step7_connect_to_database.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|}} |