>> Delete Reply from No. 57318 article
No. RE: MySQL.3.23.52 에서 DB, 유저, DB 추가방법..

등록 2002-09-18 14:01:00 By localhost     조회 5
이름 님    

		mysql manual에 영문으로-.-;;  있을 듯한 내용입니다.
 $mysql -u root -p mysql
create database master;
INSERT INTO user (Host, User, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Relo
ad_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv) VALUES ('%', 'mast
erReadonly', '', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'); INSERT INTO user (Host, User, Pa
ssword, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_
priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv) VALUES ('%', 'master', password('09xxx'), 'Y', 'Y'
, 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');  INSERT INTO db (Host, Db, User, Select_priv, Insert_priv
, Update_priv, Delete_priv, Create_priv, Drop_priv, Grant_priv, References_priv, Index_priv, Alter_priv) VALUES ('%', 'm
aster', 'masterReadonly', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'); INSERT INTO db (Host, Db, User, Select_priv
, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Grant_priv, References_priv, Index_priv, Alter_priv) VA
LUES ('%', 'master', 'master', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');  하고 mysql 다시시작  그정도
입니다.--T.T
[관리자] 패스워드를 입력 하십시오. 답장이 존재하면 함께 삭제됩니다.[ 목록 | 이전 ]
패스워드:    

Copyleft 1999-2026 by JSBoard Open Project
Theme Designed by IDOO All right reserved