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;
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
Find Trusted Cardiac Hospitals
Compare heart hospitals by city and services — all in one place.
Explore Hospitals