Changing a Query Server user's password

Query Server users can only update their own password. To change the password of a user without knowledge of that user's password, login as qsadmin, delete the user and re-create the user.

  1. Start your MySQL client.
  2. Type mysql -h <hostname> -P 15616 -u <username> -p exhr
  3. When prompted for a password type qspass
  4. Type SET PASSWORD = PASSWORD(<newpassword>);, then press Enter.
The user's password has been changed.