MySQL configuration

Configuration of the database

Start your preferred browser and enter “localhost/phpmyadmin” in the address bar

If the system is promping you already now for a username and password just enter “root” as user and leave the password field empty.

1. Set up user “root”

This user is the administrator of the database and has nothing to do with the actual user for the tool

  • On the start page, click on “User accounts” in the upper tabs row
  • At the first user “root” click on “Edit privileges”
  • Click on the “Change Password” button
  • Enter a password twice and click on “OK”

  These steps are required for all root users and you must always select the same password

If you change the password for the user root on localhost, the system will show a login pop-up. Type in the username (root) and password you just entered before.

2. Add another user

Now the actual user is set up for the QMMS tool

Click on “User accounts” again

  • Click on “Add user account”
  • Select the user name “qbuser”
  • From the host drop-down menu select the host “local”
  • Enter as password “rPCQUw9HYKGb2ebT” (default password of the tool)
  • Go to “global privileges” and check the following checkboxes:   * in section Data: SELECT, INSERT, UPDATE, DELETE, FILE   * in section Structure: CREATE TEMPORARY TABLES
  • Add the user by clicking “Go”

  Create a second user with the same name, permissions, and password for the “every host” (%) host