Access your MySQL database on the RDC at IU

On this page:

MySQL clients
Connect to your MySQL database
Get help

MySQL clients

Note:

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.

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 IU's research supercomputers.
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 your MySQL database

Note:

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 for help.

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

To access your MySQL database from a command-line client:

At the command prompt, enter the following (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>).

Get help

For help connecting to your MySQL database at IU, email the RDC Administration group.