![]() ![]() When you create a new user, you might only allow a small number of options for that user. In the above screenshot, the user has full access to all options. You can also set the Global Privileges in this screen. Other roles are more specific to a particular task (or set of tasks) that a user might be allowed to perform. DBA is the highest role - a DBA can perform all tasks. The Administrative Roles tab allows you to apply a role (or roles) for each user. Only statements that modify databases or tables count against the update limit. The number of simultaneous connections to the server by an accountĪccording to the MySQL documentation: Any statement that a client can issue counts against the query limit, unless its results are served from the query cache.The number of times an account can connect to the server per hour.The number of updates that an account can issue per hour.The number of queries that an account can issue per hour.Here, an administrator can create new user accounts, set their password, authentication type, their administrative roles, and schema privileges, if any.Ĭlicking on the various buttons will display their respective tabs. The Users and Privileges screen displays a list of all users, along with relevant details for each account. To display the Users and Privileges tab, click Users and Privileges on the Management tab: The Users and Privileges tab of MySQL Workbench allows you to administer users and their respective privileges for the MySQL instance.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |