Setup for PHP and MySQL Training

• Operating system:
  • Windows 10 or later
  • Mac: OS X Mountain Lion (version 10.8) or later.
• Google Chrome

Warning: this is going to take some time.

There are a few steps:

1. Follow the setup instructions for PHP here, which explain how to install the software used in the PHP portion of the course and where to download and unzip the class files.
2. Make sure that MySQL Server is running in MAMP:
   
3. Install MySQL Workbench. To do so, follow the instructions at https://dev.mysql.com/downloads/workbench/.
4. After installing MySQL Workbench, download the SQL class files from the bottom of this page. Then unzip them into the Webucator folder and rename the folder SQL.
5. Setup MySQL Workbench:
   1. Open MySQL Workbench and click on the plus symbol to the right of the "MySQL Connections" text:
      
   2. In the Setup New Connection dialog that shows up:
      
   3. Enter "local" as the Connection Name. Leave everything else unchanged.
   4. Click the Test Connection button.
   5. Enter "pwdpwd" as the Password.
   6. Check Save password in vault.
   7. Click OK.
   8. You should get a confirmation dialog box, like this:
      
   9. Click OK and OK again to close the dialog boxes.
   10. You should now see a local connection on the MySQL Workbench home screen:
       
   11. Click the local connection to open it.
   12. If you correctly completed the setup for the PHP course, you should see a poetree schema (also called a database) in the Navigator panel on the left:
       
6. We will now install northwind, the schema we will use in the SQL class.
   1. From the File menu, select Run SQL Script...
      
   2. Navigate to the setup folder and select the Northwind-MySQL.sql file and click the Open button:
   3. In the Run SQL Script dialog, click the Run button:
      
   4. You should now see the northwind database under the SCHEMAS heading in the Navigator panel on the left. If you don't, try pressing the refresh icon (circled in orange below):
      

Congratulations, you are now set up for your class.