Connect via MySQL Workbench

If you are more comfortable with command-line edits, use the instructions below.  Some people prefer to use a GUI interface, such as MySQL Workbench.

1. Connect to the VPN Client, whether you are on campus, off campus, wired connection, or wireless connection.
2. Install and Open MySQL Workbench 
3. In the top menu, select Database > Manage Connections...
   
   
   
   
4. Press the New button.
5. You may name your connection whatever you wish, but then use the following settings:
   
   1. Connection Method: Standard (TCP/IP)
   2. Hostname: mysqllab.auburn.edu
   3. Port: 3306
   4. Username: the username associated with the database (usually is your Auburn username)
   5. Password: enter the password associated with the database in the Vault
      
      
      
      
6. Press the Test Connection button
7. In the top menu, select Database > Connect to Database
8. Choose the connection you just created

Connect via SSH or SecureCRT

1. Connect to the VPN Client, whether you are on campus, off campus, wired connection, or wireless connection.
2. Open an SSH session or application (SecureCRT is recommended; installation link found here)
3. Connect to Mallard with the following settings:
   
   1. Connection type: SSH2
   2. Hostname: mallard.auburn.edu
   3. Port: 22
   4. Username: your Auburn Univ. username
   5. Authentication: Password
   6. Key exchange: diffie-hellman, diffie-hellman-group
   7. When you attempt to connect, you will be prompted to enter your Auburn Univ. password
4. Once connected, at the prompt, enter:
   
   mysql -h mysqllab.auburn.edu -u username -p
   
   Note: replace "username" with the username associated with the database (usually is your Auburn username)
   
   
5. Press Enter
6. When prompted, enter the password associated with the database (This is the password that you chose when you requested your database and is not the same as the password you use for most other Auburn resources.)
   
   Note: as you type the password, you will not see anything happen on-screen -- this is normal
   
   
7. Press Enter
8. When you get a mysql> prompt, type in the following:
   
   use name;
   
   Replace "name" with the database name in your confirmation email. (This is usually in the format usernamedb where "username" is your Auburn username.)
   
   You're now connected to your MySQL database via telnet.

Connect via a PHP Script

1. Connect to your MySQL database using a MySQLi extension or PHP Data Objects (PDO) connection.
   
   W3Schools Tutorial
   
   Example (mysqli):
   
   
   <?php
   
   
   $servername = "mysqllab.auburn.edu";
   $username = "whatever the db username is (typically your username)";
   $password = "whatever the db password is";
   $db = "databasename";
    
   // Create connection
   $conn = new mysqli($servername, $username, $password, $db);
   
   
   // Check connection
   if ($conn->connect_error) {
       die("Connection failed: " . $conn->connect_error);
   } 
    
   ?>
2. You can now start issuing queries from the PHP script.
   
   Example (mysqli):
   
   <?php
   
   

     $sql = "SELECT * FROM tablename";

     $result = $conn->query( $sql );

    

     $newArray = array();
   
   

     if ( $result->num_rows > 0 ) {

       while ( $row = $result->fetch_assoc() ) {

         $newArray[] = $row;

       }

     }
   
   

     $arrayCount = count( $newArray );
   
   ?>