{"id":346,"date":"2010-06-14T18:48:42","date_gmt":"2010-06-14T09:48:42","guid":{"rendered":"https:\/\/blog.eldhrimnir.com?p=346"},"modified":"2010-06-14T18:48:42","modified_gmt":"2010-06-14T09:48:42","slug":"wordpress%e3%81%ae%e3%82%a4%e3%83%b3%e3%82%b9%e3%83%88%e3%83%bc%e3%83%ab%e6%ba%96%e5%82%99%ef%bc%88serversmanvps%ef%bc%89","status":"publish","type":"post","link":"https:\/\/blog.eldhrimnir.com\/?p=346","title":{"rendered":"WordPress\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6e96\u5099\uff08ServersMan@VPS\uff09"},"content":{"rendered":"

\u00a0\u3044\u304d\u306a\u308aWordpress\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u3044\u3068\u3053\u308d\u306a\u3093\u3067\u3059\u304c\u2026\u3002
\n\u305f\u3076\u3093\u30d1\u30c3\u30b1\u30fc\u30b8\u304c\u8db3\u308a\u306a\u3044\u306e\u3067\u307e\u305a\u306f\u5fc5\u8981\u30d1\u30c3\u30b1\u30fc\u30b8\u304b\u3089\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002<\/p>\n

1.PHP \u3068 MySQL\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/strong><\/p>\n

\u30d1\u30c3\u30b1\u30fc\u30b8\u78ba\u8a8d
\nyum info mysql-server<\/strong><\/span><\/p>\n

\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb
\nyum install mysql-server
\nyum php-devel php-mbstring php-mysql<\/strong><\/span>\uff08\u5ff5\u306e\u305f\u3081\uff09<\/p>\n

MySQL \u3092\u8d77\u52d5
\n$\/etc\/init.d\/mysqld start<\/strong><\/span><\/p>\n

MySQL\u81ea\u52d5\u8d77\u52d5(\u4efb\u610f)
\n$chkconfig mysqld on<\/strong><\/span><\/p>\n

\u00a02.Wordpress\u7528\u306eDB\u3092\u4f5c\u6210\u3059\u308b\u3002<\/strong><\/p>\n

$mysql -u root<\/span><\/strong><\/p>\n

\n\n\n\n
\n
\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u78ba\u8a8d\r\nmysql> select user,host,password from mysql.user;<\/span>\r\n+------+---------------+----------+\r\n| user | host\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | password |\r\n+------+---------------+----------+\r\n| root | localhost\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\r\n| root | dti-vps-srv01 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\r\n| root | 127.0.0.1\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\r\n|\u00a0\u00a0\u00a0\u00a0\u00a0 | localhost<\/span>\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u3000\u2190\u3000\u524a\u9664\u3057\u307e\u3059<\/span>\r\n|\u00a0\u00a0\u00a0\u00a0\u00a0 | dti-vps-srv01<\/span> |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u3000\u2190\u3000\u524a\u9664\u3057\u307e\u3059<\/span>\r\n+------+---------------+----------+\r\n5 rows in set (0.00 sec)<\/pre>\n
\u30e6\u30fc\u30b6\u30fc\u540d\u7121\u3057\u3067\u306eDB\u30ed\u30b0\u30a4\u30f3\u30e6\u30fc\u30b6\u30fc\u306e\u524a\u9664\r\nmysql> delete from mysql.user where user = '';<\/span><\/pre>\n
\u30e6\u30fc\u30b6\u30fc\u524a\u9664\u78ba\u8a8d\r\nmysql> select user,host,password from mysql.user;<\/span>\r\n+------+---------------+----------+\r\n| user | host\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | password |\r\n+------+---------------+----------+\r\n| root | localhost\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\r\n| root | dti-vps-srv01 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\r\n| root | 127.0.0.1\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\r\n+------+---------------+----------+\r\n3 rows in set (0.00 sec)<\/pre>\n
root\u30d1\u30b9\u30ef\u30fc\u30c9\u8a2d\u5b9a\r\nmysql>\r\nupdate mysql.user set password=password('<\u4efb\u610f\u30d1\u30b9\u30ef\u30fc\u30c9><\/em>') where user = 'root';<\/span><\/pre>\n
root\u30d1\u30b9\u30ef\u30fc\u30c9\u8a2d\u5b9a\u78ba\u8a8d\r\nmysql> select user,host,password from mysql.user;<\/span>\r\n+------+---------------+-------------------------------------------+\r\n| user | host\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | password\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 |\r\n+------+---------------+-------------------------------------------+\r\n| root | localhost\u00a0\u00a0\u00a0\u00a0 | *0D45CF0E345632748D7F0E92D7B0EA2BE3C4B746 <\/span>|\r\n| root | dti-vps-srv01 | *0D45CF0E345632748D7F0E92D7B0EA2BE3C4B746<\/span> |\r\n| root | 127.0.0.1\u00a0\u00a0\u00a0\u00a0 | *0D45CF0E345632748D7F0E92D7B0EA2BE3C4B746<\/span> |\r\n+------+---------------+-------------------------------------------+\r\n3 rows in set (0.00 sec)\r\n\u203b\uff1a[password]\u4ee5\u4e0b\u306b\u8868\u793a\u304c\u3042\u308b\u3053\u3068\u3092\u78ba\u8a8d<\/strong><\/span><\/pre>\n
mysql> flush privileges;<\/span><\/pre>\n
WordPress \u7528\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\r\nmysql> create database wordpress;<\/span><\/pre>\n
wordpress \u30e6\u30fc\u30b6\u3092\u4f5c\u6210\r\nmysql>\r\ngrant all privileges on wordpress.* to wordpress@localhost identified by '<\u4efb\u610f\u30d1\u30b9\u30ef\u30fc\u30c9><\/em>';<\/span><\/pre>\n
\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\uff06\u30e6\u30fc\u30b6\u30fc\u78ba\u8a8d\r\nmysql> show databases;<\/span>\r\n+--------------------+\r\n| Database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\r\n+--------------------+\r\n| information_schema |\r\n| mysql\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\r\n| test\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\r\n| wordpress\u00a0<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u3000\u2190\u3000\u78ba\u8a8d<\/strong><\/span>\r\n+--------------------+\r\n4 rows in set (0.00 sec)<\/pre>\n
mysql> select user,host,password from mysql.user;<\/span>\r\n+-----------+---------------+-------------------------------------------+\r\n| user\u00a0\u00a0\u00a0\u00a0\u00a0 | host\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | password\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 |\r\n+-----------+---------------+-------------------------------------------+\r\n| root\u00a0\u00a0\u00a0\u00a0\u00a0 | localhost\u00a0\u00a0\u00a0\u00a0 | *36241F994418155CBF9DDAAFB952D8C3C172578D |\r\n| root\u00a0\u00a0\u00a0\u00a0\u00a0 | dti-vps-srv01 | *36241F994418155CBF9DDAAFB952D8C3C172578D |\r\n| root\u00a0\u00a0\u00a0\u00a0\u00a0 | 127.0.0.1\u00a0\u00a0\u00a0\u00a0 | *36241F994418155CBF9DDAAFB952D8C3C172578D |\r\n| wordpress | localhost\u00a0\u00a0\u00a0\u00a0 | *AAA12147F9C259C726B654FA3087821DF03AFBB5 <\/span>|\u3000\u2190\u3000\u78ba\u8a8d\r\n<\/strong><\/span>+-----------+---------------+-------------------------------------------+<\/pre>\n
\u203b\uff1a<\u4efb\u610f\u30d1\u30b9\u30ef\u30fc\u30c9>\u306f\u3053\u306e\u5f8c\u3067\u4f7f\u3046\u306e\u3067\u5fd8\u308c\u306a\u3044\u3088\u3046\u306b\u3059\u308b\u3002<\/em><\/span><\/strong><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/blockquote>\n
\u203b\uff1a\u30ed\u30b0\u30a2\u30a6\u30c8\u3057\u305f\u5834\u5408\u306e\u518d\u30ed\u30b0\u30a4\u30f3\u65b9\u6cd5
\nmysql -u root -p
\nEnter password: \u8a2d\u5b9a\u3057\u305f\u30d1\u30b9\u30ef\u30fc\u30c9(root)<\/em><\/strong><\/span><\/p>\n
\u53c2\u8003\u30b5\u30a4\u30c8<\/span><\/p>\n
ServersMan@VPS PHP5.3.2 + MySQL5.1.45 \u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb – \u3066\u3082\u3050
\n<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
\u00a0\u3044\u304d\u306a\u308aWordpress\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u3044\u3068\u3053\u308d\u306a\u3093\u3067\u3059\u304c\u2026\u3002 \u305f\u3076\u3093\u30d1\u30c3\u30b1\u30fc\u30b8\u304c\u8db3\u308a\u306a\u3044\u306e\u3067\u307e\u305a\u306f\u5fc5\u8981\u30d1\u30c3\u30b1\u30fc\u30b8\u304b\u3089\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002 1.PHP \u3068 MySQL\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb \u30d1\u30c3\u30b1\u30fc\u30b8\u78ba\u8a8d yum info […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,9],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.eldhrimnir.com\/index.php?rest_route=\/wp\/v2\/posts\/346"}],"collection":[{"href":"https:\/\/blog.eldhrimnir.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.eldhrimnir.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.eldhrimnir.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.eldhrimnir.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=346"}],"version-history":[{"count":0,"href":"https:\/\/blog.eldhrimnir.com\/index.php?rest_route=\/wp\/v2\/posts\/346\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.eldhrimnir.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.eldhrimnir.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=346"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.eldhrimnir.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}