mysql user 추가 > MySQL

STUDY ROOM

MySQL

mysql user 추가

페이지 정보

작성자 JMStudy 작성일17-02-09 17:07 조회10,283회 댓글0건

본문

mysql> create database db1;

mysql> create user 'dbuser1'@'localhost' identified by 'dbuser1password';

mysql> GRANT ALL PRIVILEGES ON db1.* TO 'dbuser1'@'localhost' WITH GRANT OPTION;



mysql> GRANT ALL PRIVILEGES ON *.* TO 'dbuser1'@'localhost'

mysql> GRANT ALL PRIVILEGES ON db1.* TO 'dbuser1'@'%' WITH GRANT OPTION;



mysql> flush privileges; 

댓글목록

등록된 댓글이 없습니다.


Warning: Unknown: write failed: Disk quota exceeded (122) in Unknown on line 0

Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/hosting/jmstudy/html/data/session) in Unknown on line 0