'Programing/MySQL'에 해당되는 글 1건

  1. 2014.11.05 MySQL : 스키마, 계정 생성
Programing/MySQL2014. 11. 5. 16:15

MySQL : 스키마, 계정 생성

SELECT *
FROM mysql.user;

SELECT *
FROM mysql.db;

CREATE DATABASE admanager;

INSERT INTO mysql.user (host, user, password, ssl_cipher, x509_issuer, x509_subject)
VALUES ('%', 'admanager', password('admanager'), '', '', '');

INSERT INTO mysql.db (host, db, user) VALUES ('%', 'admanager', 'admanager');

FLUSH PRIVILEGES;


Posted by ChulE

티스토리툴바