mysql -uroot -p
ÀÇ ¸í·ÉÀ¸·Î MySQL ÄÜ¼Ö ¸ðµå·Î Á¢¼ÓÇÕ´Ï´Ù. Password ¸¦ ¹°¾î º¸¸é root Æнº¿öµå¸¦ ÀÔ·ÂÇØ¾ß °ÚÁÒ ?
±×·³..
ÀÌÁ¦ »ý¼ºÇÒ °èÁ¤ÀÌ »ç¿ëÇÒ µ¥ÀÌÅͺ£À̽º¸¦ Ãß°¡ÇØ¾ß °ÚÁÒ ? µ¥ÀÌÅÍ º£À̽º Ãß°¡ ¸í·ÉÀº
CREATE DATABASE [IF NOT EXISTS] db_name
ÀÌ·±½ÄÀÇ SQL ¹® ÀÔ´Ï´Ù.
±×·³ ¸¹Àº »ç¶÷µéÀÌ Á¦·Îº¸µå¸¦ »ç¿ëÇÏ´Ï zboard ¸¦ ¸¸µé¾î º¸°Ú½À´Ï´Ù. ±×·¯¸é
CREATE DATABASE IF NOT EXISTS zboard;
ÀÌ·¸°Ô ÀÔ·ÂÇÕ´Ï´Ù. ±×·³ zboard µðºñ°¡ Ãß°¡ µÇ°ÚÁÒ!
ÀÌÁ¦ MySQL °èÁ¤À» ¸¸µé¾î º¼±î¿ä ?
¸ÕÀú °èÁ¤ »ý¼º SQL ¹® ¸ÕÀú ¾Ë¾Æ º¼±î¿ä ?
GRANT USAGE ON *.* TO »ç¿ëÀÚID@Á¢¼ÓÈ£½ºÆ® IDENTIFIED BY "Æнº¿öµå"
ÀÌ·¸°Ô ±¸¼ºµÇ¾î ÀÖ½À´Ï´Ù.
±×·³ È£½ºÆ®´Â localhost »ç¿ëÀÚ ID ´Â zboard Æнº¿öµå´Â password ·Î Ãß°¡ ÇϽ÷Á¸é..
GRANT USAGE ON *.* TO zboard@localhost IDENTIFIED BY "password";
À§¿Í °°Àº SQL ¹®À̵ǰÚÁÒ ?
ÀÌÁ¨.. À§¿¡¼ »ý¼ºÇÑ µ¥ÀÌÅÍ º£À̽ºÀÇ »ç¿ë±ÇÇÑÀ» ºÎ¿©ÇØ¾ß °ÚÁÒ..
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON db_name TO »ç¿ëÀÚID@Á¢¼ÓÈ£½ºÆ®
ÀÌ·± ¸í·ÉÀ¸·Î ÀÌ·ç¾îÁ® ÀÖ½À´Ï´Ù.
±×·³ È£½ºÆ®´Â localhost »ç¿ëÀÚ ID ´Â zboard µ¥ÀÌÅÍ º£À̽º À̸§Àº zboard ¶ó°í ÇÑ´Ù¸é..
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON zboard.* TO zboard@localhost;
ÀÌ·¸°Ô µÇ°Ú³×¿è..
ÀÌÁ¦ ¼³Á¤À» ´Ù½Ã ÇßÀ¸´Ï ±ÇÇÑÀ» ´Ù½Ã ·Îµå ÇØ¾ß ÇϹǷÎ
FLUSH PRIVILEGES;
SQL ¹®À» ÀÔ·ÂÇØ ÁÖ¸é.. µÇ°ÚÁÕ..
ÀÌÁ¦ Á¾·á ÇϽðí...
¸¸µç °èÁ¤À¸·Î MySQL ¿¡ Á¢¼ÓÇØ º¼±î¿è
mysql -uzboard -p zboard
ÀÌ·± ¸í·ÉÀ¸·Î Á¢¼ÓÇÏ½Ã¸é µË´Ï´Ù. Æнº¿öµå¸¦ ¹°¾î º¸¸é °èÁ¤ÀÇ Æнº¿öµå¸¦ ÀÔ·ÂÇÏ½Ã¸é µË´Ï´Ù.
±×·³ ½Ç ¿¹·Î...
Windows ÀÇ APM_Setup ¿¡¼ .. À§ÀÇ ¸í·ÉÀ» ½ÇÇàÇÑ ³»¿ëÀ» ÷ºÎÇØ º¾´Ï´Ù.
C:\>cd APM_Setup\Server\MySQL\bin
C:\APM_Setup\Server\MySQL\bin>mysql.exe -uroot -p Enter password: ******** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 4.0.15-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> CREATE DATABASE IF NOT EXISTS zboard; Query OK, 1 row affected (0.00 sec)
mysql> GRANT USAGE ON *.* TO zboard@localhost IDENTIFIED BY "password"; Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON zboard.* TO zboard@localhost; Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec)
mysql> exit Bye
C:\APM_Setup\Server\MySQL\bin>mysql.exe -uzboard -p zboard Enter password: ******** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 17 to server version: 4.0.15-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> exit Bye
C:\APM_Setup\Server\MySQL\bin>
±×·³. ¼ö°í Çϼ¼¿ä!! |
|
|
|