{"id":1461,"date":"2022-08-04T23:35:41","date_gmt":"2022-08-04T14:35:41","guid":{"rendered":"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/?p=1461"},"modified":"2022-08-04T23:35:41","modified_gmt":"2022-08-04T14:35:41","slug":"db%e3%81%abmysql%e3%82%92%e4%bd%bf%e3%81%86zabbix%e3%81%ae%e9%80%9a%e7%9f%a5%e3%83%a1%e3%83%bc%e3%83%ab%e3%81%8c%e6%96%87%e5%ad%97%e5%8c%96%e3%81%91%e3%81%97%e3%80%81%e3%81%a8%e3%81%aa%e3%82%8b","status":"publish","type":"post","link":"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/archives\/1461","title":{"rendered":"DB\u306bMySQL\u3092\u4f7f\u3046Zabbix\u306e\u901a\u77e5\u30e1\u30fc\u30eb\u304c\u6587\u5b57\u5316\u3051\u3057\u3001?????\u3068\u306a\u308b\u4e8b\u8c61\u306e\u5bfe\u7b56"},"content":{"rendered":"\n<ul class=\"wp-block-list\"><li>CentOS Stream release 8<\/li><li>Zabbix 5.0.26<\/li><\/ul>\n\n\n\n<p>\u5148\u9803\u3001zabbix-server-mysql\u3068\u305d\u306e\u95a2\u9023\u30d1\u30c3\u30b1\u30fc\u30b8\u3092<code>dnf update<\/code>\u3067\u4ee5\u3063\u30665.0.25\u304b\u30895.0.26\u306b\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u3057\u305f\u3002\u3059\u308b\u3068\u9014\u7aef\u306b\u901a\u77e5\u30e1\u30fc\u30eb\u304c\u6587\u5b57\u5316\u3051\u3057\u59cb\u3081\u3001\u5fa9\u65e7\u4f5c\u696d\u3067\u4f59\u6687\u304c\u6f70\u3048\u308b\u6182\u304d\u76ee\u306b\u906d\u3063\u305f\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-content\/uploads\/2022\/08\/zabbix-mojibake1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-content\/uploads\/2022\/08\/zabbix-mojibake1.png\" alt=\"\" class=\"wp-image-1462\" width=\"423\" height=\"276\" srcset=\"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-content\/uploads\/2022\/08\/zabbix-mojibake1.png 564w, https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-content\/uploads\/2022\/08\/zabbix-mojibake1-300x196.png 300w\" sizes=\"auto, (max-width: 423px) 100vw, 423px\" \/><\/a><figcaption>\u56f31. \u901a\u77e5\u30e1\u30fc\u30eb\u306e\u6587\u5b57\u5316\u3051<\/figcaption><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-content\/uploads\/2022\/08\/zabbix-mojibake2.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-content\/uploads\/2022\/08\/zabbix-mojibake2.png\" alt=\"\" class=\"wp-image-1463\" width=\"418\" height=\"295\" srcset=\"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-content\/uploads\/2022\/08\/zabbix-mojibake2.png 557w, https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-content\/uploads\/2022\/08\/zabbix-mojibake2-300x212.png 300w\" sizes=\"auto, (max-width: 418px) 100vw, 418px\" \/><\/a><figcaption>\u56f32. \u6587\u5b57\u5316\u3051\u3057\u3066\u3044\u306a\u3044\u9803\u306e\u30e1\u30fc\u30eb<\/figcaption><\/figure>\n<\/div>\n\n\n<p>\u8abf\u3079\u59cb\u3081\u3066\u3059\u3050\u3001<a href=\"https:\/\/enterprise.zabbix.co.jp\/knowledgebase\/7726\">\u516c\u5f0f\u30b5\u30a4\u30c8\u306e\u30ca\u30ec\u30c3\u30b8<\/a>\u306b\u8fbf\u308a\u7740\u3044\u305f\u3002\u3068\u3053\u308d\u304c\u30b7\u30eb\u30d0\u30fc\u3068\u3044\u3046\u30b0\u30ec\u30fc\u30c9\u4ee5\u4e0a\u306e\u30b5\u30dd\u30fc\u30c8\u5951\u7d04\u3092\u7d50\u3093\u3067\u3044\u306a\u3044\u3068\u95b2\u89a7\u3067\u304d\u306a\u3044\u30b3\u30f3\u30c6\u30f3\u30c4\u3067\u3042\u308b\u3068\u3044\u3046\u3002\u5e74\u959330\u4e07\u5186\u3068\u304b40\u4e07\u5186\u3068\u3044\u3046\u4fa1\u683c\u304c\u76ee\u306b\u98db\u3073\u8fbc\u3093\u3067\u304d\u3066\u5ffd\u3061\u5fc3\u6301\u3061\u304c\u6c88\u3093\u3060\u3002<\/p>\n\n\n\n<p>\u539f\u56e0\u306f\u3068\u3093\u3068\u898b\u5f53\u304c\u3064\u304b\u306c\u3051\u308c\u3069\u3082\u3001<a href=\"https:\/\/www.zabbix.com\/jp\/rn\/rn5.0.26\">\u30ea\u30ea\u30fc\u30b9\u30ce\u30fc\u30c8<\/a>\u3092\u78ba\u8a8d\u3057\u3066\u307f\u308b\u3068<a href=\"https:\/\/support.zabbix.com\/browse\/ZBX-21301\">ZBX-21301<\/a>\u3042\u305f\u308a\u304c\u5f15\u304d\u91d1\u3068\u306a\u3063\u3066\u3044\u305d\u3046\u306a\u60c5\u52e2\u3067\u3042\u308b\u3002\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u30fb\u30b5\u30fc\u30d0\u9593\u3067\u4f59\u8a08\u306a\u6587\u5b57\u30b3\u30fc\u30c9\u5909\u63db\u304c\u767a\u751f\u3057\u3066\u3044\u308b\u306e\u304b\u3068\u601d\u3063\u3066\u3001mysql-server.cnf\u306e[mysqld]\u30bb\u30af\u30b7\u30e7\u30f3\u306b<code>skip-character-set-client-handshake<\/code>\u3092\u8ffd\u8a18\u3057\u3001MySQL\u3092\u518d\u8d77\u52d5\u3057\u305f\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo vi \/etc\/my.cnf.d\/mysql-server.cnf<br>[mysqld]<br><strong class=\"orange\">skip-character-set-client-handshake<\/strong><\/pre>\n\n\n\n<p>\u3053\u308c\u3067\u7121\u4e8b\u5fa9\u65e7\u3057\u305f\u3088\u3046\u306b\u6620\u3063\u305f\u306e\u3082\u675f\u306e\u9593\u3001\u30c8\u30ea\u30ac\u30fc\u540d\u3060\u3051\u304c\u5f15\u304d\u7d9a\u304d\u6587\u5b57\u5316\u3051\u3057\u3066\u304a\u308a\u307e\u3053\u3068\u306b\u5f31\u3063\u305f\u3002\u3053\u3063\u3061\u3053\u305d?????\u3068\u3044\u3046\u6c17\u6301\u3061\u3067\u3042\u308b\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-content\/uploads\/2022\/08\/zabbix-mojibake3.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-content\/uploads\/2022\/08\/zabbix-mojibake3.png\" alt=\"\" class=\"wp-image-1464\" width=\"425\" height=\"292\" srcset=\"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-content\/uploads\/2022\/08\/zabbix-mojibake3.png 567w, https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-content\/uploads\/2022\/08\/zabbix-mojibake3-300x206.png 300w\" sizes=\"auto, (max-width: 425px) 100vw, 425px\" \/><\/a><figcaption>\u56f33. \u30c8\u30ea\u30ac\u30fc\u540d\u3060\u3051\u6587\u5b57\u5316\u3051\u3057\u3066\u3044\u308b\u69d8\u5b50<\/figcaption><\/figure>\n<\/div>\n\n\n<p>\u305d\u3053\u3067Zabbix Server\u3082\u4f75\u305b\u3066\u518d\u8d77\u52d5\u3057\u3066\u307f\u308b\u3068\u4eca\u5ea6\u3053\u305d\u89e3\u6c7a\u3092\u898b\u305f\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo systemctl restart mysqld.service\n$ sudo systemctl restart zabbix-server.service<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>CentOS Stream release 8 Zabbix 5.0.26 \u5148\u9803\u3001zabbix-server-mysql\u3068\u305d\u306e\u95a2\u9023\u30d1\u30c3\u30b1\u30fc\u30b8\u3092dnf update\u3067\u4ee5\u3063\u30665.0.25\u304b\u30895.0.26\u306b\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u3057\u305f\u3002\u3059\u308b\u3068\u9014\u7aef\u306b\u901a\u77e5\u30e1\u30fc\u30eb\u304c\u6587\u5b57\u5316\u3051\u3057\u59cb\u3081\u3001\u5fa9\u65e7\u4f5c\u696d\u3067\u4f59\u6687\u304c\u6f70\u3048\u308b\u6182\u304d\u76ee\u306b\u906d\u3063\u305f\u3002 \u8abf\u3079\u59cb\u3081\u3066\u3059\u3050\u3001\u516c\u5f0f\u30b5\u30a4\u30c8\u306e\u30ca\u30ec\u30c3\u30b8\u306b\u8fbf\u308a\u7740\u3044\u305f\u3002\u3068\u3053\u308d\u304c\u30b7\u30eb\u30d0\u30fc\u3068\u3044\u3046\u30b0\u30ec\u30fc\u30c9\u4ee5\u4e0a\u306e\u30b5\u30dd\u30fc\u30c8\u5951\u7d04\u3092\u7d50 &#8230; <a title=\"DB\u306bMySQL\u3092\u4f7f\u3046Zabbix\u306e\u901a\u77e5\u30e1\u30fc\u30eb\u304c\u6587\u5b57\u5316\u3051\u3057\u3001?????\u3068\u306a\u308b\u4e8b\u8c61\u306e\u5bfe\u7b56\" class=\"read-more\" href=\"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/archives\/1461\" aria-label=\"DB\u306bMySQL\u3092\u4f7f\u3046Zabbix\u306e\u901a\u77e5\u30e1\u30fc\u30eb\u304c\u6587\u5b57\u5316\u3051\u3057\u3001?????\u3068\u306a\u308b\u4e8b\u8c61\u306e\u5bfe\u7b56 \u306b\u3064\u3044\u3066\u3055\u3089\u306b\u8aad\u3080\">\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":1237,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[157],"tags":[164,204,262],"class_list":["post-1461","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux","tag-mysql","tag-zabbix","tag-262"],"views":922,"_links":{"self":[{"href":"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-json\/wp\/v2\/posts\/1461","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-json\/wp\/v2\/comments?post=1461"}],"version-history":[{"count":0,"href":"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-json\/wp\/v2\/posts\/1461\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-json\/wp\/v2\/media\/1237"}],"wp:attachment":[{"href":"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-json\/wp\/v2\/media?parent=1461"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-json\/wp\/v2\/categories?post=1461"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-json\/wp\/v2\/tags?post=1461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}