On the RDC at IU, how do I change my MySQL password?

On Indiana University's Research Database Complex (RDC), by default the variable SQL_SAFE_UPDATES is set to 1 to help prevent accidental data loss. To change your MySQL password on the RDC, temporarily set this variable to 0, and then return it to 1 when you're finished:

1. On the RDC, at the command prompt, enter: mysql --defaults-file=~/.my.cnf -u root -p
2. Enter your password when prompted.
   
   
3. At the mysql prompt, enter: SET SQL_SAFE_UPDATES=0;
4. Enter: UPDATE mysql.user SET password = PASSWORD('testpw') where user='root';

   Replace testpw with your new password.

5. Enter: FLUSH PRIVILEGES;

   The message that appears will indicate that there was one warning; this is okay.

6. Enter: SET SQL_SAFE_UPDATES=1;

Comments/Questions/Corrections