Creating a new user with Query Server access

This task can only be performed when logged in as qsadmin.

  1. Start your MySQL client.
  2. Type mysql -h <hostname> -P 15616 -u qsadmin -p exhr
  3. When prompted for a password type qspass
  4. Type CREATE USER <user> IDENTIFIED BY <password>;, then press Enter.
  5. When a new prompt appears type GRANT SELECT ON exhr.Dn TO <user>;, then press Enter.
  6. When a new prompt appears type GRANT SELECT ON exhr.Imsi TO <user>;, then press Enter.
  7. When a new prompt appears type GRANT SELECT ON exhr.Dn2Imsi TO <user>;, then press Enter.
  8. When a new prompt appears type GRANT SELECT ON exhr.Imsi2Dn TO <user>;, then press Enter.
  9. When a new prompt appears type GRANT SELECT ON exhr.Service TO <user>;, then press Enter.
A new MySQL user with Query Server access has been created.
Parent topic: Query Server