mysql create database

 

 

Mysql Database 및 User 생성 스크립입니다.

 

CREATE DATABASE DB이름 CHARACTER SET = utf8 COLLATE = utf8_bin;

USE mysql;

CREATE USER '아이디'@'%' IDENTIFIED BY '비번'; 
 
grant all privileges on DB이름.* to 아이디@'%' identified by '비번' with grant option;
 
grant all privileges on DB이름.* to 아이디@'localhost' identified by '비번' with grant option;
 
USE DB이름;
 
 
flush privileges;