Procedure: MySQL / phpMyAdmin access

Objective

  • To provide instruction on how to access the phpMyAdmin for the CIT MySQL Server and how to add it to your projects.

User

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

Environment

  • 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 please 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

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

 

Print Article