mysql 계정 생성 (grant 이용)

프로그래밍/리눅스 & MY-SQL |  2009/08/01 10:35

- grant 이용

grant all privileges on 디비명.* to 계정@localhost identified by '암호' with grant option;

flush privileges;

더 간단하게..

grant all on 디비명.* to 계정@localhost identified by '암호';

flush privileges;

계정삭제

revoke all on 디비명 from 계정@localhost

- mysqladmin 이용

mysqladmin -u아이디 -p비밀번호 drop ID

mysqladmin -u아이디 -p비밀번호 creat ID

2009/08/01 10:35 2009/08/01 10:35
No trackbacks, No comments.

Trackback Address :: https://youngsam.net/trackback/648

1 ... 1455 1456 1457 1458 1459 1460 1461 1462 1463 ... 2055