Table of Contents

Overview of the Service
  • Intended for use as an "add-on" service for Webserve accounts
  • Connections to/from the MySQL service are restricted to Webserve and direct logins to the MySQL servers. As such, you are unable to use desktop MySQL clients to manage your databases or connect to your databases from servers other than Webserve.
  • All MySQL accounts come with a test account to provide you with a completely separate environment in which to test your applications before moving into production or to test the impact of MySQL version upgrades prior to the roll out.
  • This service is intended for those with modest disk usage requirements, as such there is no charge for the first 1GB of use. For additional billing information, please see Web Account Service Charges.
  • For additional technical details regarding MySQL accounts see:
    MySQL Account Details

Guidelines & Responsibilities
  • Appropriate Use
  • You will have complete control and the associated responsibility for your own MySQL database server running as your account name on the port number that is assigned to you with your account. The appropriate use of the account and its associated MySQL server is to provide a database service only for use by web applications in your Webserve account.

    Test databases must be located on the test server ( and not on the production server ( Likewise, production databases must not be placed on the test server but need to be located on If you need help or have questions about moving test MySQL databases into production, contact IU Webmaster for assistance.

  • Backups and File Restores
  • You are responsible for performing and maintaining your own backups on and

    All accounts are pre-enabled for cron to permit you to run automated database checkpoint and backups. We strongly recommend doing a DB-level checkpoint mysqldump to ensure your data is backed up sufficiently should you need to restore data. While UITS performs standard system backups, because of the relationship between data elements within the data files needing to be in complete synchronization, a file restore done by UITS may not be sufficient to restore your database.

    For additional information see Backup and Recovery in the MySQL Reference Manual and the IU Webmaster document on MySQL backups.

  • Data Collection

    Please note that you cannot use this service for storing of critical data.

    • If you plan on collecting and storing personal information, you should contact the data manager for guidance and regulations that govern the use of that data. The list of data managers can be found at
    • Use of the MySQL Service requires adherence to policies outlined by both the University Information Policy Office and the IU Webmaster. Please see Important Security Information for MySQL Accounts for policies and guidelines.
    • Entry of personal data on a web site should be done within the wwws directory.
    • Critical data may not be stored using this MySQL service. Please see Classifications of Institutional Data for a list of examples.
    • You are encouraged to avoid collecting unnecessary data and to make use of existing official data sources, such as HRMS or SIS, when possible. Please see What is the HRMS/SIS project?
    • Passwords that are used as part of a web application that are stored in a MySQL database must be
      (i) transmitted in a secure manner, meaning that the communications between the www browser and the server (Webserve) should encrypted by putting the web application in the secure WWW server
      (ii) stored in a MySQL table encrypted using MySQL data types/functions which encrypt and decrypt the value of the variable as it is read and written to the table.
    • You may not run more than one MySQL database server process (mysqld) within a single account using the same or additional port numbers. If you need additional database server processes for a special set of circumstances, you should apply for another MySQL database service account.

Applying for a MySQL Account

You must already have a Webserve account in order to add a MySQL database to your account. Your MySQL account will share the name as your Webserve account.

  • Before applying, please read over the guidelines noted above, including the need to perform your own database backups.

To apply for an account, please visit the WebTech Services Management. You will need to login using your personal Network ID to access this form.

Setting up your account for first time use

If your MySQL account was created prior to March 10th, 2015, follow the instructions here for first-time setup of your MySQL account.

If your MySQL account was create on or after March 10th, 2015, follow these instructions instead.

Starting/Stopping the MySQL server for your account

You may stop or start the MySQL server for your account by logging into your account on the MySQL server via an SSH client and typing the following:

cmd_mysql stop

-- and --

cmd_mysql start

During both the 'stop' and 'start' operations, the system locates the .my.cnf file in your account and reads it for any necessary directives.

Server restarts and maintenance window

As with any server, there are weekly server restarts and a reserved maintenance window. For and those times are as follows:

Weekly Restart: Every Sunday, 6:00am - 7:00am
Reserved Maintenance Window: Every Sunday, 12:00am - 9:00am

During these time periods, the MySQL service may be unavailable. It is important that your web-based applications be able to gracefully handle an inability to connect to the MySQL server or some interruption in data transfer to and/or from the server during both scheduled and unscheduled maintenance.

The maintenance window for this and other UITS services can be found at

Troubleshooting MySQL issues

We have created a document that lists the most commonly reported error messages and how to correct the problem. See: MySQL Frequently Asked Questions.