Connect to MariaDB

How to Create User and Grant Privileges?

To manage users in MariaDB, we need to understand how to create users and grant them appropriate privileges. Let’s understand step-by-step instructions and examples....

Connect to MariaDB

Use the MariaDB client or command–line interface to connect to the MariaDB server. Let’s Enter the password and access the MariaDB client....

Create a User

Once we are connected to the MariaDB server, use the CREATE USER statement to create a new user. Replace the username and password with the desired username and password for the new user....

Grant Permissions

Use the GRANT statement to grant privileges to the user. Specify the privileges and the database or tables they apply to. Replace username and database_name with appropriate values....

Reload Privileges

After granting privileges, we need to reload the privileges for the changes to take effect. we have to enter the following command each time we run a command on the MariaDB server....

Remove MariaDB User Account

If we need to remove a user, we can use the DROP statement:...

Conclusion

Overall, Assigning rights and privileges for your users also plays a big role in protecting the security and safety of your MariaDB databases. By implementing what you have read in this article and keeping in mind the right practices, you will offer users necessary access while also protecting the sensitive data from external users. Frequently monitoring and updating user privileges is a necessary step to keep the security environment healthy through changes in security requirements and consistent database environment....