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

  ¸®´ª½ºÆÁ  Go Unix Power Tools Online Book Go Bash Guide
Read No. 62 article 2002-01-15 23:59:55
NickName   Ç®ºñ´©
Subject   mysqld ·çÆ® ºñ¹ø ºÐ½Ç Ȥ½¼ ·çÆ®Á¢¼Ó ¾ÈµÉ¶§
1. ÇöÀç °¡µ¿µÇ¾î ÀÖ´Â mysqld µ¥¸óÀ» ³»¸°´Ù.
   /etc/init.d/mysqld stop

2. safe_mysqld -Sg & ¿É¼ÇÀ¸·Î mysql À» skip grant table¿É¼ÇÀ¸·Î
   ¹é±×¶ó¿îµå °¡µ¿ÇÑ´Ù.
   (= safe_mysqld --skip-grant &)

3. ÇöÀç skip grant table »óÅÂÀ̹ǷÎ, ¾ÆÀ̵ð¿Í ºñ¹ø¾øÀÌ ÀÛµ¿°¡´ÉÇÏ´Ù.
   mysql mysql

4. ·ç¶ß À¯ÀúÀÇ ºñ¹øÀ» ÁØ´Ù.
   use mysql;
   update user set password = password('Æнº¿öµå')
   where user = 'root';
   ÇÑ´ÙÀ½ quit ·Î ºüÁ®³ª¿Â´Ù.

5  mysql À» Á¾·áÇÑÈÄ Á¤»óÀûÀÎ mysql µ¥¸óÀ» ¶ç¿î´Ù.
   /etc/init.d/mysqld restart

6. ·çÆ®ÀÇ ±ÇÇÑÀÌ Á¤»óÀÎÁö È®ÀÎÇÑ´Ù.
   mysql -u root -p mysql

7. Á¤»ó Á¢±ÙµÇ¸é È®ÀÎ µµÀå Âï±â À§Çؼ­ ·ç¶ß ±ÇÇÑÀ»
   ´Ù½Ã Çѹø ÁöÁ¤ÇØÁØ´Ù.
   grant all privileges on *.* to root@localhost 
   -> identified by '¾ÏÈ£';

8. ÀϹÝÀûÀÎ db Ãß°¡¿Í »ç¿ëÀÚ ±ÇÇѼ³Á¤À» ÇÑ´Ù.

   ¿¹) create database dbname;
       grant all privileges on dbname.* to dbuser@localhost 
       -> identified by 'dbpasswd';

   ¿©±â¼­ dbname, dbuser, dbpasswd ´Â db°èÁ¤¿¡ ¸Â°Ô Àû´çÀÌ
   º¯°æÇÏ¿© Ãß°¡ÇÑ´Ù.
Regist Addr [ 192.168.0.2 ] ¸ñ·Ïº¸±â À­±Û ¾Æ·§±Û
Á¤±ÔÇ¥Çö½Ä [ »ó¼¼ °Ë»ö ]
Page Loading [ 0.03 Sec ] SQL Time [ 0 Sec ]

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

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