{"id":248,"date":"2023-11-01T00:00:33","date_gmt":"2023-10-31T15:00:33","guid":{"rendered":"https:\/\/web.cloudfree.jp\/journal\/?p=248"},"modified":"2023-11-03T16:06:51","modified_gmt":"2023-11-03T07:06:51","slug":"mysql%e3%81%a8mariadb%e3%82%92%e5%85%b1%e5%ad%98%e3%81%a7%e5%8b%95%e3%81%8b%e3%81%99","status":"publish","type":"post","link":"https:\/\/web.cloudfree.jp\/journal\/mysql%e3%81%a8mariadb%e3%82%92%e5%85%b1%e5%ad%98%e3%81%a7%e5%8b%95%e3%81%8b%e3%81%99\/","title":{"rendered":"MySQL\u3068MariaDB\u3092\u5171\u5b58\u3067\u52d5\u304b\u3059"},"content":{"rendered":"<h3 style=\"padding-top:var(--wp--preset--spacing--20);padding-bottom:var(--wp--preset--spacing--20);\" class=\"wp-block-post-title\">MySQL\u3068MariaDB\u3092\u5171\u5b58\u3067\u52d5\u304b\u3059<\/h3>\r\n\n<p class=\"has-tertiary-color has-text-color has-background has-small-font-size\" style=\"background-color:#8d8dd8;margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;padding-top:0;padding-right:0;padding-bottom:0;padding-left:0\">2023-11-01 \u8a18\u8f09<br>\u6982\u8981\uff1aWin10\u3067MySQL\u3092Port3306\u3001MariaDB\u3092Port6603\u306b\u3057\u3066\u3001\u30c0\u30d6\u30ebDB\u30b5\u30fc\u30d0\u30fc\u3078<br>\u95a2\u9023\u8a18\u4e8b\uff1a<a href=\"https:\/\/web.cloudfree.jp\/journal\/phpmyadmin%e3%82%92%e3%82%bb%e3%83%83%e3%83%88%e3%82%a2%e3%83%83%e3%83%97\/\" data-type=\"post\" data-id=\"572\">\u30ed\u30fc\u30ab\u30eb\u306bphpMyAdmin\u3092\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7<\/a><br>Keyword : MariaDB, MySQL, Adminer, my.ini<\/p>\n\n\n\n<p>\u30b5\u30fc\u30d0\u30fc\u30d1\u30cd\u30eb\u2192\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u2192MySQL\u8a2d\u5b9a\u2192MySQL\u60c5\u5831\u30bf\u30d6<br>\u3067\u78ba\u8a8d\u3059\u308b\u3068<br><strong>MariaDB10.5<\/strong><br>\u30d0\u30fc\u30b8\u30e7\u30f3 MariaDB10.5.x<br>\u3068\u3042\u308a\u307e\u3057\u305f\u3002<br>\u3053\u308c\u306f\u65e7Xfree\u30b5\u30fc\u30d0\u30fc\u3067\u3082\u540c\u3058\u3002MySQL\u306e\u307b\u3046\u304c\u30ec\u30f3\u30bf\u30eb\u30b5\u30fc\u30d0\u30fc\u754c\u3067\u540d\u524d\u306e\u901a\u308a\u304c\u3088\u3044\u304b\u3089\u3001MariaDB\u3082MySQL\u3082\u540c\u3058\u3068\u6271\u3046\u306e\u304c\u6163\u4f8b\u3067\u3059\u3002<br>MySQL\u3060\u3068\u601d\u3063\u3066\u4f7f\u3063\u3066\u3044\u305f\u3051\u3069\u5b9f\u306fMariaDB\u3060\u3063\u305f\u3001\u3068\u3044\u3046\u306e\u306f\u3001\u30bf\u30e9\u30d0\u30ac\u30cb\u3060\u3068\u601d\u3063\u3066\u98df\u3079\u3066\u3044\u305f\u3051\u3069\u5b9f\u306f\u30a2\u30d6\u30e9\u30ac\u30cb\u3060\u3063\u305f\u3001\u3068\u3044\u3046\u307b\u3069\u306e\u9055\u3044\u306f\u306a\u304f\u3001\u30ba\u30ef\u30a4\u30ac\u30cb\u30fb\u677e\u8449\u30ac\u30cb\u30fb\u8d8a\u524d\u30ac\u30cb\u3068\u3044\u3063\u305f\u7523\u5730\u306b\u3088\u308b\u547c\u3073\u540d\u306e\u9055\u3044\u306e\u3088\u3046\u306a\u3082\u306e\u3001\u3068\u3053\u3053\u306f\u89e3\u91c8\u3057\u3066\u304a\u3051\u3070\u3088\u3055\u305d\u3046\u3067\u3059\u3002<br><br>\u3055\u3066\u3001\u79c1\u304c\u3044\u307e\u76ee\u6307\u3057\u3066\u3044\u308b\u306e\u306f\u3001cloudfree\u30b5\u30fc\u30d0\u30fc\u306e\u30ed\u30fc\u30ab\u30eb\u958b\u767a\u74b0\u5883\u306e\u69cb\u7bc9\u3002<br>\u6614\u3044\u308c\u305fMySQL\u304c\u52d5\u3044\u3066\u307e\u3059\u3051\u3069\u3001\u306a\u308b\u3079\u304f\u30b5\u30fc\u30d0\u30fc\u306b\u3042\u308f\u305b\u308b\u3068\u3044\u3046\u72d9\u3044\u3067MariaDB\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u307f\u307e\u3059\u3002MySQL\u306f\u305d\u306e\u307e\u307e\u6b8b\u3057\u3066\u3002<br><br>\u7af6\u5408\u3059\u308b\u306e\u306f\u30dd\u30fc\u30c8\u756a\u53f7\u3002<br>3306\u306f\u672c\u5bb6MySQL\u306b\u305d\u306e\u307e\u307e\u4f7f\u308f\u305b\u308b\u3068\u3057\u3066\u3001MariaDB\u3092\u3069\u3046\u3059\u308b\u304b\u3002<br>3307\u3068\u304b\u30013316\u306a\u3069\u304c\u305d\u3046\u3044\u3046\u30b1\u30fc\u30b9\u3067\u63a1\u7528\u3055\u308c\u3066\u3044\u308b\u307f\u305f\u3044\u3002<br>\u30d1\u30c3\u3068\u307f\u3001\u540c\u985e\u3067\u3042\u308b\u3068\u308f\u304b\u308b\u3051\u3069\u3001\u898b\u9593\u9055\u3046\u3053\u3068\u3082\u306a\u3044\u756a\u53f7\u3001\u3092\u8003\u3048\u3066\u3072\u3089\u3081\u304d\u307e\u3057\u305f\u3002<br>6603<br>\u30d5\u30a1\u30a4\u30a2\u30a6\u30a9\u30fc\u30eb\u3067\u51fa\u3066\u3053\u306a\u3044\u3053\u3068\u3068\u3001TCP\/UDP PORT\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3068\u3044\u3046\u30b5\u30a4\u30c8<br>https:\/\/hi-nemos.com\/port\/?port=6603<br>\u3067\u8abf\u3079\u3066\u307f\u307e\u3057\u305f\u304c\u30e1\u30b8\u30e3\u30fc\u306a\u30c4\u30fc\u30eb\u3068\u88ab\u3063\u3066\u306a\u3044\u3088\u3046\u3067\u3059\u3002<br>\u300e\u3053\u308c\u3067\u3044\u3053\u3046\uff01\u300f<br><br>\u3044\u3056MariaDB\u516c\u5f0f\u30b5\u30a4\u30c8\u3078\u3002https:\/\/mariadb.com\/<br>MariaDB 10.5.x \u306b\u8fd1\u3044\u3082\u306e\u3068\u3057\u3066\u3001MariaDB Server 10.5.22 \u3092Download\u3002<br>Zip\u7248\u306e\u307b\u3046\u304cMySQL\u5171\u5b58\u306e\u878d\u901a\u304c\u304d\u304f\u3068\u601d\u3044\u305d\u3061\u3089\u3092\u9078\u3073\u307e\u3057\u305f\u304c\u3002<br><br>\u53d6\u8aac<br>https:\/\/mariadb.com\/kb\/en\/installing-mariadb-windows-zip-packages\/<br>\u306b\u5f93\u3044\u3001<br>C:\\zip_unpack\\directory&gt; bin\\mysqld_install_db.exe<br>\u306e\u624b\u9806\u3092\u8e0f\u3080\u3068\u30a8\u30e9\u30fc\u3002<br><br><mark style=\"background-color:#47484B\" class=\"has-inline-color has-tertiary-color\">&#8216;mysqld_install_db.exe&#8217; \u306f\u3001\u5185\u90e8\u30b3\u30de\u30f3\u30c9\u307e\u305f\u306f\u5916\u90e8\u30b3\u30de\u30f3\u30c9\u3001<br>\u64cd\u4f5c\u53ef\u80fd\u306a\u30d7\u30ed\u30b0\u30e9\u30e0\u307e\u305f\u306f\u30d0\u30c3\u30c1 \u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u8a8d\u8b58\u3055\u308c\u3066\u3044\u307e\u305b\u3093\u3002<br><\/mark><br>dir\u3067\u307f\u305f\u3089\u3061\u3083\u3093\u3068\u3042\u308b\u3057\u2026\u2026\u300e\u3093\u30fc\u3001\u3093\u30fc\u300f\u3068\u3057\u3070\u3057\u60a9\u3093\u3067\u6c17\u3065\u304d\u307e\u3057\u305f\u3002<br>\u30d6\u30e9\u30a6\u30b6\u304b\u3089 &#8220;mysqld_install_db.exe&#8221;\u3092\u30b3\u30d4\u30da\u3057\u305f\u306e\u304c\u5931\u6557\u3002<br>&#8220;mariadb-install-db.exe&#8221;\u3068\u672c\u7269\u306f\u30cf\u30a4\u30d5\u30f3\u3067\u3057\u305f\u3002<br>\u5b9f\u884c\u3067\u304d\u305f\u3044\u3044\u3051\u3069\u3001\u6b21\u306e\u30b9\u30c6\u30c3\u30d7\u3001my.ini\u3092\u3069\u3046\u8a2d\u5b9a\u3057\u3066\u3088\u3044\u304b\u304c\u4e0d\u660e\u3002\u3055\u3089\u306b\u30b5\u30fc\u30d3\u30b9\u3068\u3057\u3066\u8d77\u52d5\u3055\u305b\u308b\u60c5\u5831\u3082\u5c11\u306a\u3044\u3002Zip\u30d1\u30c3\u30af\u306b\u306f mariadbd.exe \u304c\u542b\u307e\u308c\u3066\u3044\u3066\u3001\u3053\u308c\u304c\u30b5\u30fc\u30d3\u30b9exe\u306e\u3088\u3046\u3067\u306f\u3042\u308b\u304c\u3002<br><br>msi\u7248\u3060\u3063\u305f\u3089\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6642\u306b\u3001\u30dd\u30fc\u30c8\u756a\u53f7\u30fbroot\u30e6\u30fc\u30b6\u30fc\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u306e\u5165\u529b\u304c\u3042\u308a\u3001\u5373\u4f7f\u3048\u308b\u72b6\u614b\u306b\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u3057\u3066\u304f\u308c\u308b\u307f\u305f\u3044\u3002\u3053\u3053\u306fmsi\u7248\u306b\u983c\u308d\u3046\u3001\u3068msi\u7248\u3092Download\u3057\u306a\u304a\u3057\u307e\u3057\u305f\u3002<br>\u5ff5\u306e\u305f\u3081\u306bMySQL\u306e\u30b5\u30fc\u30d3\u30b9\u3092\u505c\u6b62\u3055\u305b\u3066\u304b\u3089Install\u958b\u59cb\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"495\" height=\"387\" src=\"https:\/\/web.cloudfree.jp\/journal\/wp-content\/uploads\/2023\/10\/maria_inst_1.jpg\" alt=\"\" class=\"wp-image-548\" srcset=\"https:\/\/web.cloudfree.jp\/journal\/wp-content\/uploads\/2023\/10\/maria_inst_1.jpg 495w, https:\/\/web.cloudfree.jp\/journal\/wp-content\/uploads\/2023\/10\/maria_inst_1-300x235.jpg 300w\" sizes=\"(max-width: 495px) 100vw, 495px\" \/><\/figure>\n\n\n\n<p>\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u5148\u306f\u81ea\u7531\u306b\u8a2d\u5b9a\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"495\" height=\"387\" src=\"https:\/\/web.cloudfree.jp\/journal\/wp-content\/uploads\/2023\/10\/maria_inst_2.jpg\" alt=\"\" class=\"wp-image-549\" srcset=\"https:\/\/web.cloudfree.jp\/journal\/wp-content\/uploads\/2023\/10\/maria_inst_2.jpg 495w, https:\/\/web.cloudfree.jp\/journal\/wp-content\/uploads\/2023\/10\/maria_inst_2-300x235.jpg 300w\" sizes=\"(max-width: 495px) 100vw, 495px\" \/><\/figure>\n\n\n\n<p>root\u30e6\u30fc\u30b6\u30fc\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3002\u30b9\u30bf\u30f3\u30c9\u30a2\u30ed\u30f3\u3067\u3057\u304b\u4f7f\u308f\u306a\u3044\u3051\u3069root\u306e\u5916\u90e8\u63a5\u7d9a\u3092\u8a31\u53ef\u3002UTF-8\u3092\u30c7\u30d5\u30a9\u30eb\u30c8\u306b\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"495\" height=\"387\" src=\"https:\/\/web.cloudfree.jp\/journal\/wp-content\/uploads\/2023\/10\/maria_inst_3.jpg\" alt=\"\" class=\"wp-image-550\" srcset=\"https:\/\/web.cloudfree.jp\/journal\/wp-content\/uploads\/2023\/10\/maria_inst_3.jpg 495w, https:\/\/web.cloudfree.jp\/journal\/wp-content\/uploads\/2023\/10\/maria_inst_3-300x235.jpg 300w\" sizes=\"(max-width: 495px) 100vw, 495px\" \/><\/figure>\n\n\n\n<p>port 6603\u3001\u307b\u304b\u306f\u521d\u671f\u5024\u306e\u307e\u307e\u3002<br>\u305d\u3057\u3066Install\u3002\u6210\u529f\u3002<br>\u30b5\u30fc\u30d3\u30b9\u4e00\u89a7\u3092\u958b\u3044\u305f\u3089\u3001\u3082\u3046MariaDB\u3001\u52d5\u3044\u3066\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"472\" height=\"533\" src=\"https:\/\/web.cloudfree.jp\/journal\/wp-content\/uploads\/2023\/10\/maria_inst_4.jpg\" alt=\"\" class=\"wp-image-551\" srcset=\"https:\/\/web.cloudfree.jp\/journal\/wp-content\/uploads\/2023\/10\/maria_inst_4.jpg 472w, https:\/\/web.cloudfree.jp\/journal\/wp-content\/uploads\/2023\/10\/maria_inst_4-266x300.jpg 266w\" sizes=\"(max-width: 472px) 100vw, 472px\" \/><\/figure>\n\n\n\n<p>\u5b9f\u884c\u30d5\u30a1\u30a4\u30eb\u306e\u30d1\u30b9<br>&#8220;C:\\pgm\\mariadb\\bin\\mysqld.exe&#8221; &#8220;&#8211;defaults-file=C:\\pgm\\mariadb\\data\\my.ini&#8221; &#8220;MariaDB&#8221;<br>exe\u540d\u304cmysqld.exe\u3067\u3059\u306d\u3002( mariadbd.exe \u306f\u307e\u3060\u3072\u3068\u308a\u7acb\u3061\u3067\u304d\u306a\u3044\u306e\u304b\u306a )<br>ini\u306e\u30d1\u30b9\u3092\u8d77\u52d5\u30aa\u30d7\u30b7\u30e7\u30f3\u6307\u5b9a\u3057\u3066\u307e\u3059\u3002\u305d\u306eini\u3092\u958b\u3044\u3066\u307f\u307e\u3059\u3068\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\" data-file=\"my.ini\"><code>[mysqld]\ndatadir=C:\/pgm\/mariadb\/data\nport=6603\ninnodb_buffer_pool_size=2025M\ncharacter-set-server=utf8\n[client]\nport=6603\nplugin-dir=C:\/pgm\/mariadb\/lib\/plugin<\/code><\/pre><\/div>\n\n\n\n<p>MySQL\u306emy.ini\u3068\u6bd4\u3079\u308b\u3068\u305a\u3044\u3076\u3093\u30b9\u30c3\u30ad\u30ea\u3067\u3059\u3002\u3059\u3079\u3066\u30c7\u30d5\u30a9\u30eb\u30c8\u5024\u3001\u3068\u3044\u3046\u3053\u3068\u3067\u3057\u3087\u3046\u304b\u3002<br>Adminer\u3067\u7a3c\u50cd\u72b6\u614b\u3092\u78ba\u8a8d\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"332\" height=\"298\" src=\"https:\/\/web.cloudfree.jp\/journal\/wp-content\/uploads\/2023\/10\/9ac5d1d8bd6b49c1263f234a69dff5d9.png\" alt=\"\" class=\"wp-image-554\" srcset=\"https:\/\/web.cloudfree.jp\/journal\/wp-content\/uploads\/2023\/10\/9ac5d1d8bd6b49c1263f234a69dff5d9.png 332w, https:\/\/web.cloudfree.jp\/journal\/wp-content\/uploads\/2023\/10\/9ac5d1d8bd6b49c1263f234a69dff5d9-300x269.png 300w\" sizes=\"(max-width: 332px) 100vw, 332px\" \/><\/figure>\n\n\n\n<p>\u30b5\u30fc\u30d0\u306b localhost:6603<br>\u4f5c\u6210\u3057\u305f root \u30e6\u30fc\u30b6\u30fc\u3067\u30ed\u30b0\u30a4\u30f3\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"550\" height=\"439\" src=\"https:\/\/web.cloudfree.jp\/journal\/wp-content\/uploads\/2023\/10\/localhost6603Adminer.jpg\" alt=\"\" class=\"wp-image-555\" srcset=\"https:\/\/web.cloudfree.jp\/journal\/wp-content\/uploads\/2023\/10\/localhost6603Adminer.jpg 550w, https:\/\/web.cloudfree.jp\/journal\/wp-content\/uploads\/2023\/10\/localhost6603Adminer-300x239.jpg 300w\" sizes=\"(max-width: 550px) 100vw, 550px\" \/><\/figure>\n\n\n\n<p>10.5.22-MariaDB \u3067\u30d0\u30c3\u30c1\u30ea\u52d5\u3044\u3066\u3044\u307e\u3059\u3002<br>\u518d\u8d77\u52d5\u3055\u305b\u3066MySQL\u3068MariaDB\u3001\u4e21\u306e\u7acb\u3061\u4e0a\u304c\u308a\u3092\u78ba\u8a8d\u3002<br><br>Adminer\u3092\u30bf\u30d6\uff12\u3064\u51fa\u3057\u3066\u305d\u308c\u305e\u308c\u306b\u63a5\u7d9a\u3002<br><mark style=\"background-color:#F9F9FB\" class=\"has-inline-color\">MySQL\u30d0\u30fc\u30b8\u30e7\u30f3\uff1a<strong>10.5.22-MariaDB<\/strong>\u3001 PHP\u62e1\u5f35\u6a5f\u80fd <strong>MySQLi<\/strong><br>MySQL\u30d0\u30fc\u30b8\u30e7\u30f3\uff1a<strong>8.0.29<\/strong>\u3001 PHP\u62e1\u5f35\u6a5f\u80fd <strong>MySQLi<\/strong><br><\/mark>\u4e21\u65b9\u3067\u7121\u4e8b\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4e00\u89a7\u3092\u53d6\u5f97\u3067\u304d\u3066\u307e\u3057\u305f\u3002<br>\u3068\u308a\u3042\u3048\u305a\u6210\u529f\u266a<\/p>\n","protected":false},"excerpt":{"rendered":"<p>cloudfree\u306eDB\u306fMariaDB\u306a\u306e\u3067\u30ed\u30fc\u30ab\u30eb\u306b\u3082MariaDB\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002MySQL\u3092\u3059\u3067\u306b\u3044\u308c\u3066\u3044\u305f\u306e\u3067\u5171\u5b58\u3092\u56f3\u308a\u307e\u3059\u3002<\/p>\n","protected":false},"author":1,"featured_media":251,"comment_status":"open","ping_status":"closed","sticky":false,"template":"wp-custom-template-x24-index","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[59,58,14,56,24],"_links":{"self":[{"href":"https:\/\/web.cloudfree.jp\/journal\/wp-json\/wp\/v2\/posts\/248"}],"collection":[{"href":"https:\/\/web.cloudfree.jp\/journal\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/web.cloudfree.jp\/journal\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/web.cloudfree.jp\/journal\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/web.cloudfree.jp\/journal\/wp-json\/wp\/v2\/comments?post=248"}],"version-history":[{"count":0,"href":"https:\/\/web.cloudfree.jp\/journal\/wp-json\/wp\/v2\/posts\/248\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/web.cloudfree.jp\/journal\/wp-json\/wp\/v2\/media\/251"}],"wp:attachment":[{"href":"https:\/\/web.cloudfree.jp\/journal\/wp-json\/wp\/v2\/media?parent=248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/web.cloudfree.jp\/journal\/wp-json\/wp\/v2\/categories?post=248"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/web.cloudfree.jp\/journal\/wp-json\/wp\/v2\/tags?post=248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}