BIT MySQL Connection

Connecting to MySQL Server

Download and install the MySQL Workbench

Add the BIT MySQL Servce in MySQL Connections

Using the following connection information

Connection Name: BIT MySQL
Connection Method: Standard (TCP/IP)
Parameters
Hostname: pamplin-bit2020.mysql.database.azure.com
Port: 3306
Username: {your pid}

Hit "Test Connection" and it will prompt for your provided complex password. You can Store in the Vault. If sucessful, it will give you a success message.

Schema Restrictions

Since this is a SHARED resource, database schema restrictions are in place. Your account grants access to a personal database with the name {pid} and access to any additional databases prefixed with {pid}_XXXXXXXXX. You will not be able to create tables outside that naming convention.

The following SQL statements will fail due to the schema restriction

DROP DATABASE IF EXISTS `northwind`;
CREATE DATABASE IF NOT EXISTS `northwind`;
USE `northwind`;

The following SQL statement will successful make a database for user HOKIE

DROP DATABASE IF EXISTS `hokie_northwind`;
CREATE DATABASE IF NOT EXISTS `hokie_northwind`;
USE `hokie_northwind`;

The following SQL statements will fail due to the schema restriction

USE `sakila`;

SELECT * FROM customers;

The following SQL statement select all the records from the customers's table in the hokie_sakila database

USE `hokie_sakila`;

SELECT * FROM customers;

Forgot your MySQL Password

Submit a Ticket

MySQL Server Information

MySQL Version: 5.7
Requires SSL: Yes

Default Database Access

{pid}
{pid}_class [For BIT 3524]
{pid}_sakila [For BIT 3524]