On the Research Database Complex at IU, how do I access my MySQL database?

• Connecting to the RDC
• Accessing your MySQL database from the RDC
• Allowing access to your MySQL database from Karst
• Allowing access to your MySQL database from Big Red II
• Using phpMyAdmin to administer your MySQL database
• Getting help

---

Connecting to the RDC

Accessing your MySQL database from the RDC

To access your MySQL database from the RDC:

1. Use an SSH2 client to connect to the RDC front-end server (replace username with your IU Network ID username):

  ssh username@rdc.uits.iu.edu

2. At the RDC command prompt, enter:

  mysql --defaults-file=~/.my.cnf -u root -p

Note:
• As the database administrator (DBA) for your MySQL database, you will initially log into your database as root. By default, your database is set up to allow you to connect as root from rdc.uits.iu.edu and rdcweb.uits.iu.edu. Later, if you prefer to limit root access, you can create additional users.
• For security reasons, do not enter your password on the MySQL command line.
3. When prompted, enter your MySQL database password.
4. When you've logged in successfully, you'll see:

     Welcome to the MySQL monitor.  Commands end with ; or \g.
     Your MySQL connection id is 14
     Server version: 5.5.8-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial)
     
     Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
     
     Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
     
     Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
   
     mysql> 

Allowing access to your MySQL database from Karst

To connect to your MySQL database from Karst, you must first add access to your database's mysql.user table.

To allow access to MySQL from all nodes on Karst:

1. From the RDC, log into your database as root:

     mysql --defaults-file=~/.my.cnf -u root -p

2. At the MySQL prompt, enter:

     grant all on *.* to root@'%.karst.uits.iu.edu' identified by '12tstr45';

   MySQL should respond with:

     Query OK, 0 rows affected (0.03 sec)

3. To reload the grant table, enter:

     flush privileges;

   MySQL should respond with:

     Query OK, 0 rows affected (0.04 sec)

4. To verify the new grant is in the user table, enter:

     select user,host,password from mysql.user where user='root';

   In the resulting table, check for an entry similar to:

     +------+----------------------+-------------------------------------------+
     | user | host                 | password                                  |
     +------+----------------------+-------------------------------------------+
     | root | %.karst.uits.iu.edu  | *74D03D4FC2540A848F27296C062A83FA1ACDC53A |
     +------+----------------------+-------------------------------------------+

5. To exit MySQL, enter:

     quit

   MySQL should respond with:

     Bye

6. To connect to your MySQL database using all the defaults configured on the RDC:
   1. From your account on the RDC, enter:

        cd /N/u/tester/RDC

   2. Copy your MySQL preference file to Karst:

        cp ~/.my.cnf /N/u/tester/Karst/.my.cnf

   3. Verify the copy is complete:

        ls -al /N/u/tester/Karst/.my.cnf

You should now be able to connect to your MySQL database from Karst. If you want to connect from other systems, you'll have to add additional entries for them to the user table.

Allowing access to your MySQL database from Big Red II

To connect to your MySQL database from Big Red II, you must first add access to your database's mysql.user table.

To allow access to MySQL from all nodes on Big Red 2:

1. From the RDC, log into your database as root:

     mysql --defaults-file=~/.my.cnf -u root -p

2. At the MySQL prompt, enter:

     grant all on *.* to root@'rsip.bigred2.uits.iu.edu' identified by '12tstr45';

3. Then, enter:

     grant all on *.* to root@'login%.bigred2.uits.iu.edu' identified by '12tstr45';

   MySQL should respond with:

      Query OK, 0 rows affected (0.03 sec)
    

4. To reload the grant table, enter:

     flush privileges;

   MySQL should respond with:

     Query OK, 0 rows affected (0.04 sec)

5. To verify the new grant is in the user table, enter:

     select user,host,password from mysql.user where user='root';

   In the resulting table, check for two entries similar to:

   +------+----------------------------+-------------------------------------------+
   | user | host                       | password                                  |
   +------+----------------------------+-------------------------------------------+
   | root | rsip.bigred2.uits.iu.edu   | *74D03D4FC2540A848F27296C062A83FA1ACDC53A |
   | root | login%.bigred2.uits.iu.edu | *74D03D4FC2540A848F27296C062A83FA1ACDC53A | 
   +------+----------------------------+-------------------------------------------+

6. To exit MySQL, enter:

     quit

   MySQL should respond with:

     Bye

7. To connect to your MySQL database using all the defaults configured on the RDC:
   1. From your account on the RDC, enter:

        cd /N/u/tester/RDC

   2. Copy your MySQL preference file to Big Red II:

        cp ~/.my.cnf /N/u/tester/BigRed2/.my.cnf

   3. Verify the copy is complete:

        ls -al /N/u/tester/BigRed2/.my.cnf

You should now be able to connect to your MySQL database from Big Red II. If you want to connect from other systems, you'll have to add additional entries for them to the user table.

Using phpMyAdmin to administer your MySQL database

The phpMyAdmin application lets you administer your MySQL database from a web interface. For IU-specific instructions, see At IU, how do I use the phpMyAdmin web interface to administer my MySQL database on the Research Database Complex?

Back to top

Getting help

For help connecting to your MySQL database at IU, email the High Performance Systems group.