Access your MySQL database at IU RDC

On this page:

Overview
MySQL clients
Connect to MySQL using the command-line client
Connect to MySQL using MySQL Workbench
Get help

Overview

The Indiana University Research Database Complex (RDC) supports research-related MySQL and PostgreSQL databases and data-intensive applications that require databases. The RDC is strictly devoted to supporting research, and is not an instructional, classroom environment.

When you requested the creation of your RDC MySQL database, you received information that you need to connect to your database:

Your MySQL database login ("_root" username)
Information about your initial database password
Your database host and port number

If you no longer have this information, email the RDC Administration group (rdcadmin@iu.edu) for help.

If you are off campus, make sure you're using IU VPN.

To request an account on an Indiana University research system, see Get additional IU computing accounts. Account availability depends on your eligibility.

MySQL clients

To connect to your account on the RDC, use one of the following:

MySQL command-line client: The MySQL command-line client is available on Quartz.
MySQL Workbench: The MySQL Workbench graphical client is available at IU via Research Desktop (RED) and IUanyWare. Also, a community edition is available for free download from MySQL; see Download MySQL Workbench.

Connect to MySQL using the command-line client

If you have an account on Quartz, you can use the command-line MySQL client to access your MySQL database:

Load the mysql module; on the command line, enter:
```
module load mysql
```
On the command line, enter (replace username_root with your MySQL database login):
```
mysql --host=sasrdsmp01.uits.iu.edu --port=3306 -u username_root -p
```
Note:

For security reasons, do not enter your password on the MySQL command line.
When prompted, enter your MySQL database password.
When you log in successfully, you will be placed at the MySQL prompt (mysql>).

Connect to MySQL using MySQL Workbench

Open MySQL Workbench. On the home screen, select the + (plus sign) next to the MySQL connections.
In the "Setup New Connection" window:
1. Enter your database credentials.
2. For "Connection Name", enter a descriptive name, such as the account name used for the database account.
3. For "Connection Method", leave the default Standard (TCP/IP) unless you need another one.
4. For "MySQL Hostname", enter the RDC MySQL hostname sasrdsmp01.uits.iu.edu; for the port, enter 3306.
5. In the "Username" field, enter the account name sent to you (a "_root" username).
6. For "Password", UITS does not recommend storing the password in the vault.
To test your credentials, select Test Connection. If you didn't save the password in the vault, you will be prompted for it. Use the password sent with your account name. If the connection is successful, select OK.

Get help

For help connecting to your RDC MySQL database, email the RDC Administration team (rdcadmin@iu.edu).