{"id":2210,"date":"2011-06-30T17:40:48","date_gmt":"2011-06-30T08:40:48","guid":{"rendered":"http:\/\/pchero21.com\/?p=2210"},"modified":"2011-06-30T17:40:48","modified_gmt":"2011-06-30T08:40:48","slug":"mysql-projectmysql-%ec%97%b0%eb%8f%99-3-%ea%b8%b0%ec%b4%88","status":"publish","type":"post","link":"http:\/\/pchero21.com\/?p=2210","title":{"rendered":"MySQL : Project(MySQL \uc5f0\ub3d9) 3 \u2013 \uae30\ucd08"},"content":{"rendered":"

1. MySQL \uc2dc\uc791\ud558\uae30 <\/strong><\/h1>\n

MySQL \uad6c\ub3d9 \ud558\uae30.<\/strong><\/p>\n

$ \/etc\/init.d\/mysql start<\/p><\/blockquote>\n

 <\/p>\n

MySQL \uc811\uc18d\ud558\uae30<\/strong><\/p>\n

$ mysql -uroot -p1234567890<\/p><\/blockquote>\n

-u \ub2e4\uc74c\uc5d0\ub294 \uc811\uc18d\ud558\uace0\uc790 \ud558\ub294 ID, -p \ub2e4\uc74c\uc5d0\ub294 \uc811\uc18d\ud558\uace0\uc790 \ud558\ub294 \uacc4\uc815\uc758 \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc785\ub825\ud55c\ub2e4.<\/p>\n

 <\/p>\n

MySQL\uc5d0\uc11c \ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc0dd\uc131\ud558\uae30<\/strong><\/p>\n

mysql> create database test;<\/p><\/blockquote>\n

\uc0dd\uc131\ud55c \ub370\uc774\ud130 \ubca0\uc774\uc2a4 \ud655\uc778\ud558\uae30<\/p>\n

mysql> show databases;<\/p>\n

 <\/p>\n

MySQL\uc5d0\uc11c \ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc120\ud0dd\ud558\uae30<\/strong><\/p>\n

mysql> use test;<\/p><\/blockquote>\n

use \ub2e4\uc74c\uc5d0 \uc0ac\uc6a9\ud558\uace0\uc790 \ud558\ub294 \ub370\uc774\ud130 \ubca0\uc774\uc2a4\ub97c \uc785\ub825\ud55c\ub2e4.<\/p>\n

 <\/p>\n

\uc120\ud0dd\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ud14c\uc774\ube14 \ub9cc\ub4e4\uae30<\/strong><\/p>\n

mysql> CREATE TABLE student (
\n-> name varchar(10),
\n-> korean int,
\n-> math int,
\n-> english int
\n-> );<\/p>\n

student \ub77c\ub294 \uc774\ub984\uc758 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\ub294 \ucffc\ub9ac\uc774\ub2e4.\u00a0 \ud14c\uc774\ube14 \uc0dd\uc131 \ud6c4, Data Directory \ub97c \ud655\uc778\ud558\uba74, \ub370\uc774\ud130 \ubca0\uc774\uc2a4 \ub514\ub809\ud1a0\ub9ac \uc18d\uc5d0 student\ub77c\ub294 \uc774\ub984\uc744 \uac00\uc9c4 \ud30c\uc77c\ub4e4\uc774 \uc0dd\uc131\ub41c \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/p>\n

root@jonathan-laptop:\/var\/lib\/mysql\/test# pwd
\n\/var\/lib\/mysql\/test
\nroot@jonathan-laptop:\/var\/lib\/mysql\/test# ls -slh|grep student
\nrw-rw—- 1 mysql mysql\u00a0\u00a0\u00a0 0 2011-06-30 10:59 student.MYD
\nrw-rw—- 1 mysql mysql 1.0K 2011-06-30 10:59 student.MYI
\nrw-rw—- 1 mysql mysql 8.5K 2011-06-30 10:59 student.frm<\/p><\/blockquote>\n

 <\/p>\n

\uc0dd\uc131\ud55c \ud14c\uc774\ube14 \ud655\uc778\ud558\uae30<\/strong><\/p>\n

mysql> show tables;
\n+—————-+
\n| Tables_in_test |
\n+—————-+
\n| address\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| student\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| test\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n+—————-+<\/p><\/blockquote>\n

 <\/p>\n

\ud14c\uc774\ube14 \uc815\ubcf4 \ud655\uc778\ud558\uae30<\/strong><\/p>\n

mysql> explain student;
\n+———+————-+——+—–+———+——-+
\n| Field\u00a0\u00a0 | Type\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | Null | Key | Default | Extra |
\n+———+————-+——+—–+———+——-+
\n| name\u00a0\u00a0\u00a0 | varchar(10) | YES\u00a0 |\u00a0\u00a0\u00a0\u00a0 | NULL\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| korean\u00a0 | int(11)\u00a0\u00a0\u00a0\u00a0 | YES\u00a0 |\u00a0\u00a0\u00a0\u00a0 | NULL\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| math\u00a0\u00a0\u00a0 | int(11)\u00a0\u00a0\u00a0\u00a0 | YES\u00a0 |\u00a0\u00a0\u00a0\u00a0 | NULL\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| english | int(11)\u00a0\u00a0\u00a0\u00a0 | YES\u00a0 |\u00a0\u00a0\u00a0\u00a0 | NULL\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n+———+————-+——+—–+———+——-+
\n4 rows in set (0.00 sec)<\/p><\/blockquote>\n

 <\/p>\n

2. \uc0ac\uc6a9\uc790 \uc124\uc815
\n<\/strong><\/h1>\n

 <\/p>\n

2-1. \uc0ac\uc6a9\uc790 \uc554\ud638 \ubc14\uafb8\uae30<\/strong><\/h2>\n

MySQL\uc5d0\uc11c \uc0ac\uc6a9\uc790\uc758 \uc554\ud638\ub97c \ubcc0\uacbd\ud558\ub294 \ubc29\ubc95\uc740 \uc138\uac00\uc9c0\uac00 \uc788\ub2e4.<\/p>\n

– UPDATE \ubb38\uc744 \uc774\uc6a9
\n– SET PASSWORD \uc774\uc6a9
\n– mysqladmin \uc774\uc6a9<\/p><\/blockquote>\n

2-1-1 UPDATE \ubb38 \uc774\uc6a9\ud558\uae30<\/strong><\/p>\n

jonathan@jonathan-laptop:\/var\/lib$ mysql -uroot -p mysql<\/p>\n

mysql> update user set password=password(‘1234’) where user = ‘root’;
\nQuery OK, 3 rows affected (0.09 sec)
\nRows matched: 3\u00a0 Changed: 3\u00a0 Warnings: 0<\/p>\n

mysql> flush privileges;
\nQuery OK, 0 rows affected (0.03 sec)<\/p><\/blockquote>\n

-p \ub2e4\uc74c\uc5d0 mysql\uc740 mysql\uc774\ub780 \ub370\uc774\ud130 \ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud558\ub77c\ub294 \uac83\uc744 \uc758\ubbf8\ud55c\ub2e4. mysql \ud504\ub86c\ud504\ud2b8\uc5d0\uc11c use db_name\uc744 \uc774\uc6a9\ud558\uc5ec \uc0ac\uc6a9\ud558\uace0\uc790 \ud558\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ubcc0\uacbd\ud560 \uc218\ub3c4 \uc788\ub2e4. UPDATE \ubb38\uc744 \uc774\uc6a9\ud558\uc5ec \uc554\ud638\ub97c \ubcc0\uacbd\ud560 \uacbd\uc6b0\uc5d0\ub294 \uaf2d flush privileges; \ub97c \uc2e4\ud589\ud574\uc57c \ud55c\ub2e4.<\/p>\n

\uc774\uc720\ub294 MySQL\uc740 \uc18d\ub3c4\ub97c \uc870\uae08\uc774\ub098\ub9c8 \ube60\ub974\uac8c \ud558\uae30 \uc704\ud574 mysql \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc788\ub294 \uc0ac\uc6a9\uc790 \uad8c\ud55c\uc5d0 \uad00\ub828\ub518 \ub0b4\uc6a9\uc744 \ucc98\uc74c MySQL \uc2dc\uc791\uc2dc\uc5d0 \uba54\ubaa8\ub9ac\ub85c \uc77d\uc5b4 \ub4e4\uc774\ub294\ub370(\uba54\ubaa8\ub9ac\uac00 \ud558\ub4dc \ub514\uc2a4\ud06c\uc5d0 \ube44\ud574\uc11c \uc18d\ub3c4\uac00 \ube60\ub974\ubbc0\ub85c \uc774\ub807\uac8c \ud574\uc11c \uc0ac\uc6a9\uc790 \uc778\uc99d \ubd80\ubd84\uc5d0 \uc18d\ub3c4\ub97c \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\ub294 \uac83\uc774\ub2e4), UPDATE\ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc554\ud638\uac00 \ubc14\ub00c\uc5c8\uc744 \ub54c\ub294 flush privileges; \ub97c \uc774\uc6a9\ud558\uc5ec \uc0ac\uc6a9\uc790 \uad00\ub828 \ud14c\uc774\ube14\uc5d0 \ubcc0\uacbd\ub41c \ub0b4\uc6a9\uc774 \uc788\uc73c\ub2c8 \ub2e4\uc2dc \uc77d\uc73c\ub77c\uace0 \uc11c\ubc84\uc5d0 \uc54c\ub824\uc57c \ud55c\ub2e4.<\/p>\n

2-1-2 SET PASSWORD \uc774\uc6a9\ud558\uae30<\/strong><\/p>\n

mysql> SET PASSWORD for root=password(‘1234’);<\/p>\n

\uc774 \ubc29\ubc95\uc740 flush privileges; \ub97c \ud560 \ud544\uc694\uac00 \uc5c6\uc74c. \uadf8\ub7ec\ub098 MySQL 5.1 \ubc84\uc804\uc5d0\uc11c\ub294 \uc81c\ub300\ub85c \ub418\uc9c0 \uc54a\ub294\uac83\uc744 \ud655\uc778\ud588\uc74c.<\/p>\n

2-1-3 mysqladmin \uc774\uc6a9\ud558\uae30<\/strong><\/p>\n

$ mysqladmin -u root password\u00a0 new-password<\/p><\/blockquote>\n

 <\/p>\n

2-2 \uc0c8\ub85c\uc6b4 \uc0ac\uc6a9\uc790 \ub4f1\ub85d\ud558\uae30<\/strong><\/h2>\n

MySQL\uc5d0\uc11c \uc0c8\ub85c\uc6b4 \uc0ac\uc6a9\uc790\ub97c \ucd94\uac00\ud558\ub294 \ubc29\ubc95\uc740 GRANT\ub97c \uc774\uc6a9\ud558\ub294 \ubc29\ubc95\uacfc \uc9c1\uc811 mysql\uc758 user \ud14c\uc774\ube14\uc5d0 INSERT \ud558\ub294 \ubc29\ubc95 \ub450\uac00\uc9c0\uac00 \uc788\ub2e4.<\/p>\n

2-2-1 GRANT\ubb38 \uc774\uc6a9<\/strong><\/p>\n

mysql> grant all privileges on *.* to pchero@localhost identified by ‘1234’ with grant option;
\nQuery OK, 0 rows affected (0.04 sec)<\/p><\/blockquote>\n

localhost\uc758 pchero\uc5d0\uac8c (to pchero@localhost) 1234\ub77c\ub294 \uc554\ud638\ub85c(identified by ‘1234’) MySQL\uc758 \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc788\ub294 \ubaa8\ub4e0 \ud14c\uc774\ube14\uc5d0(on *.*) \ubaa8\ub4e0 \uad8c\ud55c (all privileges)\uc744 \ubd80\uc5ec\ud558\ub294 \uac83\uc744 \uc758\ubbf8\ud55c\ub2e4.<\/p>\n

\uc704\uc758 \ucffc\ub9ac\ubb38\uc740 \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub3c4\ub85d \ud558\ub294 \ucffc\ub9ac\uc778\ub370, \uc774\ub97c \ud2b9\uc815 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ud55c\uc815\ud558\uae30 \uc704\ud574\uc11c\ub294 \ub2e4\uc74c\uc758 \ucffc\ub9ac\ubb38\uc744 \uc0ac\uc6a9\ud558\ub3c4\ub85d \ud55c\ub2e4.<\/p>\n

mysql> grant all privileges on test.* to pchero@localhost identified by ‘1234’;<\/p><\/blockquote>\n

\uc704\uc758 \ucffc\ub9ac\ubb38\uc740 localhost\uc758 pchero\uc5d0\uac8c test \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubaa8\ub4e0 \ud14c\uc774\ube14\uc5d0 \ubaa8\ub4e0 \uad8c\ud55c\uc744 \ubd80\uc5ec\ud558\ub294 \uac83\uc744 \ub098\ud0c0\ub0b8\ub2e4. \ud2b9\uc815 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ud2b9\uc815 \uad8c\ud55c\ub9cc\uc744 \ubd80\uc5ec\ud558\uae30 \uc704\ud574\uc11c\ub294 \ub2e4\uc74c\uc758 \ucffc\ub9ac\ubb38\uc744 \uc218\ud589\ud55c\ub2e4.<\/p>\n

mysql> grant select, insert on test.* to pchero@localhost identified by ‘1234’;<\/p><\/blockquote>\n

\uc774 \uc678\uc5d0\ub3c4 \ud2b9\uc815 \ud14c\uc774\ube14\uc774\ub098 \ud2b9\uc815 \uceec\ub7fc\uc5d0\ub9cc \uad8c\ud55c\uc744 \uc8fc\ub294 \ubc29\ubc95\ub3c4 \uc788\ub2e4.<\/p>\n

2-2-2 INSERT\ubb38 \uc774\uc6a9\ud558\uae30<\/strong><\/p>\n

insert into user values(‘localhost’, ‘pchero’, password(‘1234’), ‘N’, ‘N’, ‘N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’);<\/p><\/blockquote>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

1. MySQL \uc2dc\uc791\ud558\uae30 MySQL \uad6c\ub3d9 \ud558\uae30. $ \/etc\/init.d\/mysql start   MySQL \uc811\uc18d\ud558\uae30 $ mysql -uroot -p1234567890 -u \ub2e4\uc74c\uc5d0\ub294 \uc811\uc18d\ud558\uace0\uc790 \ud558\ub294 ID, -p \ub2e4\uc74c\uc5d0\ub294 \uc811\uc18d\ud558\uace0\uc790 \ud558\ub294 \uacc4\uc815\uc758 \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc785\ub825\ud55c\ub2e4.   MySQL\uc5d0\uc11c \ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc0dd\uc131\ud558\uae30 mysql> create database test; \uc0dd\uc131\ud55c \ub370\uc774\ud130 \ubca0\uc774\uc2a4 … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[17],"tags":[142,144,272],"_links":{"self":[{"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/posts\/2210"}],"collection":[{"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/pchero21.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2210"}],"version-history":[{"count":0,"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/posts\/2210\/revisions"}],"wp:attachment":[{"href":"http:\/\/pchero21.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/pchero21.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2210"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/pchero21.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}