Access your MySQL database on the IU Research Database Complex

Note:

The Indiana University Research Database Complex supports research-related databases and data-intensive applications that require databases. The RDC provides an environment for database-driven web applications focusing on research, and offers the following database accounts:

  • MySQL: The RDC supports MySQL Enterprise Server.
  • Oracle: MySQL can meet most database needs. However, if your research has an immediate requirement for specific functionality in Oracle, you may request to be considered for an Oracle database account. To do so, follow the instructions in the RDC Database and Web Services Account Application.

On this page:


Connect to the RDC

To connect to your account on the Research Database Complex (RDC) front-end server:

  1. In your SSH client, enter the following (replace username with your IU username):
      ssh username@rdc.uits.iu.edu
  2. Read the message of the day (MOTD). It contains news and information about the status of the RDC.
Note:
Your login shell is automatically set to bash.

Connect your MySQL database

Note:
Your RDC MySQL Database welcome letter contains information you need to connect to your database:
  • Your MySQL database login (username)
  • Information about your initial database password
  • Your database port number

If you don't have your welcome letter, email the High Performance Systems group for help.

To access your MySQL database from the RDC:

  1. At the RDC command prompt, enter:
      mysql --host=<host> --port=<port> -u <root_username> -p
    
    Note:
    For security reasons, do not enter your password on the MySQL command line.
  2. When prompted, enter your MySQL database password.
  3. 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 High Performance Systems group.

This is document awqb in the Knowledge Base.
Last modified on 2018-02-13 15:31:53.

  • Fill out this form to submit your issue to the UITS Support Center.
  • Please note that you must be affiliated with Indiana University to receive support.
  • All fields are required.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.

  • Fill out this form to submit your comment to the IU Knowledge Base.
  • If you are affiliated with Indiana University and need help with a computing problem, please use the I need help with a computing problem section above, or contact your campus Support Center.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.