Body
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
- 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: 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