Skip to content

Instantly share code, notes, and snippets.

@delineas

delineas/mysql.sql

Created April 7, 2016 20:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save delineas/3de81b4c780981fd586c8bc1aa32cad5 to your computer and use it in GitHub Desktop.
Save delineas/3de81b4c780981fd586c8bc1aa32cad5 to your computer and use it in GitHub Desktop.
Download ZIP
Create MySQL Database User
Raw
mysql.sql
#logged as root > mysql -u root -p
create database DATABASENAME character set utf8 collate utf8_general_ci;
create user DATABASEUSER@localhost identified by 'DATABASEUSER';
set password for DATABASEUSER@localhost = password('CHOOSE_PASSWORD');
grant select, insert, update, delete, create, drop, index, alter, create temporary tables, lock tables on DATABASENAME.* to DATABASEUSER@localhost;
flush privileges;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment