Last active
August 29, 2015 14:00
-
-
Save letusfly85/11392710 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE DATABASE sosickdev DEFAULT CHARACTER SET utf8; | |
CREATE USER sosickdev IDENTIFIED BY '$PASS'; | |
use sosikdev; | |
GRANT ALL PRIVILEGES ON sosickdev.* TO sosickdev@$HOSTNAME IDENTIFIED BY '$PASS' | |
SET PASSWORD FOR sosickdev@$HOSTNAME=PASSWORD('$PASS'); | |
flush privileges; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
drop user sosicktest@jellyfish85.com;
CREATE DATABASE sosicktest DEFAULT CHARACTER SET utf8;
SELECT host,user FROM mysql.user;
CREATE USER sosicktest IDENTIFIED BY 'sosicktest'@jellyfish85.com;
use sosicktest;
GRANT ALL PRIVILEGES ON sosicktest.* TO sosicktest@jellyfish85.com IDENTIFIED BY 'sosicktest';
GRANT ALL PRIVILEGES ON sosicktest.* TO sosicktest IDENTIFIED BY 'sosicktest';
GRANT ALL PRIVILEGES ON sosicktest.* TO sosicktest IDENTIFIED BY 'sosicktest';
GRANT ALL PRIVILEGES ON sosicktest.* TO sosicktest@jellyfish85.com IDENTIFIED BY 'sosicktest';
GRANT ALL PRIVILEGES ON sosicktest.* TO sosicktest IDENTIFIED BY 'sosicktest';
SET PASSWORD FOR sosicktest@jellyfish85.com=PASSWORD('sosicktest');
flush privileges;
SELECT host,user FROM mysql.user;