Skip to content

Instantly share code, notes, and snippets.

@cad

cad/mariadb.md

Last active October 25, 2015 18:46
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 cad/7e3a4f09857983fde1fd to your computer and use it in GitHub Desktop.
Save cad/7e3a4f09857983fde1fd to your computer and use it in GitHub Desktop.
Download ZIP
mysql related commands
Raw
mariadb.md

MariaDB

Create

CREATE DATABASE $PROJECT_NAME DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
CREATE USER   $PROJECT_NAME@locahlost identified by '$DB_PASS';
GRANT ALL PRIVILEGES ON $PROJECT_NAME.* to '$PROJECT_NAME'@'localhost' IDENTIFIED BY '$DB_PASS';
FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment