1,287 15

Create mysql user with specific permissions

Create mysql user with specific permissions: 
Copy Embed Code
<iframe id="embedFrame" style="width:600px; height:300px;"
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