See Database Management Systems.

The MySQL User Manager is useful when adding or managing MySQL users.

In the Open Dental installation folder, double-click MySQLManager.

The MySQL Manager tool can only be used on the server. It is especially useful for offices using Middle Tier.

Connection Settings: Enter the connection settings prior to managing the users.

• Server Name: This shows as localhost since this tool is only usable from the server.
• Port - If different than the default 3306: Typically blank. If using a custom port, enter the number here.
• MySQL User: Typically root. If using a different user, enter the username here.
• MySQL Password: Enter the password as set during the MySQL installations. Leave this blank if no password has been created.

Users: Lists all users associated with MySQL.

• Add: Add a new MySQL User.
• Edit: Click to make changes to the highlighted user. Alternatively, double-click a user to edit.
• Drop: Remove an existing MySQL User. The user currently connected cannot be dropped.

When adding or editing a user, the following window appears:

• MySQL Username: If editing, this is the existing username. If adding, create a new username.
• Password: Enter the password for the selected user, or create a new password. Use this box to create a new password for the selected user if needed.
• Retype Password: Re-enter the password to verify.

Permission Level: Grant the desired level of permissions to the selected user.

• Full: Allows full permissions for the user.
• Low: Only allows user to read data. This user cannot access the Open Dental program, but can run SELECT queries from the command line.