Web Hosting - Managing MySQL Databases

On our Linux platforms, MySQL databases and users for them are created and managed via the Plesk Administrative Control Panel and can be also be administered with the built in PHPMyAdmin module.

Note: If you want to connection externally and/or require a more robust management tool, you can choose from any number of database management applications.

  1. Make the external connection using the same hostname of the website/domain to which the MySQL DB belongs.
  2. Connections to MySQL on port 3306 are restricted to on-campus IP space and WiscVPN connections. 
  3. On the restricted data platforms ports are only open to specific developer static IPs who are contacts for the account.

Apache/Linux (LAMP) Accounts

Follow these instructions to manage databases for your LAMP account:

  1. Log in to the Plesk Control Panel.
  2. Go to the homepage or select the Websites & Domains tab.
  3. Select the Databases icon.
    • Add a MySQL Database: Click the Add New Database button.
    • Manage Database Users: Click the Database icon. Here you can add new users or edit existing users for the corresponding database.
    • Manage Database via phpMyAdmin: Select the database you wish to manage by clicking Select Existing Database (next to the Database icon). You can delete a database or database user by checking the box next to the item you'd like to delete and clicking the Remove icon.

Additional Info

See Web Hosting - Database Policies for more information about additional enterprise level database options and policies.

Contact webhosting@doit.wisc.edu if you have any questions.

Keywordsdatabase, usage, oracle, MySQL, LAMP, MSSQL, account, support, DBA, users,   Doc ID29529
OwnerJake S.GroupDoIT Web Hosting
Created2013-04-17 15:22:06Updated2024-04-02 13:09:28
SitesDoIT Web Hosting
Feedback  1   0