MySQL grant user 생성 및 권한 설정

(2007/05/17 20:39 작성)

출처: http://blog.naver.com/tyboss/70013561894

1. 사용자 생성

 

     GRANT USAGE ON *.* TO 사용자ID@접속호스트 IDENTIFIED BY "패스워드"

    

     or

    

     GRANT USAGE ON *.* TO zboard@localhost IDENTIFIED BY "password"

    

     or

    

     GRANT USAGE ON *.* TO zboard@% IDENTIFIED BY "password"

 

 

 

2. 권한 부여

 

     GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON 
     디비이름 TO 사용자ID@접속호스트

    

     or

 

     GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON 
    zboard.* TO zboard@localhost

 

    or

    

     GRANT ALL PRIVILEGES ON *.* TO zboard@%  : 모든권한주면서 외부접속

 

 

3. 권한 로드

 

     FLUSH PRIVILEGES

 

 

 

===============================================================================

 

C:\>cd APM_Setup\Server\MySQL\bin 

C:\APM_Setup\Server\MySQL\bin>mysql.exe -uroot -p 
Enter password: ******** 
Welcome to the MySQL monitor.  Commands end with ; or \g. 
Your MySQL connection id is 7 to server version: 4.0.15-nt 

Type 'help;' or '\h' for help. Type '\c' to clear the buffer. 

mysql> CREATE DATABASE IF NOT EXISTS zboard; 
Query OK, 1 row affected (0.00 sec) 

mysql> GRANT USAGE ON *.* TO zboard@localhost IDENTIFIED BY "password"; 
Query OK, 0 rows affected (0.00 sec) 

mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON zboard.* 
TO zboard@localhost; 
Query OK, 0 rows affected (0.00 sec) 

mysql> FLUSH PRIVILEGES; 
Query OK, 0 rows affected (0.00 sec) 

mysql> exit 
Bye 

C:\APM_Setup\Server\MySQL\bin>mysql.exe -uzboard -p zboard 
Enter password: ******** 
Welcome to the MySQL monitor.  Commands end with ; or \g. 
Your MySQL connection id is 17 to server version: 4.0.15-nt 

Type 'help;' or '\h' for help. Type '\c' to clear the buffer. 

mysql> exit 
Bye

C:\APM_Setup\Server\MySQL\bin>