|
|
|
¸®´ª½ºÆÁ 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°èÁ¤¿¡ ¸Â°Ô Àû´çÀÌ
º¯°æÇÏ¿© Ãß°¡ÇÑ´Ù.
|
|
Page Loading [ 0.02 Sec ]
SQL Time [ 0 Sec ]
|
|
|