MySQL Script
#Create Database
CREATE DATABASE mydatabase CHARACTER SET utf8 COLLATE utf8_general_ci;
#Create New User
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
#Set Permission
GRANT ALL PRIVILEGES ON mydatabase. * TO 'newuser'@'localhost';
#Refresh Privileges
FLUSH PRIVILEGES;
English Version
MySQL Script
#Create Database
CREATE DATABASE mydatabase CHARACTER SET utf8 COLLATE utf8_general_ci;
#Create New User
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
#Set Permission
GRANT ALL PRIVILEGES ON mydatabase. * TO 'newuser'@'localhost';
#Refresh Privileges
FLUSH PRIVILEGES;
日本語版
MySQL スクリプト
#データベースの作成
CREATE DATABASE mydatabase CHARACTER SET utf8 COLLATE utf8_general_ci;
#新規ユーザーの作成
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
#権限の設定
GRANT ALL PRIVILEGES ON mydatabase. * TO 'newuser'@'localhost';
#権限の更新
FLUSH PRIVILEGES;
