Skip to content

Instantly share code, notes, and snippets.

@tkuchiki
Last active December 30, 2015 08:39
Show Gist options
  • Save tkuchiki/7804211 to your computer and use it in GitHub Desktop.
Save tkuchiki/7804211 to your computer and use it in GitHub Desktop.
nginx rds-
mysql> CREATE DATABASE test_db DEFAULT CHARACTER SET utf8;
mysql> CREATE TABLE test_db.users (id int(11) unsigned AUTO_INCREMENT, username varchar(512), password varchar(512), PRIMARY KEY (id));
mysql> INSERT INTO test_db.users (username, password) VALUES ('foo', '0beec7b5ea3f0fdbc95d0dd47f3c5bc275da8a33'), ('bar', '62cdb7020ff920e5aa642c3d4066950dd1f01f4d');
# mysql> GRANT ALL PRIVILEGES ON *.* TO [email protected] IDENTIFIED BY 'test' WITH GRANT OPTION;
# mysql> GRANT ALL PRIVILEGES ON *.* TO test_user@localhost IDENTIFIED BY 'test' WITH GRANT OPTION;
# mysql> FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment