MySQL CREATE USER with Read Only permission in MySQL Database | MariaDB Server | Grant Select

CREATE USER 'username'@'localhost' IDENTIFIED BY 'Password'; GRANT SELECT ON `databasename`. * TO 'username'@'localhost'; mysql. At the mysql prompt, do one of the following steps: To give the user access to the database from any host, type the following command: grant select on database_name. * to 'read-only_user_name'@'%' identified by 'password'; Therefore to grant privileges to a user account, the GRANT statement is used. privileges_name: These are the access rights or privileges granted to the user. object: It is the name of the database object to which permissions are being granted. In the case of granting privileges on a table, this would be the table name. To view the permissions that a user has been granted in a database, you can use the sys. database_permissions view. This view provides information about the permissions that have been granted or denied on database-level securables for a specific database. In this article, we will explore the process of creating a read-only MySQL user. MySQL is a popular open-source relational database management system used by developers and organizations worldwide. By creating a readable user, you can grant limited access to your database, allowing users to view and retrieve data without the ability to modify or delete it. Managing user privileges is an essential aspect of database security, as it enables you to control who can perform specific operations on your database. In many scenarios, it is necessary to provide access to certain users or applications to maintain data integrity and prevent unauthorized changes. MySQL is an open-source relational database management system. It is commonly deployed as part of the LAMP stack (which stands for Linux, Apache, MySQL, and PHP) and, as of this writing, is the most popular open-source database in the world. This guide outlines how to create a new MySQL user and grant them the permissions needed to perform a variety of actions. After CREATE USER, you specify a username. This is immediately followed by an @ sign and then the hostname from which this user will connect. If you only plan to access this user locally from your Ubuntu server, you can specify localhost. Wrapping both the username and host in single quotes isn’t always necessary, but doing so can help to prevent errors. The PRIVILEGE value in this example syntax defines what actions the user is allowed to perform on the specified database and table. You can grant multiple privileges to the same user in one command by separating each with a comma. You can also grant a user privileges globally by entering asterisks (*) in place of the database and table names. In SQL, asterisks are special characters used to represent “all” databases or tables. This article provides a complete overview of how to create a new user account in MySQL and grant different types of privileges on a MySQL database. Learn the basics of user account management and find hints. First, let’s figure out why we need users and privileges. When you install MySQL Server on your system and create a MySQL database, you run the required commands in the MySQL shell as root or administrative user, meaning that you have the full power to control every aspect of your database. However, once you decide to let more people access and modify your MySQL database, you need to create users and grant them privileges. By doing so, you can give permissions or introduce restrictions within the databases or certain database objects. To put it simply, you will decide on who can do what and with what object types. This article provides insight into how to create a new user and grant appropriate privileges on a MySQL database. But not only that. You will also find out more about the creation of custom privileges and learn what types of privileges exist in MySQL. Moreover, you will have extra practice on how to revoke privileges and remove users from MySQL. Join this channel to get access to perks:    / @thornwebdesign