MySql Tutorials: How to grant user access to Database?

To grant a user access to a specific database in MySQL, you can use the following GRANT statement:

GRANT privileges ON database_name.* TO 'user_name'@'host' [IDENTIFIED BY 'password'];

Where:

• privileges: the privileges you want to grant to the user. This can be a combination of SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, and other privileges.
• database_name: the name of the database you want to grant the user access to.
• user_name: the name of the user you want to grant the privileges to.
• host: the host from which the user is connecting. This can be specified as a wildcard (e.g., '%') to allow access from any host.
• password: the password for the user (optional).

For example, to grant a user with the username 'john' and password 'password' the ability to select data from the database 'mydatabase', the following command can be used:

GRANT SELECT ON mydatabase.* TO 'john'@'%' IDENTIFIED BY 'password';

After executing the GRANT statement, you need to run the FLUSH PRIVILEGES command to reload the privileges and apply the changes:

FLUSH PRIVILEGES;

• Author
• Recent Posts

Follow me

Rajesh Kumar

DevOps - DevSecOps - SRE Coach at Rent Bikes and Cars Now using MOTOSHARE

Join my following certification courses...
- DevOps Certified Professionals (DCP)
- Site Reliability Engineering Certified Professionals (SRECP)
- Master in DevOps Engineering (MDE)
- DevSecOps Certified Professionals (DSOCP)
URL - https://www.devopsschool.com/certification/

My Linkedin - https://www.linkedin.com/in/rajeshkumarin

Follow me

Latest posts by Rajesh Kumar (see all)

• Atlassian Jira Demo - January 4, 2025
• Revolutionizing Business Management with Microsoft Business Central - January 4, 2025
• Key Benefits of Converting HTML to PDF File Format - January 2, 2025