본문 바로가기

Computer

mysql db 생성법

DB 생성 for Mysql
mysql -u root -p
create database 생성할DB명
use mysql


insert into user (host,user,password) values('localhost','생성할DB명',password('생성할DB비번'));

insert into user (host,user,password) values('%','생성할DB명',password('생성할DB비번'));

insert into db values ('localhost','생성할DB명','생성할DB명','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');

insert into db values ('%','생성할DB명','생성할DB명','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');

flush privileges ;