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'];
Code language: JavaScript (javascript)

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';
Code language: JavaScript (javascript)

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

FLUSH PRIVILEGES;

Rajesh Kumar

I’m Rajesh Kumar, a DevOps, SRE, DevSecOps, Cloud, and Platform Engineering expert passionate about sharing practical knowledge, real-world experiences, and industry best practices. I have worked at Cotocus and regularly write about technology, travel, investing, health, product reviews, and digital marketing through my various platforms.

I publish technical articles at DevOps School, travel stories at Holiday Landmark, stock market insights at Stocks Mantra, health and fitness guidance at My Medic Plus, product reviews at TrueReviewNow, and SEO and digital marketing strategies at Wizbrand.