2012. 10. 6.

DBMS/MySQL]mysql 사용자 추가 및 디비 생성



mysql > create database sms;

mysql > grant all on sms.* to smsuser@localhost identified by 'smspw' with grant option;

mysql > grant all on sms.* to smsuser identified by 'smspw' with grant option;

mysql > flush privileges;


===>사용자 추가 방법
mysql> grant all on aaa.* to abcd@localhost identified by 'abcd' with grant option;
                    ^^^^^    ^^^^^^^^^^^^^^               ^^^^^^
                     디비     계정                          비번
mysql> flush privileges;
Query OK, 0 rows affected (0.06 sec)

====> 비밀번호 변경
# mysqladmin abcd 'abcd' 'abcde'


댓글 없음:

댓글 쓰기