mysql create dev env

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;

CREATE DATABASE sosick DEFAULT CHARACTER SET utf8;

CREATE USER sosick@$HOSTNAME IDENTIFIED BY '$PASS';

use sosick;

GRANT ALL PRIVILEGES ON sosick.* TO sosick@$HOSTNAME IDENTIFIED BY '$PASS'

SET PASSWORD FOR sosick@$HOSTNAME=PASSWORD('$PASS');

flush privileges;

SELECT host,user FROM mysql.user;

CREATE DATABASE yesoddev DEFAULT CHARACTER SET utf8;

CREATE USER yesoddev@jellyfish85.com IDENTIFIED BY 'yesoddev';

use yesoddev;

GRANT ALL PRIVILEGES ON yesoddev.* TO yesoddev@jellyfish85.com IDENTIFIED BY 'yesoddev';

SET PASSWORD FOR yesoddev@jellyfish85.com=PASSWORD('yesoddev');

flush privileges;

CREATE USER yesoddev IDENTIFIED BY 'yesoddev';

GRANT ALL PRIVILEGES ON yesoddev.* TO yesoddev IDENTIFIED BY 'yesoddev';

SET PASSWORD FOR yesoddev=PASSWORD('yesoddev');

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;