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 a DevOps/SRE/DevSecOps/Cloud Expert passionate about sharing knowledge and experiences. I have worked at Cotocus. I share tech blog at DevOps School, travel stories at Holiday Landmark, stock market tips at Stocks Mantra, health and fitness guidance at My Medic Plus, product reviews at TrueReviewNow , and SEO strategies at Wizbrand.

Do you want to learn Quantum Computing?

Please find my social handles as below;

Rajesh Kumar Personal Website
Rajesh Kumar at YOUTUBE
Rajesh Kumar at INSTAGRAM
Rajesh Kumar at X
Rajesh Kumar at FACEBOOK
Rajesh Kumar at LINKEDIN
Rajesh Kumar at WIZBRAND