Warning: Error while sending QUERY packet. PID=27318 in /home/uls/public_html/wordpress/wp-includes/class-wpdb.php on line 2357
{"id":71,"date":"2006-12-10T17:05:40","date_gmt":"2006-12-10T17:05:40","guid":{"rendered":"http:\/\/192.168.1.20\/wordpress\/freebsd\/2006\/12\/10\/mysql-5027obsolete\/"},"modified":"2015-01-15T10:59:09","modified_gmt":"2015-01-15T10:59:09","slug":"mysql-5027obsolete","status":"publish","type":"post","link":"http:\/\/uls.self.jp\/wordpress\/freebsd\/?p=71","title":{"rendered":"mysql-5.0.27\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb(obsolete)"},"content":{"rendered":"<p><font color=\"#ff0000\">(obsolete)<\/font> <a href=\"http:\/\/uls.self.jp\/wordpress\/freebsd\/2006\/12\/10\/mysql-5027obsolete\/\"> MySQL \u30d0\u30fc\u30b8\u30e7\u30f35.5.6<\/a> \u3092\u5fa1\u89a7\u304f\u3060\u3055\u3044<br \/>\n11\u6708\u306e\u4e2d\u65ec\u306bmysql\u3068php\u3092\u7528\u3044\u305f\u983c\u307e\u308c\u3082\u306e\u306e\u30a2\u30d7\u30ea\u3092\u66f8\u3044\u3066\u3044\u308b\u3068\u304d\u306b\u3001\u3046\u3063\u304b\u308amysql\u3092\u58ca\u3057\u3066\u3057\u307e\u3063\u305f\u3002<br \/>\n\u6700\u521d\u306f\u7c21\u5358\u306b\u5fa9\u5e30\u3067\u3044\u308b\u3060\u308d\u3046\u3068\u601d\u3063\u3066\u3044\u305f\u304c\u3001\u65e5\u672c\u8a9e\u51e6\u7406\u3067\u30c8\u30e9\u30d6\u30eb\u304c\u3067\u3066\u3001\u5927\u5909\u306a\u76ee\u306b\u4f1a\u3063\u3066\u3057\u307e\u3063\u305f\u3002<br \/>\n\u89e3\u3063\u3066\u3057\u307e\u3048\u3070\u7c21\u5358\u306a\u3053\u3068\u3067\u3042\u3063\u305f\u306e\u3060\u304c\u3001\u6642\u9593\u306b\u8ffd\u308f\u308c\u308b\u4e2d\u3067\u6df7\u4e71\u3092\u6765\u305f\u3057\u3001\u79c1\u306e\u3068\u3053\u308d\u306e\u30b5\u30fc\u30d0\u3067\u30d6\u30ed\u30b0\u3092\u958b\u8a2d\u3057\u3066\u3044\u308b\uff15\u4eba\u307b\u3069\u306e\u4eba\u306b\u3082\u5927\u5909\u306a\u8ff7\u60d1\u3092\u304b\u3051\u3066\u3057\u307e\u3063\u305f\u3002<br \/>\n\u524d\u7f6e\u304d\u306f\u3053\u308c\u3050\u3089\u3044\u3067\u3001\u672c\u7b4b\u306b\u623b\u308b\u304c\u3001\u3069\u3046\u305b\u58ca\u308c\u305f\u306e\u3060\u304b\u3089mysql-4.1\u3092mysql-5.0.27\u306b\u4e0a\u3052\u3088\u3046\u3068\u3001\/ports\/databases\/mysql50-server\u3068mysql50-client\u3092\u5165\u308c\u3088\u3046\u3068\u3057\u305f\u3002<br \/>\n\u8abf\u3079\u308b\u3068EUC\u3092\u4f7f\u3046\u306b\u306f\u30b3\u30f3\u30d1\u30a4\u30eb\u30aa\u30d7\u30b7\u30e7\u30f3\u3067\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3001\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u6587\u5b57\u30b3\u30fc\u30c9\u306eujis(EUC)\u3068\u305d\u306e\u4ed6\u306e\u6587\u5b57\u3092\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u6307\u5b9a\u3059\u308c\u3070\u826f\u3044\u3053\u3068\u304c\u5206\u304b\u3063\u305f\u3002<\/p>\n<pre># make WITH_CHARSET=ujis WITH_XCHARSET=all install clean<\/pre>\n<p>\u6b21\u306b\/etc\u306bmy.cnf\u3092\u4f5c\u3063\u3066\u3001\u4fee\u6b63<\/p>\n<pre># cp \/usr\/local\/share\/mysql\/my-medium.cnf \/etc\/my.cnf\n# cd \/etc\n# chmod +w my.cnf\n# vi my.cnf\n[mysqld]\n<font color=\"#ff0000\">datadir = \/usr\/db\/mysql<\/font>\nport            = 3306\nsocket          = \/tmp\/mysql.sock\nskip-locking\nkey_buffer = 16M\nmax_allowed_packet = 1M\ntable_cache = 64\nsort_buffer_size = 512K\nnet_buffer_length = 8K\nread_buffer_size = 256K\nread_rnd_buffer_size = 512K\nmyisam_sort_buffer_size = 8M<\/pre>\n<p>mysql\u3092user\u3068group\u306b\u8ffd\u52a0<\/p>\n<p>\uff03vipw\u3057\u3066\u6b21\u306e\uff11\u884c\u3092\u8ffd\u52a0<\/p>\n<pre>mysql:*:88:88::0:0:MySQL Daemon:\/nonexistent:\/sbin\/nologin<\/pre>\n<p>\u6b21\u306b\/etc\/group\u306bmysql\u3092\u8ffd\u52a0<\/p>\n<p>\uff03 vi \/etc\/group \u3057\u3066\u6b21\u306e1\u884c\u3092\u8ffd\u52a0<\/p>\n<pre>mysql:*:88:<\/pre>\n<p>\u305d\u3057\u3066\u3001DB\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u8d77\u52d5<\/p>\n<pre># mkdir \/usr\/db\n# mysql_install_db\n# chown -R mysql \/usr\/db\/mysql\n# cd \/usr\/local\/etc\/rc.d\n# cp \/usr\/local\/share\/mysql\/mysql.server .\/mysql-server.sh\n# .\/mysql-server.sh start<\/pre>\n<p>\u7121\u4e8b\u8d77\u52d5\u3057\u305f\u3089\u3001mysql-client\u304b\u3089\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a<\/p>\n<pre># mysql -u root\nmysql &gt; use mysql;\nmysql &gt; set password for root@localhost=password('xxxxx');\nmysql&gt; flush privileges;\nmysql &gt; exit;<\/pre>\n<p>\u30d1\u30b9\u30ef\u30fc\u30c9\u306e\u8a2d\u5b9a\u306f\u4ee5\u524d\u306f\u3000set password for root=password(&#8216;xxxxx&#8217;);\u3000\u3067\u826f\u304b\u3063\u305f\u304c\u3001\u4eca\u56de\u306f<br \/>\nroot@localhost=password(&#8216;xxxxx&#8217;);\u3000\u3068<br \/>\n@localhost\u304c\u5fc5\u8981\u3067\u3042\u3063\u305f\u3002<br \/>\n\u6700\u521d\u306e\u8d77\u52d5\u3067root\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u306e\u8a2d\u5b9a\u3092\u884c\u308f\u305a\u306b\u629c\u3051\u308b\u3068\u3001\u5f8c\u304b\u3089login\u3067\u304d\u305a\u9177\u3044\u76ee\u306b\u4f1a\u3046\u3002<br \/>\n\u7b46\u8005\u3082\u3001\u3046\u3063\u304b\u308a\u3084\u3063\u3066\u3057\u307e\u3063\u3066\u3001\u5927\u5909\u306a\u601d\u3044\u3092\u3057\u305f\u3002<br \/>\n\u4e00\u5fdclogin\u304c\u51fa\u6765\u306a\u304f\u306a\u3063\u305f\u5834\u5408\u306e\u5bfe\u51e6\u65b9\u6cd5\u3092\u4e0b\u8a18\u306b\u66f8\u3044\u3066\u304a\u304f\u3002<\/p>\n<pre># mysqld_safe --skip-grant-tables &amp;\n# mysql -u root mysql\nmysql &gt; UPDATE user SET Password=PASSWORD('mynewpassword')\n\u3000\u3000\u3000\u3000  -&gt; WHERE User='root';\nmysql &gt; flush privileges;<\/pre>\n<p>\u3053\u306e\u5f8c\u3001mysql;\u3092\u505c\u6b62(kill)\u3057\u3066\u3001\u6b63\u898f\u306b\u7acb\u3061\u4e0a\u3052\u308b\u3002<br \/>\n\u3055\u3066\u3001\u7121\u4e8b\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u5ff5\u306e\u305f\u3081\u306b\u6587\u5b57\u30b3\u30fc\u30c9\u3092\u8abf\u3079\u305f\u3089\u3001<\/p>\n<pre># mysql -u root -p\nPassword xxxxxxx\nmysql &gt; SHOW VARIABLES LIKE 'character_set_%';\n+----------------------------------+-------+\n| Variable_name           \u3000\u3000\u3000\u3000\u3000 | Value  |\n+----------------------------------+--------+\n| character_set_client     \u3000\u3000\u3000\u3000 | latin1 |\n| character_set_connection\u3000\u3000\u3000 | latin1 |\n| character_set_filesystem             | binary |\n| character_set_database  \u3000\u3000 \u3000 | latin1 |\n| character_set_results    \u3000\u3000    \u3000| latin1 |\n| character_set_server    \u3000\u3000\u3000\u3000 | latin1 |\n| character_set_system     \u3000\u3000\u3000\u3000| utf8   |\n+----------------------------------+--------+\n6 rows in set (0.00 sec)<\/pre>\n<p>ujis(EUC)\u306b\u306a\u3063\u3066\u3044\u306a\u3044\u306e\u3067\u3001\/etc\/my.cnf\u3067\u6307\u5b9a\u3059\u308b\u306e\u3060\u308d\u3046\u3068\u601d\u3063\u3066\u3001[mysqld]\u306e\u4e2d\u3067\u3001[mysqld]\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u306b\u3001<\/p>\n<pre>default-character-set=ujis<\/pre>\n<p>\u3092\u5165\u308c\u3066\u3001\u8d77\u52d5\u3057\u3088\u3046\u3068\u3059\u308b\u3068\u3001ujis\u306a\u3093\u3066\u7121\u3044\u3088\u3068\u6012\u3089\u308c\u308b\u3002<br \/>\n\u3060\u3063\u3066\u3001WITH_CHARSET=ujis\u3092\u5165\u308c\u305f\u3058\u3083\u306a\u3044\u304b\u3068\u53eb\u3093\u3067\u3082\u3001\u3069\u3046\u306b\u3082\u306a\u3089\u306a\u3044\u3002<br \/>\n\u7d50\u5c40\u3001http:\/\/www.mysql.com \u304b\u3089\u30bd\u30fc\u30b9\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u81ea\u524d\u3067\u30b3\u30f3\u30d1\u30a4\u30eb\u3057\u3066\u5165\u308c\u308b\u3053\u3068\u306b\u3057\u305f\u3002<br \/>\n\u30b5\u30a4\u30c8\u306e\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u30da\u30fc\u30b8\u306b\u306f\u3001Windows\u3084Linux\u306ePrecompiled Binary\u306e\u30d5\u30a1\u30a4\u30eb\u304c\u305a\u3089\u3063\u3068\u4e26\u3093\u3067\u3044\u308b\u304c\u3001\u4e00\u756a\u4e0b\u306b\u3001Tarball (in 5.1 both Unix &amp; Windows, tar.gz)\u304c\u3042\u3063\u305f\u306e\u3067\u3001\u3053\u308c\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u3002<br \/>\n\u305d\u3057\u3066\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3057\u3066\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3001<\/p>\n<pre># tar xvzf mysql-5.0.27.tar.gz\n# cd mysql-5.0.27\n# .\/configure --prefix=\/usr\/local --with-charset=ujis \n--with-extra-charset=all --with-mysqld-user=mysql<\/pre>\n<p>\u7121\u4e8bconfigure\u304c\u7d42\u308f\u308a\u3001\u3044\u3088\u3044\u3088\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/p>\n<pre># make install<\/pre>\n<p>client\u306f\u554f\u984c\u306a\u3055\u305d\u3046\u306a\u306e\u3067\u3001\u65e9\u901f\u8d77\u52d5\u3057\u3066\u6587\u5b57\u30b3\u30fc\u30c9\u3092\u8abf\u3079\u3066\u307f\u308b\u3002<\/p>\n<pre>mysql&gt; SHOW VARIABLES LIKE 'character_set_%';\n+----------------------------------+--------+\n| Variable_name            \u3000\u3000\u3000\u3000\u3000| Value  |\n+----------------------------------+--------+\n| character_set_client                   | ujis       |\n| character_set_connection          | ujis       |\n| character_set_database  \u3000\u3000    | ujis       |\n| character_set_filesystem            | binary  |\n| character_set_results                 | ujis       |\n| character_set_server                 | ujis       |\n| character_set_system     \u3000\u3000 \u3000| utf8      |\n+----------------------------------+--------+<\/pre>\n<p>system\u306f\u30c7\u30d5\u30a9\u30eb\u30c8\u3067utf8\u3001filesystem\u306fbinary\u3067\u554f\u984c\u306a\u3044\u3068\u306e\u3053\u3068\u306a\u306e\u3067\u3001\u7121\u4e8bujsi(EUC)\u304c\u4f7f\u3048\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u308b\u3002<br \/>\n\u65e9\u901f\u30d6\u30ed\u30b0\u7528\u306emtdb\u3092\u4f5c\u3063\u3066(<a href=\"http:\/\/uls.self.jp\/wordpress\/freebsd\/2006\/01\/03\/mysqlpackage\/\">mysql\u306e\u5c0e\u5165<\/a>\u53c2\u7167)\u3001\u5ff5\u306e\u305f\u3081\u306b\u518d\u7acb\u3061\u4e0a\u3052\u3057\u3066\u6587\u5b57\u30b3\u30fc\u30c9\u3092\u8abf\u3079\u308b\u3002<\/p>\n<pre>mysql &gt; use mtdb;\nmysql&gt; SHOW VARIABLES LIKE 'character_set_%';\n+------------------------------------+---------+\n| Variable_name            \u3000\u3000\u3000\u3000\u3000\u3000| Value   |\n+-------------------------------------+--------+\n| character_set_client     \u3000\u3000\u3000\u3000\u3000  | ujis       |\n| character_set_connection \u3000\u3000\u3000   | ujis       |\n| character_set_database  \u3000\u3000\u3000     | latin1   |\n| character_set_filesystem                | binary  |\n| character_set_results   \u3000\u3000\u3000\u3000     | ujis       |\n| character_set_server    \u3000\u3000\u3000\u3000     | ujis      |\n| character_set_system    \u3000\u3000\u3000       | utf8     |\n+-------------------------------------+-------+<\/pre>\n<p>database\u304clatin1(\u3046\u308d\u899a\u3048\u306a\u306e\u3067binary\u3060\u3063\u305f\u304b\u3082\u77e5\u308c\u306a\u3044)\u306b\u306a\u3063\u3066\u3044\u308b\u3002<br \/>\n\u3069\u3046\u3082\u3001\u4ee5\u524d\u306e\u53e4\u3044\u30c7\u30fc\u30bf\u3092\u53c2\u7167\u3057\u3066\u3044\u308b\u3088\u3046\u306a\u306e\u3067\u3001\u4e00\u5ea6 mtdb\u3092\u7834\u68c4\u3057\u3066\u3001\u6539\u3081\u3066\u4f5c\u6210\u3059\u308b\u3002<br \/>\n\u305d\u3057\u3066\u3001\u6587\u5b57\u30b3\u30fc\u30c9\u3092\u8abf\u3079\u308b\u3002<\/p>\n<pre>mysql&gt; SHOW VARIABLES LIKE 'character_set_%';\n+------------------------------+--------+\n| Variable_name                     | Value   |\n+------------------------------+--------+\n| character_set_client             | ujis       |\n| character_set_connection    | ujis       |\n| character_set_database       | ujis       |\n| character_set_filesystem      | binary   |\n| character_set_results           | ujis        |\n| character_set_server            | ujis       |\n| character_set_system           | utf8      |\n+------------------------------+--------+<\/pre>\n<p>\u3081\u3067\u305f\u3057\u3001\u3081\u3067\u305f\u3057system\u3068filesystem\u3092\u9664\u304d\u3001\u5168\u3066ujsi\u306b\u306a\u3063\u3066\u3044\u308b\u3002<br \/>\n\u3057\u304b\u3057\u3001\u30d6\u30ed\u30b0\u306e\u30c7\u30fc\u30bf\u3092\u98db\u3070\u3057\u305f\u306e\u306f\u7533\u3057\u8a33\u306a\u3044\u3053\u3068\u3092\u3057\u305f\u30fb\u30fb\u30fb<\/p>\n","protected":false},"excerpt":{"rendered":"<p>(obsolete) MySQL \u30d0\u30fc\u30b8\u30e7\u30f35.5.6 \u3092\u5fa1\u89a7\u304f\u3060\u3055\u3044 11\u6708\u306e\u4e2d\u65ec\u306bmysql\u3068php\u3092\u7528\u3044\u305f\u983c\u307e\u308c\u3082\u306e\u306e\u30a2\u30d7\u30ea\u3092\u66f8\u3044\u3066\u3044\u308b\u3068\u304d\u306b\u3001\u3046\u3063\u304b\u308amysql\u3092\u58ca\u3057\u3066\u3057\u307e\u3063\u305f\u3002 \u6700\u521d\u306f\u7c21\u5358\u306b\u5fa9\u5e30\u3067\u3044\u308b\u3060\u308d\u3046\u3068\u601d &hellip; <a href=\"http:\/\/uls.self.jp\/wordpress\/freebsd\/?p=71\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-71","post","type-post","status-publish","format-standard","hentry","category-database","wpautop"],"_links":{"self":[{"href":"http:\/\/uls.self.jp\/wordpress\/freebsd\/index.php?rest_route=\/wp\/v2\/posts\/71","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/uls.self.jp\/wordpress\/freebsd\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/uls.self.jp\/wordpress\/freebsd\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/uls.self.jp\/wordpress\/freebsd\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/uls.self.jp\/wordpress\/freebsd\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=71"}],"version-history":[{"count":4,"href":"http:\/\/uls.self.jp\/wordpress\/freebsd\/index.php?rest_route=\/wp\/v2\/posts\/71\/revisions"}],"predecessor-version":[{"id":197,"href":"http:\/\/uls.self.jp\/wordpress\/freebsd\/index.php?rest_route=\/wp\/v2\/posts\/71\/revisions\/197"}],"wp:attachment":[{"href":"http:\/\/uls.self.jp\/wordpress\/freebsd\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=71"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/uls.self.jp\/wordpress\/freebsd\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=71"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/uls.self.jp\/wordpress\/freebsd\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=71"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}