ユーザーパスワードの設定

# mysql -u root -p
DB作成
create database hoge_test;
create database hoge_development;
create database hoge_production;
ユーザー作成
grant all on hoge_test.* to hoge@localhost;
grant all on hoge_development.* to hoge@localhost;
grant all on hoge_production.* to hoge@localhost;
外部からのアクセス許可
grant all on hoge_test.* to hoge@'192.168.1.0/255.255.255.0';
grant all on hoge_development.* to hoge@'192.168.1.0/255.255.255.0';
grant all on hoge_production.* to hoge@'192.168.1.0/255.255.255.0';
パスワード設定
set password for hoge@localhost = PASSWORD('hogehoge');