DataBase/MySQL

사용자 추가 / DB 추가

백룡화검 2015. 11. 25. 17:14

use mysql;


select host, user, password from user;


create user '유저명'@'localhost or IP주소 or %' identified by '패스워드';


show databases;


create database 디비명 default character set utf8;



grant all privileges on 디비명.* to 유저명@'%' identified by '패스워드';


flush privileges;