by
1,287 15

Create mysql user with specific permissions

Create mysql user with specific permissions: 
mysql_grant.sql
Copy Embed Code
<iframe id="embedFrame" style="width:600px; height:300px;"
src="https://www.snip2code.com/Embed/2581566/Create-mysql-user-with-specific-permissi?startLine=0"></iframe>
Click on the embed code to copy it into your clipboard Width Height
Leave empty to retrieve all the content Start End
CREATE USER 'joe'@'%' IDENTIFIED BY 'xxxxxx'; # ALL PRIVILEGES is everything except grant GRANT ALL PRIVILEGES ON APP_production_temp.* TO 'joe'@'%'; GRANT SELECT ON APP_production.* TO 'joe'@'%'; GRANT SELECT ON stats_production.* TO 'joe'@'%';
If you want to be updated about similar snippets, Sign in and follow our Channels

blog comments powered by Disqus