Skip to content

Instantly share code, notes, and snippets.

@yannvery

yannvery/grant_user_mysql.md

Created December 15, 2015 10:20
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save yannvery/4877ae81f70fa588c103 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save yannvery/4877ae81f70fa588c103 to your computer and use it in GitHub Desktop.
Download ZIP
Create user and grant it on database
Raw
grant_user_mysql.md

Create a user and add privileges to access database remotly :

CREATE USER 'application'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON application_database.* TO 'application'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment