Wed, 11 Oct 2023 13:35:52 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/deep-dive-into-roles-in-mysql-8-0/ https://www.percona.com/blog/deep-dive-into-roles-in-mysql-8-0/#comments Wed, 11 Oct 2023 13:35:52 +0000 https://www.percona.com/blog/?p=91298 This blog post discusses roles in MySQL 8.0, which are named collections of privileges. Like user accounts, roles can have privileges granted and revoked as required.Typically, we have multiple users with the same set of privileges. Previously, the only way to grant and revoke privileges to multiple users was to change the privileges of each […]]]> https://www.percona.com/blog/deep-dive-into-roles-in-mysql-8-0/feed/ 1 91298 https://www.percona.com/blog/identify-active-databases-and-users-in-mysql/ https://www.percona.com/blog/identify-active-databases-and-users-in-mysql/#comments Wed, 25 Jan 2023 13:40:56 +0000 https://www.percona.com/blog/?p=84261 Database administrators often need to identify inactive databases and users to save resources.  This can be done using various methods to determine which databases and users are frequently accessed. We can save disk space and other resources by purging inactive databases and users. This task is part of regular maintenance and helps to manage disk […]]]> https://www.percona.com/blog/identify-active-databases-and-users-in-mysql/feed/ 1 84261