{"id":496,"date":"2018-01-31T23:34:54","date_gmt":"2018-01-31T15:34:54","guid":{"rendered":"http:\/\/hahacool.com\/?p=496"},"modified":"2019-01-07T14:42:07","modified_gmt":"2019-01-07T06:42:07","slug":"mysql-mariadb%e6%95%b0%e6%8d%ae%e5%ba%93%e4%b8%ad%e6%96%87%e6%98%be%e7%a4%ba%e4%b9%b1%e7%a0%81","status":"publish","type":"post","link":"https:\/\/hahacool.com\/?p=496","title":{"rendered":"MySQL-MariaDB\u6570\u636e\u5e93\u4e2d\u6587\u663e\u793a\u4e71\u7801\u4ee5\u53ca\u6570\u636e\u8868\u540d\u53d8\u5c0f\u5199\u95ee\u9898\u7684\u89e3\u51b3(windows\u73af\u5883)"},"content":{"rendered":"<p>windows\u73af\u5883\u5b89\u88c5MySQL\u6216\u8005MariaDB\u540e\uff08\u6bd4\u5982XAMPP\u6574\u5408\u5305\uff09\uff0c\u6570\u636e\u5e93\u91cc\u7684\u4e2d\u6587\u5728\u7f51\u9875\u4e0a\u663e\u793a\uff1f\uff1f\uff1f<\/p>\n<p>\u89e3\u51b3\u65b9\u6cd5\u5982\u4e0b\uff1a<\/p>\n<p>\u627e\u5230mysql\u5b89\u88c5\u76ee\u5f55<\/p>\n<p>\u627e\u5230my.ini \u8fd9\u4e2a\u6587\u4ef6\uff0c\u6253\u5f00<\/p>\n<p>\u5728[mysqld] \u4e0b \u589e\u52a0\u4e00\u53e5 character_set_server=utf8<\/p>\n<p>\u8fd9\u53e5\u662f\u89e3\u51b3\u4e2d\u6587\u4e71\u7801\u7684\u3002<\/p>\n<p>\u518d\u589e\u52a0\u4e00\u53e5<\/p>\n<p>lower_case_table_names=2<\/p>\n<p>\u6ce8: 1 \u8868\u793a\u4e0d\u533a\u5206\u5927\u5c0f\u5199 2\u8868\u793a\u533a\u5206\u5927\u5c0f\u5199<br \/>\n\u4f8b\u5982\u8fd9\u6837<\/p>\n<p>[mysqld]<br \/>\ndatadir=C:\/Program Files\/MariaDB 5.5\/data<br \/>\nport=3306<br \/>\n<span style=\"color: #33cccc;\"><strong>character_set_server=utf8<\/strong><\/span><\/p>\n<p><span style=\"color: #33cccc;\">lower_case_table_names=2<\/span><br \/>\nsql_mode=&#8221;STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION&#8221;<br \/>\ndefault_storage_engine=innodb<br \/>\ninnodb_buffer_pool_size=497M<br \/>\ninnodb_log_file_size=50M<br \/>\n[client]<br \/>\nport=3306<\/p>\n<p>\u91cd\u542f\u670d\u52a1 OK\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>windows\u73af\u5883\u5b89\u88c5MySQL\u6216\u8005MariaDB\u540e\uff08\u6bd4\u5982XAMPP\u6574\u5408\u5305\uff09\uff0c\u6570\u636e\u5e93\u91cc\u7684\u4e2d\u6587\u5728\u7f51\u9875\u4e0a\u663e\u793a\uff1f\uff1f\uff1f [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[166],"tags":[274,273],"class_list":["post-496","post","type-post","status-publish","format-standard","hentry","category-it","tag-mariadb","tag-mysql"],"views":1156,"_links":{"self":[{"href":"https:\/\/hahacool.com\/index.php?rest_route=\/wp\/v2\/posts\/496"}],"collection":[{"href":"https:\/\/hahacool.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hahacool.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hahacool.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hahacool.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=496"}],"version-history":[{"count":0,"href":"https:\/\/hahacool.com\/index.php?rest_route=\/wp\/v2\/posts\/496\/revisions"}],"wp:attachment":[{"href":"https:\/\/hahacool.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=496"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hahacool.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=496"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hahacool.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=496"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}