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.
- To set up a new user, click on the icon which has two people on it.
- Once complete, you will receive a message saying so.
- Linux users, please restart tomcat.