Slide 1.10: MySQL, SQL, and MySQL Workbench

Languages and Software to Be Used (Cont.)

MySQL Database Management System (DBMS)
MySQL is a relational DBMS that runs as a server providing multi-user access to a number of databases.

<html>
 <body>
  <?php
   $userid   = "wenchen";
   $database = "wenchen";
   $password = "";
   $host     = "undcemmysql.mysql.database.azure.com";

   // Initializing MySQLi
   $conn     = mysqli_init( );

   // Creating an SSL connection
   mysqli_ssl_set( $conn, NULL, NULL, "DigiCertGlobalRootCA.crt.pem", NULL, NULL );

   // Opening a new connection to the MySQL server
   mysqli_real_connect( $conn, $host, $username, $password, $database, 3306 );

   // Connect to the database.
   if ( mysqli_connect_errno( ) )
     die( 'Failed to connect to MySQL: ' . mysqli_connect_error( ) );
   else {
     echo "Successfully connect to MySQL!";
     // Close the database connection.
     $conn->close( );
   }
   ?>
 </body>
</html>

SQL (Structured Query Language)
A standard language for creating, updating, and querying databases


SELECT name, c.title FROM course c, enrollment e WHERE ( e.name = 'Goku' ) AND ( c.number = e.number );

MySQL Workbench
MySQL Workbench is an IDE (integrated development environment) for MySQL database management including design, modeling, development, administration, and maintenance.