Procedure: MySQL / phpMyAdmin access

Objective

  • To provide instruction on accessing the phpMyAdmin for the CIT MySQL Server and adding it to your projects

User

  • Computer and Information Technology (CIT) Faculty, Staff, and Student

Environment

  • 10393: VPN AnyConnect Client
  • (no asset record): CIT MySQL Server
    • http://cit-web.regionals.miamioh.edu/
    • http://cit-web.regionals.miamioh.edu/phpmyadmin/

Procedure

  1. If you are off-campus, connect to the Miami VPN
  2. If you have not already created a CIT Server MySQL Account, follow this link to create an account for the CIT MySQL server
    • Note: Use Your UniqueID when creating an account
    • Note: You will need to make a password that is not MUnet password when you are creating an account
  3. Follow this link to create a Mysql Database
  4. Follow this link to the CIT PHPMyAdmin page
  5. Sign in with the account you created for the CIT MySQL Server
  6. To add the the PHPMyAdmin to your projects, add following code to your project: 
  • Note you need to change the "uniqueid" and "mysqlpassword" to your UniqueID and your password

<?php
$servername = "cit-mysql.regionals.miamioh.edu";
$username = "uniqueid";
$password = "mysqlpassword";
// Connect to MySQL
$conn = new mysqli($servername, $username, $password);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);

}
?>

 

Note

  • Your password for CIT MySQL server is not synchronized with your University UniqueID and MUnet password. If you need to change your password, contact the Regional IT Help Desk