Warning: Error while sending QUERY packet. PID=10586 in /home/uls/public_html/wordpress/wp-includes/class-wpdb.php on line 2357 {"id":89,"date":"2010-10-17T06:31:24","date_gmt":"2010-10-17T06:31:24","guid":{"rendered":"http:\/\/192.168.1.20\/wordpress\/freebsd\/2010\/10\/17\/mysql_556\/"},"modified":"2010-10-17T06:31:24","modified_gmt":"2010-10-17T06:31:24","slug":"mysql_556","status":"publish","type":"post","link":"http:\/\/uls.self.jp\/wordpress\/freebsd\/?p=89","title":{"rendered":"MySQL \u30d0\u30fc\u30b8\u30e7\u30f35.5.6"},"content":{"rendered":"

*** 2010\/12\/16\u306b\u5185\u5bb9\u4e00\u90e8\u4fee\u6b63\u3057\u307e\u3057\u305f ***
\n\u5bb6\u306e\u30b5\u30fc\u30d0\u30fc\u306fFreeBSD-7.0\u3067\u904b\u7528\u3057\u3066\u3044\u308b\u304c\u3001\u305d\u308d\u305d\u308d\u6700\u65b0\u306eFreeBSD-8.1\u306b\u4e0a\u3052\u3088\u3046\u3068\u6e96\u5099\u4e2d\u3067\u3059\u3002
\nOS\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u5f8c\u306bMySQL\u3092ports\u3067\u5165\u308c\u3066\u3001\u6587\u5b57\u30b3\u30fc\u30c9\u306e\u8a2d\u5b9a\u3067\u5f15\u3063\u304b\u304b\u3063\u305f\u3002
\n(1) \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/p>\n

# cd \/usr\/ports\/databases\/mysql55-server\n# make WITH_CHARSET=ujis WITH_XCHARSET=all install clean\n# cd ..\/mysql55-client\n# make WITH_CHARSET=ujis WITH_XCHARSET=all install clean<\/pre>\n(2) my.cnf\u306e\u7de8\u96c6<\/p>\n
# 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]\ndatadir = \/usr\/db\/mysql<\/font>\nport            = 3306\nsocket          = \/tmp\/mysql.sock\nskip-locking\nkey_buffer = 16M<\/pre>\n(3) DB\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/p>\n
# mkdir \/usr\/db\n# mysql_install_db --basedir=\/usr\/local --datadir=\/usr\/db\/mysql\n# chown -R mysql \/usr\/db\/mysql<\/pre>\n(4) \u8d77\u52d5<\/p>\n
\u6b21\u306bmysql\u306e\u8d77\u52d5\u30d5\u30a1\u30a4\u30eb\u3092\u4fee\u6b63\u3057\u307e\u3059\u3002<\/p><\/blockquote>\n
# cd \/usr\/local\/etc\/rc.d\n# chmod +w mysql-server\n# vi mysql-server<\/pre>\n\u4e0b\u8a18\u306e\u8d64\u5b57\u90e8\u5206\u3092\u4fee\u6b63\u3059\u308b\u3002
\nmysql_dbdir\u306e\u8a18\u8ff0\u3092\u6709\u52b9\u306b\u3057\u3066\/usr\/db\/mysql\u3092\u6307\u5b9a\u3057\u3001
\n–defaults-extra-file=\/etc\/my.cnf\u3000\u3068\u3057\u3066\u3001\/etc\/my.cnf\u3092\u660e\u306b\u6307\u5b9a\u3059\u308b\u3002<\/p><\/blockquote>\n
\n: ${mysql_enable=\"NO\"}\n: ${mysql_limits=\"NO\"}\n${mysql_dbdir=\"\/usr\/db\/mysql\"}<\/font>\n: ${mysql_args=\"\"}\nmysql_user=\"mysql\"\nmysql_limits_args=\"-e -U ${mysql_user}\"\npidfile=\"${mysql_dbdir}\/`\/bin\/hostname`.pid\"\ncommand=\"\/usr\/sbin\/daemon\"\ncommand_args=\"-c -f \/usr\/local\/bin\/mysqld_safe --defaults-extra-file=\/etc\/my.cnf <\/font>--user=${mysql_user} --datadir=${mysql_dbdir} --pid-file=${pidfile} ${mysql_args}\"<\/pre>\n\u3053\u308c\u3067\u3001\u3088\u3046\u3084\u304fMySQL\u3092\u8d77\u52d5\u3067\u304d\u308b\u3002<\/p><\/blockquote>\n
# .\/mysql-server start<\/pre>\n(5) \u30d1\u30b9\u30ef\u30fc\u30c9\u8a2d\u5b9a<\/p>\n
# mysql -u root\nmysql > use mysql;\nmysql > set password for root@localhost=password('xxxxx');\nmysql> flush privileges;\nmysql > exit;<\/pre>\n(6) \u6587\u5b57\u30b3\u30fc\u30c9\u8abf\u3079<\/p>\n
# mysql -u root -p\nPassword xxxxxxx\nmysql > SHOW VARIABLES LIKE 'character_set_%';\n+-----------------------------------+--------+\n| Variable_name                             | Value   |\n+-----------------------------------+--------+\n| character_set_client     \u3000\u3000\u3000      | latin1 |\n| character_set_connection\u3000\u3000\u3000  | latin1 |\n| character_set_filesystem              | binary |\n| character_set_database               | latin1 |\n| character_set_results                    | latin1 |\n| character_set_server    \u3000\u3000\u3000\u3000\u3000 | latin1 |\n| character_set_system     \u3000\u3000\u3000\u3000  | utf8   |\n+------------------------------------+--------+\n6 rows in set (0.00 sec)<\/pre>\n\u5165\u308c\u305f\u307e\u307e\u3060\u3068\u3001latin1\u306e\u6587\u5b57\u30b3\u30fc\u30c9\u306b\u306a\u3063\u3066\u3044\u308b\u3002<\/p><\/blockquote>\n
(7) \u6587\u5b57\u30b3\u30fc\u30c9\u6307\u5b9a<\/p>\n
MySQL\u3092\u30b9\u30c8\u30c3\u30d7\u3057\u3066\u3001\/etc\/my.cnf\u306e[mysqld]\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u306bdefault-character-set=ujis\u3092\u8ffd\u52a0\u3057\u305f\u3089\u3001\u30a8\u30e9\u30fc\u304c\u51fa\u3066\u8d77\u52d5\u3067\u304d\u306a\u304f\u306a\u3063\u305f<\/font>\u3002
\n\u8abf\u3079\u305f\u3089default-character-set=ujis\u306f\u5909\u66f4\u3055\u308c\u4f7f\u3048\u306a\u304f\u306a\u3063\u305f\u3053\u3068\u304c\u5206\u304b\u308a\u3001\u4e0b\u8a18\u306e\u3088\u3046\u306b2\u884c\u8ffd\u52a0\u3057\u305f\u3002<\/p><\/blockquote>\n
[mysqld]\ndatadir = \/usr\/db\/mysql\nport            = 3306\nsocket          = \/tmp\/mysql.sock\nskip-external-locking\n\u3000\u3000\u3000\u3000\u30fb\n\u3000\u3000\u3000\u3000\u30fb\nmyisam_sort_buffer_size = 8M\ncharacter-set-server=ujis\nskip-character-set-client-handshake<\/font><\/pre>\n(8) \u518d\u78ba\u8a8d<\/p>\n
mysql> SHOW VARIABLES LIKE 'character_set_%';\n+----------------------------------+--------+\n| Variable_name            \u3000\u3000\u3000\u3000\u3000| Value   |\n+----------------------------------+--------+\n| character_set_client    \u3000\u3000\u3000\u3000\u3000 | ujis |\n| character_set_connection            | ujis |\n| character_set_database  \u3000\u3000\u3000\u3000| ujis |\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\u3000 | utf8   |\n+----------------------------------+--------+<\/pre>\nsystem\u306f\u30c7\u30d5\u30a9\u30eb\u30c8\u3067utf8\u3001filesystem\u306fbinary\u3067\u554f\u984c\u306a\u3044\u306e\u3067\u3001\u7121\u4e8bujsi(EUC)\u304c\u4f7f\u3048\u308b\u3088\u3046\u306b\u306a\u3063\u305f\u3002\u3000\u3084\u308c\u3084\u308c\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
*** 2010\/12\/16\u306b\u5185\u5bb9\u4e00\u90e8\u4fee\u6b63\u3057\u307e\u3057\u305f *** \u5bb6\u306e\u30b5\u30fc\u30d0\u30fc\u306fFreeBSD-7.0\u3067\u904b\u7528\u3057\u3066\u3044\u308b\u304c\u3001\u305d\u308d\u305d\u308d\u6700\u65b0\u306eFreeBSD-8.1\u306b\u4e0a\u3052\u3088\u3046\u3068\u6e96\u5099\u4e2d\u3067\u3059\u3002 OS\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u5f8c\u306bMySQL\u3092ports … 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":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-89","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\/89","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=89"}],"version-history":[{"count":0,"href":"http:\/\/uls.self.jp\/wordpress\/freebsd\/index.php?rest_route=\/wp\/v2\/posts\/89\/revisions"}],"wp:attachment":[{"href":"http:\/\/uls.self.jp\/wordpress\/freebsd\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=89"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/uls.self.jp\/wordpress\/freebsd\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=89"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/uls.self.jp\/wordpress\/freebsd\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=89"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}