Page Comparison

This option is used to add new MySQL users and assign which schemas each user can access.

• Select the "Change MySQL Authentication" button in the installer.
• Click on the Browse button and select the path of the Tomcat application and click next.
• Using the "Select Project" drop down menu, choose the server you wish to configure users for, and click next.
• Enter your MySQL root username and password details and click on the "Test Connection" button.
  • Alternatively, another MySQL user which has read and write access to the schema you'd like to change as well as GRANT privileges may be used.
• You should get a Success message if your details have been entered correctly, then click Next.
• You can now select or create a new SQL user and test the connection to the MySQL database.
  • To set up a new user, click on the icon which has two people on it.
    • You will be presented with a menu where you can add a new user and a password for that user. Click Create to create that user.
    • You can now enter that new username and password and click the refresh icon (circular arrows) on the installer to see which schema that user has access to.
    • To configure access to a new or additional schema other than what is on the list, click on the Set Privilege icon (has a key on it).
    • Choose which schemas you want this MySQL user to have access to and then click on the Set Privilege button to save your changes.
  • Click on the Test connection button. You should get a success message.
  • Click on the Update Password button. This will cause the new user, password and schema privileges to be created.
• Once complete, you will receive a message saying so.
• Linux users, please restart tomcat.