MySQL DB access for user with roles base accesses Hi Folks, 🙏 Namaste and Welcome to my blog 🙏 Hope this finds you safe and healthy! Today I am going to explain about if you are wanting to secure your Database server with proper user access-based policy. We can use MySQL role based policy, A MySQL role is a named collection of privileges. I will show you how to do that by creating roles and users, then associating those users with newly created roles. Now each user will have different roles and access by that way a user like in read-only roles will not be able to delete anything as he is read only. In each role you can give access based on your project requirement. I will create all role and users form MySQL root user. Before that we need to understand privileges, type provided by MySQL Admin Privileges – It allow user to managed MySQL server. They are Global level access can be hold by lower level u...
This page is helpful if you are new to AWS Cloud and DevOps Stack. I mostly used the Linux OS for demo.
