Create read-only user – MySql
Most useful for second or third level support people where people have skills to check db directly but in case you do not want them to make changes, Read only user can be created for them in Mysql DB.
Here are two simple steps:
1. Create user
mysql> create user 'user'@'host' identified by 'some_password';
2. Grant privileges
mysql> grant select on db.* to 'user'@'host' with grant option;
Now user can login from host machine to check values in db schema.
Most Commented Posts
If you enjoyed this post, please consider to leave a comment or subscribe to the feed and get future articles delivered to your feed reader.
Comments
No comments yet.
Leave a comment