B / Y / U / S
HOME À¥ È£½ºÆà µµ¸ÞÀÎ ¸Å´º¾ó °í°´Áö¿ø ¼³Á¤Á¤º¸ °èÁ¤½Åû 2024-12-30 Monday 
À¥ È£½ºÆÃ
# °øÁö »çÇ×
# ÀÚÁÖ ¹¯´Â Áú¹®
# Áú¹®°ú ´äº¯
# °¡ÀÔ ¹®ÀÇ
Ä¿¹Â´ÏƼ
# ÀÚÀ¯°Ô½ÃÆÇ
# ¸®´ª½ºÆÁ
# ¾ÆÀÌÅ¥ Å×½ºÆ®
# ³»È¨ ¼Ò°³
# °Ö·¯¸®
# ÀÚ·á½Ç

  ¸®´ª½ºÆÁ  Go Unix Power Tools Online Book Go Bash Guide
Read No. 104 article 2002-02-06 01:19:16
NickName   Ç®ºñ´©
Subject   ÀϹݰèÁ¤ mysql ¾ÏÈ£ ÀÚµ¿È­
1. MySql ¼³Á¤ ÆÄÀÏ À§Ä¡ 
- PREFIX/share/mysql/my-example.cnf 

2.Mysql ½ÇÇà ½ºÅ©¸³Æ® À§Ä¡ 
-PREFIX/share/mysql/mysql.server 

#cat mysql.server 
... 
if test -w / #determine if we should look at the root config file 
then #or user config file 
conf=/etc/my.cnf 
else 
conf=$HOME/.my.cnf #Using the users config file 
fi 
... 
# 

´Ù½Ã ¸»ÇÏ¿© Mysql ½ÇÇà ½ºÅ©¸³Æ® ÆÄÀÏ ¿¡ ÀÇÇؼ­ my-example.cnf ÆÄÀÏÀ» PREFIX/etc/my.cnf ¶Ç´Â $HOME/.my.cnf ÆÄÀÏ·Î
º¹»çÇÑ´Ù. 

- /etc/my.cnf, PREFIX/etc/my.cnf:Àüü »ç¿ëÀÚ¿¡°Ô Àû¿ë 
- $HOME/.my.cnf:ÇØ´ç °èÁ¤ »ç¿ëÀÚ¸¸ Àû¿ë 
ex) root »ç¿ëÀÚ¸¸ Àû¿ë ½Ãų°æ¿ì 
#cp my-example.conf ~root/.my.cnf 
#cat ~root/.my.cnf 
... 
[client] 
password=000000 
port=3306 
sock=/tmp/mysql.sock 
... 
# 
"000000" ºÎºÐ¿¡ ÀÚ½ÅÀÌ ¼³Á¤ÇÑ Æнº¿öµå¸¦ Àû´Â´Ù. ´Ù¸¥ »ç¿ëÀÚ°¡ ÇԺηΠÆнº¿öµå¸¦ º¸Áö ¸øÇϵµ·Ï Æ۹̼Ç(600)ÀûÀýÇÏ°Ô ¼³Á¤
ÇÑ´Ù. 
# 
#chmod 600 .my.cnf
Regist Addr [ 192.168.0.2 ] ¸ñ·Ïº¸±â À­±Û ¾Æ·§±Û
Á¤±ÔÇ¥Çö½Ä [ »ó¼¼ °Ë»ö ]
Page Loading [ 0.02 Sec ] SQL Time [ 0 Sec ]

Copyleft 1999-2024 by JSBoard Open Project
Theme Designed by IDOO And follow GPL2

°³ÀÎÁ¤º¸ Ãë±Þ¹æħ ÀÌ¿ë ¾à°ü »çÀÌÆ® ¸Ê ¾îµå¹Î °ü¸®