{"id":10771,"date":"2021-10-21T10:00:00","date_gmt":"2021-10-21T01:00:00","guid":{"rendered":"https:\/\/www.gigas-jp.com\/appnews\/?p=10771"},"modified":"2021-10-20T15:30:47","modified_gmt":"2021-10-20T06:30:47","slug":"xampp%e3%81%aemariadb%e3%82%92mysql%e3%81%ab%e7%bd%ae%e3%81%8d%e6%8f%9b%e3%81%88%e3%82%8b%e6%96%b9%e6%b3%952","status":"publish","type":"post","link":"https:\/\/www.gigas-jp.com\/appnews\/archives\/10771","title":{"rendered":"Xampp\u306eMariaDB\u3092MySQL\u306b\u7f6e\u304d\u63db\u3048\u308b\u65b9\u6cd5(2)"},"content":{"rendered":"\n<p>\u958b\u767a\/\u691c\u8a3c\u74b0\u5883\u3092\u624b\u8efd\u306b\u69cb\u7bc9\u3059\u308b\u305f\u3081\u306b\u306fXampp\u306e\u5c0e\u5165\u306f\u6709\u52b9\u3067\u3059\u304c\u3001Xampp\u306b\u542b\u307e\u308c\u308bDB\u304c\u672c\u756a\u30b5\u30fc\u30d0\u30fc\u306eDB\u3068\u7570\u306a\u308b\u5834\u5408\u3001\u540c\u3058\u3082\u306e\u306b\u3042\u308f\u305b\u3066\u691c\u8a3c\u3092\u304a\u3053\u306a\u3046\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<br>\u4eca\u56de\u306f\u672c\u756a\u30b5\u30fc\u30d0\u30fc\u306eDB\u304cMySQL\u3068\u4eee\u5b9a\u3057\u3066\u3001Xampp\u306b\u542b\u307e\u308c\u3066\u3044\u308bMariaDB\u3092MySQL\u306b\u7f6e\u304d\u63db\u3048\u308b\u65b9\u6cd5\u3092\u30b7\u30a7\u30a2\u3057\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<br>\u672c\u8a18\u4e8b\u306f\u524d\u56de\u306e\u300c<a rel=\"noreferrer noopener\" href=\"https:\/\/www.gigas-jp.com\/appnews\/archives\/10666\" target=\"_blank\">Xampp\u306eMariaDB\u3092MySQL\u306b\u7f6e\u304d\u63db\u3048\u308b\u65b9\u6cd5(1)<\/a>\u300d\u306e\u7d9a\u304d\u3067\u3059\u3002<\/p>\n\n\n\n<!--more-->\n\n\n\n<h4>Xampp\u306eMariaDB\u3092MySQL\u306b\u7f6e\u304d\u63db\u3048\u308b<\/h4>\n\n\n\n<p>\u307e\u305a\u306fXAMPP Control Panel\u304b\u3089MySQL\u306e\u505c\u6b62\u3092\u304a\u3053\u306a\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"832\" height=\"537\" src=\"https:\/\/www.gigas-jp.com\/appnews\/wp-content\/uploads\/sites\/4\/2021\/10\/1-1.png\" alt=\"\" class=\"wp-image-10778\"\/><\/figure>\n\n\n\n<p>\u3064\u304e\u306b<br>C:\\xampp7422\\mysql<br>\u3092<br>C:\\xampp7422\\mariadb<br>\u306b\u30ea\u30cd\u30fc\u30e0\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u524d\u56de\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305f<br>mysql-8.0.26-winx64.zip<br>\u306e\u89e3\u51cd\u3092\u304a\u3053\u306a\u3044\u3001\u4ee5\u4e0b\u306b\u8a2d\u7f6e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>C:\\xampp7422\\mysql<\/p>\n\n\n\n<p>\u3064\u304e\u306b<br>C:\\xampp7422\\mariadb\\bin\\my.ini<br>\u3092<br>C:\\xampp7422\\mysql\\bin\\my.ini<br>\u306b\u30b3\u30d4\u30fc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>C:\\xampp7422\\mysql\\bin\\my.ini \u3092\u30a8\u30c7\u30a3\u30bf\u3067\u958b\u3044\u3066<br>[mysqld]\u30bb\u30af\u30b7\u30e7\u30f3\u306b\u3042\u308bkey_buffer=\u304b\u3089\u59cb\u307e\u308b\u884c\u3092\u30b3\u30e1\u30f3\u30c8\u30a2\u30a6\u30c8\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u305d\u306e\u5f8c\u30b3\u30de\u30f3\u30c9\u30d7\u30ed\u30f3\u30d7\u30c8\u3067\u4ee5\u4e0b\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>cd C:\\xampp7422\\mysql\nbin\\mysqld --initialize-insecure\nstart \/b bin\\mysqld\nbin\\mysql -u root\n\n\u4ee5\u4e0bmysql\u30b3\u30de\u30f3\u30c9\n\nCREATE USER pma@localhost;\nSOURCE C:\/xampp7422\/phpMyAdmin\/sql\/create_tables.sql;\nGRANT SELECT, INSERT, DELETE, UPDATE, ALTER ON phpmyadmin.* TO pma@localhost;\nALTER USER root@localhost IDENTIFIED WITH mysql_native_password BY '';\nALTER USER pma@localhost IDENTIFIED WITH mysql_native_password BY '';\n\\q\n\nmysql\u30b3\u30de\u30f3\u30c9\u7d42\u4e86\n\nbin\\mysqladmin -u root shutdown<\/code><\/pre>\n\n\n\n<p><br>\u4ee5\u4e0a\u3067Xampp\u306eMariaDB\u3092MySQL\u306b\u5dee\u3057\u66ff\u3048\u5b8c\u4e86\u3067\u3059\u3002<\/p>\n\n\n\n<p>XAMPP Control Panel\u304b\u3089Apache\u3068MySQL\u306e\u8d77\u52d5\u3092\u304a\u3053\u306a\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"831\" height=\"532\" src=\"https:\/\/www.gigas-jp.com\/appnews\/wp-content\/uploads\/sites\/4\/2021\/10\/3.png\" alt=\"\" class=\"wp-image-10783\"\/><\/figure>\n<div class='wp_social_bookmarking_light'>\n            <div class=\"wsbl_google_plus_one\"><g:plusone size=\"medium\" annotation=\"none\" href=\"https:\/\/www.gigas-jp.com\/appnews\/archives\/10771\" ><\/g:plusone><\/div>\n            <div class=\"wsbl_hatena_button\"><a href=\"\/\/b.hatena.ne.jp\/entry\/https:\/\/www.gigas-jp.com\/appnews\/archives\/10771\" class=\"hatena-bookmark-button\" data-hatena-bookmark-title=\"Xampp\u306eMariaDB\u3092MySQL\u306b\u7f6e\u304d\u63db\u3048\u308b\u65b9\u6cd5(2)\" data-hatena-bookmark-layout=\"standard\" title=\"\u3053\u306e\u30a8\u30f3\u30c8\u30ea\u30fc\u3092\u306f\u3066\u306a\u30d6\u30c3\u30af\u30de\u30fc\u30af\u306b\u8ffd\u52a0\"> <img src=\"\/\/b.hatena.ne.jp\/images\/entry-button\/button-only@2x.png\" alt=\"\u3053\u306e\u30a8\u30f3\u30c8\u30ea\u30fc\u3092\u306f\u3066\u306a\u30d6\u30c3\u30af\u30de\u30fc\u30af\u306b\u8ffd\u52a0\" width=\"20\" height=\"20\" style=\"border: none;\" \/><\/a><script type=\"text\/javascript\" src=\"\/\/b.hatena.ne.jp\/js\/bookmark_button.js\" charset=\"utf-8\" async=\"async\"><\/script><\/div>\n            <div class=\"wsbl_twitter\"><a href=\"https:\/\/twitter.com\/share\" class=\"twitter-share-button\" data-url=\"https:\/\/www.gigas-jp.com\/appnews\/archives\/10771\" data-text=\"Xampp\u306eMariaDB\u3092MySQL\u306b\u7f6e\u304d\u63db\u3048\u308b\u65b9\u6cd5(2)\" data-via=\"GIGASJAPAN_APPS\" data-lang=\"ja\">Tweet<\/a><\/div>\n            <div class=\"wsbl_facebook_like\"><div id=\"fb-root\"><\/div><fb:like href=\"https:\/\/www.gigas-jp.com\/appnews\/archives\/10771\" layout=\"button_count\" action=\"like\" width=\"100\" share=\"false\" show_faces=\"false\" ><\/fb:like><\/div>\n            <div class=\"wsbl_facebook_send\"><div id=\"fb-root\"><\/div><fb:send href=\"https:\/\/www.gigas-jp.com\/appnews\/archives\/10771\" colorscheme=\"light\" ><\/fb:send><\/div>\n    <\/div>\n<br class='wp_social_bookmarking_light_clear' \/>\n","protected":false},"excerpt":{"rendered":"<p>\u958b\u767a\/\u691c\u8a3c\u74b0\u5883\u3092\u624b\u8efd\u306b\u69cb\u7bc9\u3059\u308b\u305f\u3081\u306b\u306fXampp\u306e\u5c0e\u5165\u306f\u6709\u52b9\u3067\u3059\u304c\u3001Xampp\u306b\u542b\u307e\u308c\u308bDB\u304c\u672c\u756a\u30b5\u30fc\u30d0\u30fc\u306eDB\u3068\u7570\u306a\u308b\u5834\u5408\u3001\u540c\u3058\u3082\u306e\u306b\u3042\u308f\u305b\u3066\u691c\u8a3c\u3092\u304a\u3053\u306a\u3046\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u4eca\u56de\u306f\u672c\u756a\u30b5\u30fc\u30d0\u30fc\u306eDB\u304cMySQL\u3068\u4eee\u5b9a\u3057\u3066 [&hellip;]<\/p>\n","protected":false},"author":16,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[72,100],"tags":[],"acf":[],"_links":{"self":[{"href":"https:\/\/www.gigas-jp.com\/appnews\/wp-json\/wp\/v2\/posts\/10771"}],"collection":[{"href":"https:\/\/www.gigas-jp.com\/appnews\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gigas-jp.com\/appnews\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gigas-jp.com\/appnews\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gigas-jp.com\/appnews\/wp-json\/wp\/v2\/comments?post=10771"}],"version-history":[{"count":9,"href":"https:\/\/www.gigas-jp.com\/appnews\/wp-json\/wp\/v2\/posts\/10771\/revisions"}],"predecessor-version":[{"id":10788,"href":"https:\/\/www.gigas-jp.com\/appnews\/wp-json\/wp\/v2\/posts\/10771\/revisions\/10788"}],"wp:attachment":[{"href":"https:\/\/www.gigas-jp.com\/appnews\/wp-json\/wp\/v2\/media?parent=10771"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gigas-jp.com\/appnews\/wp-json\/wp\/v2\/categories?post=10771"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gigas-jp.com\/appnews\/wp-json\/wp\/v2\/tags?post=10771"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}