마스터포유(Master4U)
Monday, 17 of January
 

로그인 Category
사용자.DB등록,삭제.비번바꾸기
김인호  2004-12-23 02:35:12 Hit:1733


#사용자 등록

$Admin권한
insert into user values ('localhost','사용자',패스워드,'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','','0','0','0');
$일반사용자
insert into user values ('localhost','사용자',패스워드,'N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','','0','0','0');



#DB명 등록 for 사용자

insert into db values ('localhost','사용자','DB명','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');



#사용자 삭제
delete from user where user='사용자'


#사용자 비밀번호 바꾸기

mysql> update user set password=password('패스워드') where user = '사용자' ;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0


mysql> flush privileges ;
Query OK, 0 rows affected (0.01 sec)
본문인쇄본문메일발송
☞DB생성 사용자등록 명령어
MySQL ROOT비밀번호 잃어버렸을때
Copyright 1999-2019 Zeroboard / skin by ChanBi