This site requires JavaScript to be enabled
Welcome Guest|
Recent searches
IE BUMPER

Changing Your MySQL Password

Number of views : 8
Article Number : KB0011580
Published on : 2020-06-22
Last modified : 2020-06-22 14:36:23
Knowledge Base : IT Public Self Help

Overview

When you request a new MySQL database, the ITS Database team will create an administrative user and a database user. Each of these users will be assigned an initial password that is shared with you in Stache. It is strongly recommended that you update these passwords to a new value.

You can change your password either through the MySQL command line client or the phpMyAdmin GUI. You can also use some other MySQL client, but you will need to consult its documentation for instructions.

The new MySQL password must meet the following requirements:

  • Must be at least 12 characters long.
  • Must contain at least 1 numeric character.
  • Must contain at least 1 lowercase character.
  • Must contain at least 1 uppercase character.
  • Must contain at least 1 special (non-alphanumeric) character.

 

MySQL Command Line Client (CLI)

One way of updating the password is to use the MySQL command line client. Be sure to change the passwords for both the administrative user and database user using this procedure. Keep the new passwords in a safe place, such as Stache.

Note: Access to the ITS MySQL servers is restricted to the UT Campus network and the UT VPN.

To change your password using the MySQL command line client, do the following:

  1. Connect to your database (you will be prompted for the initial password):
    • If your connection does not require SSL:

      mysql -u <user> -p -h <host> -P <port>
      
    • If your connection does require SSL:

      mysql -u <user> -p -h <host> -P <port> --ssl-ca=<path to cert>
  2. Change the password (make note of the password requirements listed above):
    SET PASSWORD = ‘<plaintext password>’; 
    
  3. Log out and then verify you can log in with the new password (using the instructions in Step 1).

 

phpMyAdmin GUI

Another way of changing the password is to use the ITS phpMyAdmin site. Be sure to change the passwords for both the administrative user and database user using this procedure. Keep the new passwords in a safe place, such as Stache.

Note: Access to the ITS phpMyAdmin site is restricted to the UT Campus network and the UT VPN.

To change your password using phpMyAdmin, do the following:

  1. Go to the ITS phpMyAdmin site.
  2. If prompted with a UTLogin screen, enter your UT EID and password.
  3. On the Welcome to phpMyAdmin screen, enter the initial set of credentials.

  4. Select the database environment and instance (port) that your database is in from the Server Choice drop-down menu.
  5. Click the Go button to log in.
  6. In the General Settings box, click the Change password link.

  7. In the Change Password window, enter the new password and re-type it to verify (make note of the password requirements listed above).

  8. Click the Go button to change the password.
  9. Log out and then verify you can log in to phpMyAdmin using the new password.

 

 

 

Thank You! Your feedback has been submitted.

Feedback