by Uday Rajarapu | Oct 11, 2023 | Insight for DBAs, MySQL
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... by Uday Rajarapu | Jan 25, 2023 | Insight for DBAs, MySQL
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...