Web Hosting - Managing MySQL Databases

MySQL databases and users are created and can be managed via the Plesk Administrative Control Panel and its 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. 

Windows/IIS Accounts

If you want to add a new database, please email webhosting@doit.wisc.edu telling us what you'd like the database to be named. We enforce unique database names by prefixing your account login ID to your chosen name.

If you want to manage an existing database, follow these instructions:

  1. Log in to the Plesk Control Panel.
  2. From the homepage, go to Applications & ServicesDatabases.
  3. Select the database you wish to manage.
    • Add a New User: Select Add New Database User.
    • Edit an Existing User: Select the name of the user whose information you'd like to edit.
    • Manage Database via phpMyAdmin: Go to ToolsWebadmin. 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.

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 our database options and policies.

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




Keywords:database, usage, oracle, MySQL, LAMP, IIS, account, support   Doc ID:29529
Owner:Jake S.Group:DoIT Web Hosting
Created:2013-04-17 14:22 CSTUpdated:2017-05-01 14:58 CST
Sites:DoIT Web Hosting
Feedback:  1   1