Using MySQL Workbench

  1. Check the MySQL Workbench Help Pages.

  2. Download and install the MySQL Workbench.
    3.  Use the following connection parameters:

    • Connection Method: Standard (TCP/IP),
    • Hostname: undcsmysql.mysql.database.azure.com (for faculty: undmysqlappdb.und.edu),
    • Port: 3306, and
    • Username: your MySQL account ID.
  1. Activate the MySQL Workbench such as 
       Windows Start button ⇒ All Programs ⇒ MySQL ⇒ MySQL Workbench
    2.


  2. For the first-time use, create a new connection such as “457” by clicking the “New Connection” in the left pane.
    3.




  3. Click a DB connection to open the SQL Editor.
    4.


    The following image shows some Workbench sections.


  4. For the first-time use, change the password by using the following command:
    5.  
       mysql> set password = old_password("pwpwpwpw");
    where pwpwpwpw is whatever new password you want.


  5. Select your database (schema), and then start entering SQL commands and execute them.
    6.


  6. Commit the database if it is updated.
    7.






      I don’t want to brag, I finished the puzzle in under a week    
      and it said 2-4 years on the box.