{"id":118,"date":"2013-09-23T10:00:00","date_gmt":"2013-09-23T01:00:00","guid":{"rendered":"https:\/\/jikoman.sin-cos.com\/blog\/?p=118"},"modified":"2013-09-23T10:00:00","modified_gmt":"2013-09-23T01:00:00","slug":"dti_23","status":"publish","type":"post","link":"https:\/\/jikoman.sin-cos.com\/blog\/2013\/09\/dti_23\/","title":{"rendered":"DTI\u30b5\u30fc\u30d0\u30fc\u69cb\u7bc9\uff13\uff10 \u300c\u79c1\u306e\u3082\u306e\u300d"},"content":{"rendered":"

MySQL\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3002<\/p>\n

$ sudo yum -y install mysql-server
\u3000\uff1a
Installed:
\u00a0 mysql-server.x86_64 0:5.1.69-1.el6_4 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0
Dependency Installed:
\u00a0 mysql.x86_64 0:5.1.69-1.el6_4 \u00a0 \u00a0 perl-DBD-MySQL.x86_64 0:4.013-3.el6 \u00a0 \u00a0 perl-DBI.x86_64 0:1.609-4.el6 \u00a0
Complete!
\u7d9a\u3044\u3066\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u306e\u7de8\u96c6\u3002<\/p>\n

$ sudo vi \/etc\/my.cnf
\u6587\u5b57\u30a8\u30f3\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u306e\u5909\u66f4\u3002<\/p>\n

[mysqld]
skip-character-set-client-handshake
character-set-server=utf8
[mysql]
default-character-set=utf8
\u8d77\u52d5\uff01<\/p>\n

$ sudo service mysqld start
\u81ea\u52d5\u8d77\u52d5\u306e\u8a2d\u5b9a\uff01<\/p>\n

$ sudo chkconfig mysqld on
\u3053\u308c\u3067MySQL\u30b5\u30fc\u30d0\u30fc\u306f\u8d77\u52d5\u3057\u3066\u6e96\u5099OK\u3002<\/p>\n

\u3068\u308a\u3042\u3048\u305a\u3001\u30e6\u30fc\u30b6\u30fc\u3068\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3057\u3066\u304a\u304f\u3002<\/p>\n

$ mysql -u root
MySQL\u306e\u5168\u30e6\u30fc\u30b6\u30fc\uff20\u30db\u30b9\u30c8\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8868\u793a\u3002<\/p>\n

mysql> SELECT user, host, password \u00a0FROM mysql.user;
+——+—————–+———-+
| user | host \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| password |
+——+—————–+———-+
| root | localhost \u00a0 \u00a0 \u00a0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0|
| root | example.com | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0|
| root | 127.0.0.1 \u00a0 \u00a0 \u00a0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0|
| \u00a0 \u00a0 \u00a0| localhost \u00a0 \u00a0 \u00a0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0|
| \u00a0 \u00a0 \u00a0| example.com | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0|
+——+—————–+———-+
5 rows in set (0.01 sec)
\u30e6\u30fc\u30b6\u30fc\u540d\u304c\u306a\u3044\u3068\u304d\u306f\u62d2\u5426\u3059\u308b\u305f\u3081\u306b\u3001\u524a\u9664\u3002<\/p>\n

mysql> DELETE FROM mysql.user WHERE user=”;
Query OK, 2 rows affected (0.00 sec)
\u78ba\u8a8d<\/p>\n

mysql> SELECT user, host, password \u00a0FROM mysql.user;
+——+—————–+———-+
| user | host \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| password |
+——+—————–+———-+
| root | localhost \u00a0 \u00a0 \u00a0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0|
| root | example.com | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0|
| root | 127.0.0.1 \u00a0 \u00a0 \u00a0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0|
+——+—————–+———-+
3 rows in set (0.00 sec)
\u30d1\u30b9\u30ef\u30fc\u30c9\u304c\u5165\u3063\u3066\u3044\u306a\u3044\u306e\u3067\u3001\u8a2d\u5b9a\u3002<\/p>\n

mysql> SET PASSWORD FOR root@localhost=password(‘Pass-for-root’);
Query OK, 0 rows affected (0.00 sec)
\u78ba\u8a8d\u3002<\/p>\n

mysql> SELECT user, host, password \u00a0FROM mysql.user;
+——+—————–+——————————————-+
| user | host \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| password \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0|
+——+—————–+——————————————-+
| root | localhost \u00a0 \u00a0 \u00a0 | *fhjtugkfirueidkfjgutiyigjfhrutyfhdjfuryt |
| root | example.com | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |
| root | 127.0.0.1 \u00a0 \u00a0 \u00a0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |
+——+—————–+——————————————-+
3 rows in set (0.00 sec)
\u3042\u3068\u3001\uff12\u56de\u3002\u30e6\u30fc\u30b6\u30fc\u81ea\u4f53\u3092\u6d88\u3057\u3066\u3082OK\u3060\u3051\u3069\u3002<\/p>\n

mysql> SET PASSWORD FOR root@’example.com’=password(‘Pass-for-root’);
Query OK, 0 rows affected (0.00 sec)<\/p>\n

mysql> SET PASSWORD FOR root@127.0.0.1=password(‘Pass-for-root’);
Query OK, 0 rows affected (0.00 sec)
\u518d\u5ea6\u78ba\u8a8d\u3002<\/p>\n

mysql> SELECT user, host, password \u00a0FROM mysql.user;
+——+—————–+——————————————-+
| user | host \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| password \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0|
+——+—————–+——————————————-+
| root | localhost \u00a0 \u00a0 \u00a0 | *fhjtugkfirueidkfjgutiyigjfhrutyfhdjfuryt |
| root | example.com | *fhjtugkfirueidkfjgutiyigjfhrutyfhdjfuryt |
| root | 127.0.0.1 \u00a0 \u00a0 \u00a0 | *fhjtugkfirueidkfjgutiyigjfhrutyfhdjfuryt |
+——+—————–+——————————————-+
3 rows in set (0.00 sec)
\u3068\u308a\u3042\u3048\u305a\u3001\u30e6\u30fc\u30b6\u30fc\u306e\u8a2d\u5b9a\u306f\u5b8c\u4e86\u3002<\/p>\n

\u6b21\u306b\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4e00\u89a7\u3092\u8868\u793a<\/p>\n

mysql> SHOW DATABASES;
+——————–+
| Database \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |
+——————–+
| information_schema |
| mysql \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0|
| test \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |
+——————–+
3 rows in set (0.00 sec)
\u30c6\u30b9\u30c8\u7528\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u524a\u9664\u3002<\/p>\n

mysql> DROP DATABASE test;
Query OK, 0 rows affected (0.00 sec)
\u7d42\u4e86\u3002<\/p>\n

mysql> quit
Bye
\u518d\u5ea6\u5165\u308b\u3068\u304d\u306f\u3001\u4eca\u8a2d\u5b9a\u3057\u305f\u30d1\u30b9\u30ef\u30fc\u30c9\u304c\u5fc5\u8981\u3002<\/p>\n

$ mysql -u root -p
Enter password: \u5165\u529b\u3059\u308b\u3068\u5165\u308c\u308b\u3002<\/p>\n

\u3042\u3068\u306f\u3001\u9069\u5f53\u306b\u3002<\/div>\n\n\n

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

MySQL\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3002 $ sudo yum -y install mysql-server\u3000\uff1aInstalled:\u00a0 mysql-server.x86_64 0:5.1.69-1.el6_4 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[129,130],"tags":[17,43],"class_list":["post-118","post","type-post","status-publish","format-standard","hentry","category-pc","category-130","tag-dti","tag-vps"],"_links":{"self":[{"href":"https:\/\/jikoman.sin-cos.com\/blog\/wp-json\/wp\/v2\/posts\/118","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jikoman.sin-cos.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jikoman.sin-cos.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jikoman.sin-cos.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jikoman.sin-cos.com\/blog\/wp-json\/wp\/v2\/comments?post=118"}],"version-history":[{"count":0,"href":"https:\/\/jikoman.sin-cos.com\/blog\/wp-json\/wp\/v2\/posts\/118\/revisions"}],"wp:attachment":[{"href":"https:\/\/jikoman.sin-cos.com\/blog\/wp-json\/wp\/v2\/media?parent=118"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jikoman.sin-cos.com\/blog\/wp-json\/wp\/v2\/categories?post=118"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jikoman.sin-cos.com\/blog\/wp-json\/wp\/v2\/tags?post=118"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}