Body
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
- If you are off-campus, connect to the Miami VPN
- 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.
- Follow this link to create a Mysql Database
- Follow this link to the CIT PHPMyAdmin page
- 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