|
MySQL Àº ±âº»ÀûÀ¸·Î mysql À̶ó´Â DB³»¿¡ ÀÖ´Â 3°³ÀÇ Å×À̺í(user, db ,host)·Î
»ç¿ëÀÚ ±ÇÇÑÀ» ¼³Á¤ÇÕ´Ï´Ù
¼³Ä¡ÈÄ¿¡´Â ±âº»ÀûÀ¸·Î root ¸¸ À¯Àú·Î µî·Ï µË´Ï´Ù.
´Ù¸¥ »ç¿ëÀÚ´Â user ¿Í db ¿¡ µî·ÏÇØ ÁÖ¾î¾ß ÇÕ´Ï´Ù.
*Áö±Ý ÇÏ´Â ¸ðµç ³»¿ëÀº MySQL ¸Þ´º¾ó¿¡ ÀÌ¹Ì ´Ù ³ª¿Í ÀÖ½À´Ï´Ù.
»ç¿ëÀÚ ±ÇÇÑÀº 2°¡Áö·Î ³ª´©¾îÁö´Âµ¥....
1. MySQL¼¹ö¿¡ Á¢¼ÓÇÒ ¼ö ÀÖ´Â ±â´É(user Å×ÀÌºí »ç¿ë)
2. °¢ DB¸¦ »ç¿ëÇÒ ¼ö ÀÖ´À ±â´É (db Å×ÀÌºí »ç¿ë)
ÇѰ¡Áö ÁÖÀÇ ÇϽÇÁ¡Àº user Å×ÀÌºí¿¡ ±ÇÇÑÀ» 'Y'·Î ÁÖ¸é ±× ±ÇÇÑÀÌ ¸ðµç DB ¿¡ Àû¿ëÀÌ µÈ´Ù´Â Á¡ÀÔ´Ï´Ù.
½ÉÁö¾î ±ÇÇÑÀ» ¼³Á¤ÇÏ´Â mysql DB±îÁöµµ ¸»ÀÔ´Ï´Ù.
±×·¯¹Ç·Î user Å×ÀÌºí¿¡´Â ¹Ýµå½Ã Á¢¼Ó¸¸ °¡´ÉÇϵµ·Ï ¸ðµç ±â´ÉÀ» 'N' ·Î Áֽðí
db Å×ÀÌºí¿¡¼ »ç¿ëÀÚ¿¡°Ô Àû´çÇÑ DB¸¦ ÁÖ´Â °ÍÀÌ ¸Å¿ì ¹Ù¶÷Á÷ ÇÕ´Ï´Ù.
ÀÚ ´ÙÀ½ ½Ã³ª¸®¿À µû¸¥ ½ÇÁ¦ ÀÛ¾÷ ȸéÀ» º¸½Ã°í Âü°í ÇϽñ⠹ٶø´Ï´Ù.
--------------
óÀ½¿¡ root ·Î ·Î±×ÀÎ Çß´Ù´Â °¡Á¤ÇÏ¿¡ myuser ¶ó´Â »ç¿ëÀÚ¸¦ Ãß°¡ Çϰí
±× »ç¿ëÀÚ¿¡°Ô MYUSER ¶ó´Â DB¸¦ »ý¼ºÇØ ÁÖ°í ÇØ´ç DB ¿¡¼ ¸ðµç ±ÇÇÑÀ» ÁØ´Ù
-------------
[root@home /root]# mysql mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1961 to server version: 3.22.20a-log
Type 'help' for help.
//»ç¿ëÀÚ¸¦ µî·ÏÇÕ´Ï´Ù. Á¢¼ÓÇÒ ¼ö ÀÖ´Â ±ÇÇѸ¸!
mysql> insert into user values ('localhost','myuser',password('mypasswd'),'N','N','N','N','N'
-> ,'N','N','N','N','N','N','N','N','N');
Query OK, 1 row affected (0.00 sec)
// »ç¿ëÀÚ°¡ »ç¿ëÇÒ DB¿Í ±ÇÇÑÀ» ÁÝ´Ï´Ù.
mysql> insert into db values('localhost','MYUSER','myuser','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
Query OK, 1 row affected (0.00 sec)
mysql> q
Bye
// DB¸¦ ¸¸µé¾î ÁÝ´Ï´Ù
[root@home /root]# /usr/local/mysql/bin/mysqladmin create MYUSER
Database "MYUSER" created.
// ±ÇÇÑ Å×À̺íÀ» ´Ù½Ã Àеµ·Ï ¼¹ö¸¦ Reload ÇÕ´Ï´Ù
[root@home /root]# /usr/local/mysql/bin/mysqladmin reload
// ÀÌÁ¦ ¸¸µé¾îÁø »ç¿ëÀÚ·Î MySQL¼¹ö¿¡ ·Î±×ÀÎ ÇÕ´Ï´Ù.
[root@home /root]# mysql -umyuser -pmypasswd MYUSER
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1965 to server version: 3.22.20a-log
Type 'help' for help.
mysql> create table mytable(id int , name char(10) ) ;
Query OK, 0 rows affected (0.01 sec)
mysql> insert into mytable values(1,'loveme');
Query OK, 1 row affected (0.00 sec)
mysql> select * from mytable ;
+------+--------+
| id | name |
+------+--------+
| 1 | loveme |
+------+--------+
1 row in set (0.00 sec)
mysql>
// ¸ðµç°Ô Àß µ¹¾Æ°¡´Â µí ÇÕ´Ï´Ù ^,^
|