Web Hosting - Managing MySQL Databases
On Linux based web hosting platforms, you can create and manage MySQL databases and users via the Plesk Administrative Control Panel.
Databases can also be managed through Plesk's built‑in phpMyAdmin module and connected to externally with various database management applications.
Security and Connection Requirements
Firewall
-
Standard Accounts: External connections are restricted to UW-Madison IP ranges and WiscVPN connections
-
Restricted Data Accounts: Connections are restricted to individual developers assigned static WiscVPN IP and authorized for the account.
Connection Settings
- Hostname: Use the same hostname as your website (e.g., yourdomain.wisc.edu)
- Port: 3306
- Users: Managed in Plesk (see below)
How to Create and Manage MySQL Databases
-
Log in to the
Plesk Control Panel -
From the Dashboard tab, select the Databases icon.
-
-
Create a New Database: Click the Add Database button and follow the prompts.
-
Manage Users: Click the Database Users tab and from here, you can add new users, update passwords, or change user permissions for a specific database.
-
Access phpMyAdmin: Next to the database name, click the phpMyAdmin icon . This will open the management interface in a new window.
-
Delete a Database or User: Select the Trash icon in the upper right and follow the prompts.
-
Additional Information
DoIT also offers Oracle and Microsoft SQL Server (MSSQL) database hosting services:
- Oracle: https://it.wisc.edu/services/oracle-database-hosting/
- MSSQL: https://it.wisc.edu/services/mssql-database-hosting/
Web Hosting Oracle Connectivity:
- Linux: Web Hosting - Linux Oracle Connectivity - tnsnames.ora
- Windows: Oracle is not installed on our Windows platforms, and developers utilize Oracle’s Data Provider for .NET and specify connections within their applications.
See Web Hosting - Database Policies for more information
Contact webhosting@doit.wisc.edu if you have any questions.