MySQL Enterprise Monitor is available as part of the MysQL Enterprise
subscription, learn more at
The Manage Users panel lets you create, delete and manage individual users that have access to MySQL Enterprise Service Manager.
A user account is required to log into the MySQL Enterprise Monitor User Interface. There are four types of users with varying privileges:
A user with the role of
manager can perform
all operations within MySQL Enterprise Service Manager, including changing the
server configuration, adding and removing users, and viewing
query analyzer and other data.
Users with the
dba role should be database
administrators who are using MySQL Enterprise Monitor to monitor servers and
queries. They have a similar set of privileges to those with the
manager, except that they cannot do the
Cannot add/remove or change users.
Cannot change the My Oracle Support credentials used to communicate with the My Oracle Support website.
Cannot change the HTTP proxy settings.
Cannot change the Query Analyzer settings.
Cannot change the LDAP authentication preferences.
In addition to these limitations, you can control for each user with the dba role whether:
View Query Analyzer tab: Limits whether the user can see the Query Analyzer tab and its contents.
View action (example) queries: Limits whether the user can see the values within queries shown within the query analyzer.
The setting for these abilities is provided when you select the
dba role for a user.
read-only role is identical to the
dba role, but is unable to make any changes
to the configuration of MySQL Enterprise Monitor, although they can view the
agent role is reserved for all users that
you want to have access and ability to send agent information.
You can use this if you want to provide individual logins for
The Administrator defined during installation as having the root role is unique; this user cannot be deleted.
If you are logged in as an
Administrator, you can
add a new user by choosing the
Manage Users link
from the Settings tab. To create a user click
the create user button, select a role for the
user, and enter a user name and password.
When a new user first logs in, a dialog box opens requesting time zone and locale information. To change this information later, use the User Preferences tab. For more information, see Section 4.11.4, “User Preferences”.
If you installed the Advisors through the MySQL Enterprise Monitor User Interface, you have probably configured the settings for the root role user already. (See Section 4.11.1, “Global Settings” and following for more information about this topic.)
To receive support-related updates, configure the My Oracle Support (MOS) credentials for at least one user. These settings were set up on the first login to the Monitor UI. For information on changing these settings, see Section 4.11.1, “Global Settings”.
To edit an existing user's information, select the
Users link, then select the user to edit. Make your
desired changes in the fields provided, then save the changes.
Users can be authenticated either using an internal authentication system, which stores the user, password and role information within MySQL Enterprise Monitor, or you can opt to use an external LDAP service. To use the LDAP service, you still create each user, and then select the Authenticate this user using LDAP checkbox within the Edit User window. The username entered is authenticated against the configured LDAP server. For more information on configuring the LDAP server to be used, see LDAP Authentication.
To delete an existing user, click the
next to the user to delete.