Skip to content

Instantly share code, notes, and snippets.

@djburdick

djburdick/add_new_mysql_user

Created May 23, 2014 23:46
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save djburdick/705f7120f9a0bfb82912 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save djburdick/705f7120f9a0bfb82912 to your computer and use it in GitHub Desktop.
Download ZIP
Add new mysql user. #mysql
Raw
add_new_mysql_user
grant all privileges on prod.* to 'produser'@'%' identified by 'password';
GRANT USAGE ON *.* TO 'newproduser'@'%' REQUIRE SSL;
flush privileges;
show grants for newproduser;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment