본문 바로가기

Database

mysql id & db 생성

CREATE USER 'id'@'localhost' IDENTIFIED VIA mysql_native_password USING 'pass';

GRANT USAGE ON *.* TO 'id'@'localhost';

CREATE DATABASE IF NOT EXISTS `id`;

GRANT ALL PRIVILEGES ON `id`.* TO 'id'@'localhost';