{"id":3686,"date":"2016-01-06T16:31:40","date_gmt":"2016-01-06T16:31:40","guid":{"rendered":"https:\/\/blog.ed.gs\/?p=3686"},"modified":"2016-01-06T16:31:40","modified_gmt":"2016-01-06T16:31:40","slug":"add-read-only-mysql-user","status":"publish","type":"post","link":"https:\/\/ed.gs\/2016\/01\/06\/add-read-only-mysql-user\/","title":{"rendered":"Add Read-Only MySQL User"},"content":{"rendered":"
We had a client requesting read-only access to their MySQL databases today, I thought it would be useful to log the command to create the user with select privileges on all databases.<\/p>\n
grant select on database_name.* to 'read-only_user_name'@'%' identified by 'password';<\/pre>\nThis will create the user also, you won’t need to use create user.<\/p>\n","protected":false},"excerpt":{"rendered":"
We had a client requesting read-only access to their MySQL databases today, I thought it would be useful to log the command to create the user with select privileges on all databases. grant select on database_name.* to 'read-only_user_name'@'%' identified by 'password'; This will create the user also, you won’t need to use create user.<\/p>\n","protected":false},"author":2,"featured_media":3673,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false},"categories":[45],"tags":[],"yoast_head":"\n
Add Read-Only MySQL User - E<\/title>\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n\n\n\t\n