\u76f8\u95dc\uff1a\u5ba2\u88fd\u5316ERP\uff0c\u5ba2\u88fd\u5316\u9032\u92b7\u5b58\uff0c\u5ba2\u88fd\u5316BOS\u6a5f\u4e2d\u592e\u7ba1\u7406\u7cfb\u7d71\uff0c\u7d14\u8cc7\u6599\u8cc7\u6599\u5eab\u3002<\/p>\n
\u76ee\u7684\uff1a\u7528\u65bc\u5c01\u9589\u5f0f\u5340\u57df\u7db2\u8def\uff0c\u57fa\u672c\u8a2d\u5b9a\uff0c\u9632\u706b\u7246\u5f8c\uff0c\u901a\u8a0a\u5354\u5b9a\u90e8\u5206\u642d\u914d\u9632\u706b\u7246\u8a2d\u5b9a\uff0c\u5982\u7121\u9632\u706b\u7246\u6709\u5c0d\u5916\u9700\u6c42\uff0c\u53ef\u9032\u968e\u8a2d\u5b9a\u5efa\u7acb\u4f3a\u670d\u5668\u7db2\u8def\u76f8\u95dc\u9650\u5236\u3002<\/p>\n
\u4f7f\u7528\u7248\u672c\uff1aubuntu 16.04 <\/span><\/span><\/span>\u7248\u672c\uff0c<\/span><\/span><\/span>\u6280\u8853\u652f\u63f4\u81f3<\/span><\/span>2021<\/span><\/span><\/span>\u5e74<\/span><\/span>04<\/span><\/span><\/span>\u6708<\/span><\/span><\/p>\n \u9069\u7528\u7cfb\u7d71\uff1a\u65b7\u9ede\u8a2d\u8a082017\u5e7410\u6708\u524d\u5c08\u6848\uff0c\u539fmysql_2.6.*\u8cc7\u6599\u5eab<\/p>\n \u6548\u76ca\uff1a\u4ee4\u820a\u5f0f\u8a9e\u6cd5\u76f8\u5bb9\u65bc\u65b0\u7248\u672cmysql\u7cfb\u7d71\u53ca\u5176\u652f\u7cfb<\/p>\n \u65b7\u9ede\u8a2d\u8a08\uff0cubuntu \u7d14\u8cc7\u6599\u4f3a\u670d\u5668\u8a2d\u5b9a\u6d41\u7a0b \u76f8\u95dc\uff1a\u5ba2\u88fd\u5316ERP\uff0c\u5ba2\u88fd\u5316\u9032\u92b7\u5b58\uff0c\u5ba2\u88fd\u5316BOS\u6a5f\u4e2d\u592e\u7ba1\u7406\u7cfb\u7d71\uff0c\u7d14\u8cc7\u6599\u8cc7\u6599\u5eab\u3002 \u76ee\u7684\uff1a\u7528\u65bc\u5c01\u9589\u5f0f\u5340\u57df\u7db2\u8def\uff0c\u57fa\u672c\u8a2d […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37,40],"tags":[39],"class_list":["post-2252","post","type-post","status-publish","format-standard","hentry","category-support","category-database-server","tag-erp"],"_links":{"self":[{"href":"https:\/\/bpoint.space\/index.php?rest_route=\/wp\/v2\/posts\/2252","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bpoint.space\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bpoint.space\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bpoint.space\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/bpoint.space\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2252"}],"version-history":[{"count":0,"href":"https:\/\/bpoint.space\/index.php?rest_route=\/wp\/v2\/posts\/2252\/revisions"}],"wp:attachment":[{"href":"https:\/\/bpoint.space\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2252"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bpoint.space\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2252"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bpoint.space\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2252"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n\u7b2c\u4e00\u6b65\uff1a\u5b89\u88dd ubuntu 16.04 \u7248\u672c \u4e0b\u8f09\u4f4d\u5740\uff1a https:\/\/www.ubuntu-tw.org\/modules\/tinyd0\/ \u652f\u63f4\u81f3 2021\u5e74 04 \u6708 \u5b89\u88dd\u81f3\u96fb\u8166 \u786c\u789f\u898f\u5283\uff1a\u9810\u8a2d(\u65b0\u624b\u7528) \u786c\u789f\u5206\u5272\uff1a\u9810\u8a2d(\u65b0\u624b\u7528)
\n\u7b2c\u4e8c\u6b65\uff1a\u5b89\u88dd mariaDB \u53c3\u8003\u8cc7\u6599\uff1a https:\/\/blog.gtwang.org\/linux\/centos-7-install-mariadb-mysql-server-tutorial\/ https:\/\/www.phpini.com\/linux\/debian-ubuntu-install-mariadb-10-1
\n\u5148\u66f4\u65b0 Linux \u7cfb\u7d71\u4e0a\u7684\u5b89\u88dd\u5957\u4ef6(yum \u6216 apt-get) ubuntu \u6307\u4ee4\uff1asudo yum update \u6216 ubuntu \u6307\u4ee4\uff1asudo apt-get install yum
\n\u900f\u904e yum\u5b89\u88dd MariaDB \u4f3a\u670d\u5668 ubuntu \u6307\u4ee4\uff1asudo yum install mariadb-server
\n\u8a2d\u5b9a\u555f\u7528 MariaDB \u7684 service\uff08\u8b93\u958b\u6a5f\u81ea\u52d5\u555f\u52d5\uff09\uff1a ubuntu \u6307\u4ee4\uff1asudo systemctl enable mariadb
\n\u7acb\u5373\u555f\u52d5 MariaDB \u7684 service ubuntu \u6307\u4ee4\uff1asudo systemctl start mariadb
\n\u6aa2\u67e5 MariaDB \u4f3a\u670d\u5668\u662f\u5426\u6709\u6b63\u5e38\u555f\u52d5\uff1a ubuntu \u6307\u4ee4\uff1asystemctl status mariaDB
\n\u4f7f\u7528 root \u5e33\u865f\u767b\u5165 MariaDB \u4f3a\u670d\u5668 ubuntu \u6307\u4ee4\uff1amysql -u root -p
\n\u4e8c-1\uff1a\u5982\u5b89\u88dd\u5b8c\u6210\u7121\u6cd5\u9032\u5165\uff0c\u4ee5\u672c\u6a5f\u7aef\u5b89\u5168\u6a21\u5f0f\u9032\u5165 \u8b66\u544a\u78bc\uff1aERROR 1698 (28000)
\n\u53c3\u8003\u8cc7\u6599\uff1a https:\/\/www.cnblogs.com\/leolztang\/p\/5094930.html http:\/\/goodjack.blogspot.tw\/2017\/11\/mariadb-error-1698-28000.html https:\/\/my.oschina.net\/cimu\/blog\/365462
\n\u6b0a\u9650\u4e0d\u8db3\u2192\u4ee5\u5b89\u5168\u6a21\u5f0f\u5b89\u555f mysql\/mariaDB \u6d41\u7a0b
\n1.\u95dc\u9589\u8cc7\u6599\u5eab mariaDB\u6307\u4ee4\uff1asudo service mysql stop
\n2.\u5b89\u5168\u6a21\u5f0f\u555f\u52d5\u8cc7\u6599\u5eab
\nmariaDB\u6307\u4ee4\uff1asudo mysqld_safe –skip-grant-tables &
\n3.\u7121\u9808\u5bc6\u78bc\u9032\u5165 mysql mariaDB\u6307\u4ee4\uff1amysql -u root
\n4.\u67e5\u770b user \u8868(\u4f7f\u7528\u8005\u5e33\u865f) mariaDB\u6307\u4ee4\uff1aselect user, plugin from mysql.user;
\nroot \u7684 plugin \u88ab\u4fee\u6539\u6210\u4e86 auth_socket\uff0c\u7528\u5bc6\u78bc\u767b\u9304\u7684 plugin \u61c9\u662f mysql_native_password \u95dc\u65bc auth_socket\uff0c\u5b98\u65b9\u8bf4\u660e\uff1a https:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/socket-pluggableauthentication.html
\n5.1.\u8abf\u6574\u65b9\u6cd5 5.1.1 \u66f4\u65b0\u8a2d\u5b9a-\u8a2d\u5b9a root \u5bc6\u78bc\u70ba 0919- plugin \u70ba root mariaDB\u6307\u4ee4\uff1aupdate mysql.user set authentication_string=PASSWORD(‘0919′), plugin=’mysql_native_password’ where user=’root’;
\n\u5237\u65b0\u7cfb\u7d71\u6b0a\u9650 mariaDB\u6307\u4ee4\uff1aflush privileges;
\n5.2.\u8abf\u6574\u65b9\u6cd5 5.2.1 \u66f4\u65b0\u6307\u4ee4 \u4f7f\u7528 mysql\u8cc7\u6599\u8868 mariaDB\u6307\u4ee4\uff1ause mysql;
\n\u66f4\u65b0 root \u5bc6\u78bc\u70ba 0919 mariaDB\u6307\u4ee4\uff1aupdate user set password=PASSWORD(“0919”) where User=’root’;
\n\u5237\u65b0\u7cfb\u7d71\u6b0a\u9650 mariaDB\u6307\u4ee4\uff1aflush privileges;
\n6.\u96e2\u958b\u8cc7\u6599\u5eab mariaDB\u6307\u4ee4\u4e00\uff1aexit mariaDB\u6307\u4ee4\u4e8c\uff1aquit
\n7.\u91cd\u555f\u8cc7\u6599\u5eab mariaDB\u6307\u4ee4\u4e00\uff1asudo \/etc\/init.d\/mysql restart mariaDB\u6307\u4ee4\u4e8c\uff1asudo restart mysql mariaDB\u6307\u4ee4\u4e09\uff1asudo service mysql restart
\n8.\u555f\u52d5\u8cc7\u6599\u5eab\uff1a mariaDB\u6307\u4ee4\u4e00\uff1asudo \/etc\/init.d\/mysql start mariaDB\u6307\u4ee4\u4e8c\uff1asudo start mysql mariaDB\u6307\u4ee4\u4e09\uff1asudo service mysql start
\n9.\u505c\u6b62\u8cc7\u6599\u5eab\uff1a mariaDB\u6307\u4ee4\u4e00\uff1asudo \/etc\/init.d\/mysql stop mariaDB\u6307\u4ee4\u4e8c\uff1asudo stop mysql mariaDB\u6307\u4ee4\u4e09\uff1asudo service mysql stop
\n10.\u4f7f\u7528\u65b0\u5bc6\u78bc\u6b63\u5e38\u767b\u5165\u8cc7\u6599\u5eab-\u5e33\u865f root \u5bc6\u78bc 0919 mariaDB\u6307\u4ee4\uff1amysql -u root -p0919
\n\u4e8c-1\uff1a\u8cc7\u6599\u5eab\u7121\u6cd5\u9060\u7aef\/\u5916\u90e8\u8a2a\u554f\uff0c\u8a2d\u5b9a\u5916\u90e8 ip\u9023\u7dda \u9810\u8a2d\u7684 MariaDB \u53ea\u80fd\u5f9e localhost\uff08127.0.0.1\uff09\u9023\u7dda\uff0c\u56e0\u70ba\u5b89\u5168\u6027\u7684\u56e0\u7d20\uff0c\u901a\u5e38 \u4e0d\u5efa\u8b70\u96a8\u4fbf\u958b\u653e\u5916\u9762\u7684\u5b58\u53d6 \u53c3\u8003\u8cc7\u6599\uff1a http:\/\/mustgeorge.blogspot.tw\/2011\/11\/mysql-error-1045-28000-usingpassword.html http:\/\/benjr.tw\/97973 http:\/\/benjr.tw\/98033
\n\u89e3\u6c7a\u65b9\u6cd5 1-\u5fc5\u9808\u8a2d\u5b9a\u53c3\u6578 1.1.\u9032\u5165\u8cc7\u6599\u5eab mariaDB\u6307\u4ee4\uff1amysql -uroot mysql -p0919
\n1.2.\u628a\u6240\u6709\u8cc7\u6599\u5eab(\u542b\u5176\u4e0b\u7684\u6240\u6709\u8cc7\u6599\u8868)\uff0c\u6388\u6b0a\u7d66 root\uff0c\u5f9e localhost \u4e0a\u4f86\uff0c\u5bc6\u78bc \u70ba\u5f15\u865f\u5167\u6578\u64da ‘0919’ mariaDB\u6307\u4ee4\uff1aGRANT all ON *.* TO root@’localhost’ IDENTIFIED BY ‘0919’;
\n1.3.\u5237\u65b0\u7cfb\u7d71\u6b0a\u9650\u8868 mariaDB\u6307\u4ee4\uff1aFLUSH PRIVILEGES;
\n1.4.\u986f\u793a root@\u3001172.16.15.%\u3001\u4f4d\u5740\u6b0a\u9650\u72c0\u614b mariaDB\u6307\u4ee4\uff1ashow grants for root@’172.16.15.%’;
\n1.5.\u65b0\u589e\u4f7f\u7528\u8005 user1 \u4e26\u6388\u4e88\u672c\u6a5f\u7aef\u9023\u7dda mariaDB\u6307\u4ee4\uff1aCREATE USER user1@localhost IDENTIFIED BY ‘111111’;
\n1.5.\u65b0\u589e\u4f7f\u7528\u8005\u4e26\u6388 user3 \u4e88\u2019%\u2019\u5168\u90e8\u4f4d\u5740\u9023\u7dda mariaDB\u6307\u4ee4\uff1aCREATE USER user3@’%’ IDENTIFIED BY ‘111111’;
\n1.6.\u65b0\u589e\u4f7f\u7528\u8005 user2 \u4e26\u6388\u4e88\u2019172.16.15.%\u2019\u9650\u5b9a\u4f4d\u5740\u9023\u7dda%\u70ba\u7121\u9650\u5236 mariaDB\u6307\u4ee4\uff1aCREATE USER user2@’172.16.15.%’ IDENTIFIED BY ‘111111’;
\n1.7.\u96e2\u958b\u8cc7\u6599\u5eab mariaDB\u6307\u4ee4\uff1aquit
\n\u53c3\u8003\u8cc7\u6599\uff1a http:\/\/benjr.tw\/98033
\n\u88dc\u5145\u8cc7\u6599\u53c3\u7167\uff1a \u7ba1\u7406\u6b0a\u9650
\nGRANT , SUPER , PROCESS , RELOAD , SHUTDOWN , SHOW DATABASES , LOCK TABLES , REFERENCES , REPLICATION CLIENT , REPLICATION SLAVE , CREATE USER \u7d50\u69cb\u6b0a\u9650 CREATE , ALTER , INDEX , DROP , CREATE TEMPORARY TABLES , SHOW VIEW , CREATE ROUTINE , ALTER ROUTINE , EXECUTE , CREATE VIEW , EVENT , TIGGER \u8cc7\u6599 \u6b0a\u9650 SELECT , INSERT , UPDATE , DELETE , FILE
\n(\u8ffd\u52a0)\u7d66\u4e88 user1 \u8cc7\u6599\u5eab (user1Date ) \u7684\u5168\u90e8\u6b0a\u9650 (ALL PRIVILEGES) mariaDB\u6307\u4ee4\uff1agrant all privileges on user1Data.* to user1@localhost ;
\n(\u8ffd\u52a0)\u7d66\u4e88 user2 \u64cd\u4f5c(select) \u8cc7\u6599\u5eab (user1Data) \u7684\u6b0a\u9650 mariaDB\u6307\u4ee4\uff1agrant select on user1Data.* to user2@’172.16.15.%’;
\n(\u8ffd\u52a0)\u5efa\u7acb\u5e33\u865f\u8207\u7d66\u4e88\u6b0a\u9650\u7684\u6307\u4ee4\u53ef\u4ee5\u540c\u6642\u4e0b\u7684,\u5982\u4e0b\u6240\u793a mariaDB \u6307\u4ee4\uff1agrant all privileges on user1Data.* to user1@localhost identified by \u2018your.password\u2019 ;
\n\u53c3\u8003\u8cc7\u6599\uff1a\u6b0a\u9650\u8aaa\u660e https:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/grant.html
\n\u89e3\u6c7a\u65b9\u6cd5 2-\u5fc5\u9808\u8a2d\u5b9a\u53c3\u6578\uff1a \u72c0\u6cc1\uff1amariaDB \u53ea\u76e3\u807d 127.0.0.1 \u53c3\u8003\u8cc7\u6599\uff1a http:\/\/jiangbai333.github.io\/2016\/03\/08\/mysql%E5%BC%80%E5%90%AF %E8%BF%9C%E7%A8%8B%E8%AE%BF%E9%97%AE(%E6%97%A0%E5%BA%9F %E8%AF%9D)\/ https:\/\/lipeng1943.com\/blog\/?p=207 https:\/\/hk.saowen.com\/a\/bc4640ec8cbcf3ff0effceddb656e597e99f3dcea1c9 d990034094e2897b7f48 https:\/\/zoco.me\/post\/centos7-mariadb-remote-access https:\/\/gwokae.mewggle.com\/wordpress\/2009\/11\/mysql%E8%B3%87%E6%96%99%E8%A1%A8%E3%80%81%E8%B3%87%E6%96%99% E5%BA%AB%E5%90%8D%E7%A8%B1%E5%8D %80%E5%88%86%E5%A4%A7%E5%B0%8F%E5%AF%AB%E7%9A %84%E8%A8%AD%E5%AE%9A\/
\n\u67e5\u8a62\u8cc7\u6599\u5eab\u76e3\u807d 3306 \u72c0\u6cc1 ubuntu \u6307\u4ee4\uff1anetstat -ano | grep 3306 \u986f\u793a\u8cc7\u6599\uff1a\u8868\u793a\u53ea\u76e3\u807d 127.0.0.1 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN off(0.00\/0\/0)
\n\u8a2a\u554f\/etc\/mysql\/my.cnf \u8a2d\u5b9a\u6a94 ubuntu \u6307\u4ee4\uff1asudo vim \/etc\/mysql\/my.cnf
\n\u6ce8\u610f\uff01\u8cc7\u6599\u5eab\u8a2d\u5b9a\u6a94\u53ef\u80fd\u91cd\u5b9a\u5411\uff0c\u9700\u53c3\u8003\u539f\u59cb my.cnf \u6a94\uff0c\u4fee\u6539\u6b63\u78ba\u6a94\u6848 \u8a2a\u554f\/etc\/mysql\/mysql.conf.d\/mysqld.cnf \u8a2d\u5b9a\u6a94
\nubuntu \u6307\u4ee4\uff1asudo vim \/etc\/mysql\/mysql.conf.d\/mysqld.cnf
\n\u8a2d\u5b9a\u8cc7\u6599\u8868\u3001\u8cc7\u6599\u5eab\u540d\u7a31\u5340\u5206\u5927\u5c0f\u5beb \u53c3\u8003\u8cc7\u6599\uff1a http:\/\/study27.blogspot.com\/2014\/08\/mysql.html
\n\u6587\u4ef6\u6307\u4ee4\uff1a #\u4efb\u610f\u884c\u589e\u52a0\u6b64\u6307\u4ee4 lower_case_table_names=1
\n\u6307\u4ee4\u7b46\u8a18\uff1a lower_case_table_names=0 (Windows \u9810\u8a2d) \u8cc7\u6599\u8868(table)\u53ca\u8cc7\u6599\u5eab\u540d\u7a31(database names)\u4e00\u5f8b\u7528\u5c0f\u5beb\u5b58\u5728\u78c1\u789f\u4e2d\u3002\u6bd4\u8f03(\u67e5\u8a62) \u6642\u662f\u5340\u5206\u5927\u5c0f\u5beb(case sensitive)\u3002
\nlower_case_table_names=1 \u8cc7\u6599\u8868(table)\u53ca\u8cc7\u6599\u5eab\u540d\u7a31(database names)\u4e00\u5f8b\u7528\u5c0f\u5beb\u5b58\u5728\u78c1\u789f\u4e2d\u3002\u6bd4\u8f03\u6642\u662f \u4e0d\u5340\u5206\u5927\u5c0f\u5beb(case insensitive)\u3002MySql \u8f49\u63db\u6240\u6709\u7684\u8cc7\u6599\u8868(table)\u3001\u8cc7\u6599\u5eab\u540d\u7a31 (database names)\u3001\u8868\u5225\u540d(table aliases)(\u8a3b 1)\u70ba\u5c0f\u5beb\u4f86\u5b58\u53d6\u3002\u6240\u4ee5\u5be6\u9ad4\u6a94\u6848\u7684 \u540d\u7a31\u5fc5\u9808\u5168\u70ba\u5c0f\u5beb\uff0c\u5426\u5247\u6703\u5b58\u53d6\u4e0d\u5230\u3002
\nlower_case_table_names =2 (Mac OS X \u9810\u8a2d) \u8cc7\u6599\u8868(table)\u3001\u8cc7\u6599\u5eab\u540d\u7a31(database names)\u5132\u5b58\u6642\u78c1\u789f\u7684\u6a94\u6848\u5340\u5206\u5927\u5c0f\u5beb\u3002\u4f46 \u67e5\u8a62\u6bd4\u8f03\u6642 MySQL \u5c07\u67e5\u8a62\u8f49\u63db\u6210\u5c0f\u5beb\uff0c\u4e0d\u662f\u5340\u5206\u5927\u5c0f\u5beb\u3002\u4f46\u9019\u500b\u8a2d\u5b9a\u50c5\u9069\u7528\u65bc\u4e0d \u5340\u5206\u5927\u5c0f\u5beb\u7684\u6a94\u6848\u7cfb\u7d71\u3002
\n\u8a3b\u91cb\u6389 skip-networking \u9078\u9805\u4f86\u958b\u555f\u9060\u7a0b\u8a2a\u554f ubuntu \u6307\u4ee4\uff1agrep -rn “skip-networking” *
\n\u8a3b\u91cb\u6216\u8a2d\u5b9a bind-address \u9805\uff0c\u8a72\u9805\u8868\u793a\u904b\u884c\u54ea\u4e9b IP \u5730\u5740\u7684\u6a5f\u5668\u9023\u63a5\uff0c\u5141\u8a31\u6240\u6709\u9060 \u7a0b\u7684\u6a5f\u5668\u9023\u63a5 \u6253\u958b\u6587\u6a94\/etc\/mysql\/mariadb.conf.d\/50-server.cnf\uff0c\u8a3b\u91cb\u6389 bind-address \u9805
\n\u91cd\u65b0\u555f\u52d5\u8cc7\u6599\u5eab\uff1a\u5df2\u5b8c\u6210\u5b89\u88dd mariaDB \u4e26\u555f\u52d5\u9060\u7aef\u8a2a\u554f\u8cc7\u6599\u5eab
\n\u4f7f\u7528\u6642\u767c\u73fe[Err]1055 \u932f\u8aa4 MySql\u8cc7\u6599\u5eab\u9810\u8a2d\u70ba SET sql_mode = ‘ONLY_FULL_GROUP_BY’ \u6c92\u6709\u4f7f\u7528\u7fa4\u7d44\u51fd\u5f0f\u7684\u6b04\u4f4d\uff0c\u4e00\u5b9a\u8981\u5168\u90e8\u51fa\u73fe\u5728 GROUP BY \u5b50\u53e5\u4e2d\uff0c\u5982\u679c\u5b8c\u53cd\u6b64\u898f \u5b9a\uff0c\u5373\u6703\u51fa\u73fe [Err] 1055 – Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column \u6216 which is not in SELECT list; this is incompatible with DISTINCT \u932f\u8aa4\u8a0a\u606f \u89e3\u6c7a\u65b9\u5f0f\u53c3\u8003\u8cc7\u6599 https:\/\/stackoverflow.com\/questions\/28849293\/how-to-make-sql-mode-noengine-substitution-permanent-in-mysql-my-cnf
\nhttps:\/\/op46.com\/#\/technique\/9d356df3e82bfb349528808758a3d734.html http:\/\/www.codedata.com.tw\/database\/mysql-tutorial-4-expressionfunction\/ http:\/\/www.ywnds.com\/?p=8184 http:\/\/blog.elfjane.com\/?p=277 https:\/\/blog.csdn.net\/Inite\/article\/details\/78087039 https:\/\/blog.csdn.net\/S_gy_Zetrov\/article\/details\/65937999 https:\/\/tjosm.com\/5266\/disable-strict-mode-mysql-5-7-ubuntu-16-04\/
\n\u66ab\u6642\u6027\u7684\u8655\u7406\uff0c\u4f7f\u7528 MySql \u8a9e\u6cd5 SET sql_mode=(SELECT REPLACE(@@sql_mode,’ONLY_FULL_GROUP_BY’,”)); \u6c38\u4e45\u7684\u8655\u7406\u65b9\u6cd5\uff0c\u4fee\u6539 MySql\u8a2d\u5b9a\u6587\u4ef6,my.ini\uff08windows\uff09\u6216 my.cnf\uff08linux\uff09\u4ef6 \u627e\u5230 sql_mode \u4e2d\u6ce8\u91ca\uff08\u53bb\u6389\uff09only_full_group_by \u6216\u52a0\u4e0a(BP-20170101 \u5e74\u524d\u958b\u767c\u7cfb\u7d71\u5e95\u5c64\u7248\u672c) ======\u6587\u4ef6\u5167\u5bb9==== #\u8a2d\u5b9a\u8a9e\u6cd5\u9806\u5e8f [mysqld] sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION ======\u6587\u4ef6\u5167\u5bb9==== \u67e5\u770b SQL_MODE \u8a9e\u6cd5 SELECT @@sql_mode;
\n\u4e09\uff1a\u5b89\u88dd\u5b89\u88dd Apach2 \u4f86\u5efa\u7acb\u7db2\u9801\u74b0\u5883(\u4f7f\u7528 phpmyadmin \u524d\u7f6e) \u53c3\u8003\u8cc7\u6599\uff1a https:\/\/www.howtoing.com\/how-to-install-the-apache-web-server-on-ubuntu-1604 https:\/\/www.howtoing.com\/how-to-install-linux-apache-mysql-php-lamp-stackonubuntu16-04\/ https:\/\/magiclen.org\/lamp\/ http:\/\/www.arthurtoday.com\/2010\/04\/lamp-server-apache-mysql-php.html https:\/\/linux.cn\/article-7463-1.html https:\/\/blog.csdn.net\/zhaihaifei\/article\/details\/51659134 http:\/\/jsnwork.kiiuo.com\/archives\/2505\/ubuntu-%E5%AE%89%E8%A3%9D-php7apache-mysqlmariadb-phpmyadmin http:\/\/foanwang.pixnet.net\/blog\/post\/39951347-linux-lamp-phpmyadmin%E8%A8%AD%E5%AE%9A%E4%B9%8B%E4%BB%80%E9%BA%BC%E9%AC%BC %E5%95%8F%E9%A1%8C%E9%83%BD%E7%A2%B0%E5%88%B0%E4%BA%86-o
\n\u5b89\u88dd Apach2 \u5237\u65b0 apt-get ubuntu \u6307\u4ee4\uff1asudo apt-get update
\n\u5b89\u88dd Apach2 ubuntu \u6307\u4ee4\uff1asudo apt-get install apache2 \u958b\u555f apach2 ubuntu \u6307\u4ee4\uff1asystemctl start apache2
\n\u95dc\u9589 apach2 ubuntu \u6307\u4ee4\uff1asudo systemctl stop apache2
\n\u91cd\u555f apach2 ubuntu \u6307\u4ee4\uff1asudo systemctl restart apache2
\n\u7cfb\u7d71\u6aa2\u67e5 Apach2 \u662f\u5426\u904b\u4f5c ubuntu \u6307\u4ee4\uff1asudo systemctl status apache2
\n\u53d6\u5f97 IP\u4f4d\u5740 ubuntu \u6307\u4ee4\uff1ahostname -I \u5728\u5340\u7db2\u958b\u555f\u700f\u89bd\u5668\u8f38\u5165 IP \u4f4d\u5740\u6216\u672c\u6a5f\u7aef\u8f38\u5165 localhost \u6216 127.0.0.1 \u9a57\u8b49
\n\u56db\uff1a\u5b89\u88dd php&phpmyadmin \u53c3\u8003\u8cc7\u6599\uff1a https:\/\/linux.cn\/article-7463-1.html http:\/\/jsnwork.kiiuo.com\/archives\/2505\/ubuntu-%E5%AE%89%E8%A3%9D-php7apache-mysqlmariadb-phpmyadmin
\nphpadmin \u5fc5\u9808\u5728 php \u74b0\u5883\u4e0b\u9032\u884c\uff0c\u6545\u9808\u5148\u5b89\u88dd php
\n\u5b89\u88dd php7.0 ubuntu \u6307\u4ee4\uff1asudo apt install php7.0-mysql php7.0-curl php7.0-json php7.0-cgi php7.0 libapache2-mod-php7.0
\n\u5275\u5efa\u4e00\u500b\u7c21\u55ae\u7684 php\u9801\u9762\uff0c\u4e26\u79fb\u52d5\u5230 apache \u6a94\u6848\u76ee\u9304\u4e0b\uff08\/var\/www\/html\uff09 ubuntu \u6307\u4ee4\uff1asudo vim samplepage.php
\nvi \u6587\u4ef6\u5167\u5bb9\u7a0b\u5f0f\u78bc\uff1a <?php phpinfo(); ?>
\n\u79fb\u52d5\u5230 apach \u7684\u6587\u4ef6\u76ee\u9304\u4e0b ubuntu \u6307\u4ee4\uff1asudo mv samplepage.php \/var\/www\/html\/
\n\u7528\u700f\u89bd\u5668\u8a2a\u554f\u9801\u9762\uff0c\u5982\u6210\u529f\u53ef\u770b\u898b php\u7248\u672c\u8aaa\u660e \u201chttp:\/\/<IP \u4f4d\u5740>\/samplepage.php\u201d
\n\u5b89\u88dd phpmyadmin\uff0c\u6ce8\u610f phpmyadmin \u9810\u8a2d\u662f\u9023\u7dda\u81f3 127.0.01\u6216 localhost \u672c\u6a5f\u7aef ubuntu \u6307\u4ee4\uff1aapt install phpmyadmin
\n\u9032\u5165 phpmyadmin \u5b89\u88dd\u8a2d\u5b9a\uff0c\u9078\u64c7 apache2
\n\u9ede\u64ca\u78ba\u5b9a\u4f86\u914d\u7f6e phpmyadmin \u7ba1\u7406\u7684\u8cc7\u6599\u5eab
\n\u6307\u5b9a phpmyadmin \u9023\u7dda\u81f3\u8cc7\u6599\u5eab\u7684\u5bc6\u78bc
\n\u91cd\u8907\u78ba\u8a8d\u5bc6\u78bc
\n\u6253\u958b\u700f\u89bd\u5668\uff0c\u8f38\u5165\u4f4d\u5740\u8a2a\u554f phpmyadmin
\nhttp:\/\/<Server_IP_OR_Host_Name>\/phpmyadmin
\n\u5982\u679c\u7121\u6cd5\u767b\u9678\uff0c\u6aa2\u67e5\u8a2d\u5b9a\u6a94\u72c0\u614b \u53c3\u8003\u8cc7\u6599\uff1a https:\/\/blog.csdn.net\/l6807718\/article\/details\/51374915
\n\u5efa\u7acb\/var\/www\/html \u4e0b\u7684\u8edf\u9023\u63a5\/\u91cd\u5b9a\u5411 ubuntu \u6307\u4ee4\uff1asudo ln -s \/usr\/share\/phpmyadmin \/var\/www\/html\/phpmyadmin
\n\u4fee\u6539 php \u914d\u7f6e\u6587\u4ef6 ubuntu \u6307\u4ee4\uff1asudo vim \/etc\/php\/7.0\/apache2\/php.ini \u6587\u4ef6\u5167\u5bb9\uff1a display_errors = On(\u986f\u793a\u932f\u8aa4\u65e5\u8a8c\uff0c\u51fa\u73fe\u5169\u6b21\u7372\u591a\u6b21\u90fd\u8981\u6539) extension=php_mbstring.dll (\u958b\u555f mbstring)
\n\u63d0\u9192\uff1avim \u67e5\u8a62\u6307\u4ee4\uff1a\/XXX \u5411\u4e0b\u67e5\u8a62 \/?\u5411\u4e0a\u67e5\u8a62
\n\u91cd\u555f apach ubuntu \u6307\u4ee4\uff1asudo \/etc\/init.d\/apache2 restart
\n\u91cd\u9ede\u63d0\u793a\uff1a \u9ed8\u8a8d\u5b89\u88dd phpmyadmin \u6642\u6703\u5b89\u88dd apache \u548c php\u7b49\u76f8\u95dc\u7a0b\u5f0f\uff0cubuntu16.04 \u6703\u9ed8\u8a8d\u5b89 \u88dd php7.0\uff0cphp7.0 \u6c92\u6709\u81ea\u5e36 php-mbstring\uff0cphp-gettext \u6587\u4ef6\u5305\uff0c\u6240\u4ee5\u6703\u51fa\u932f\u3002
\n\u4e94\uff1aip \u963b\u64cb\/\u57fa\u672c\u9632\u706b\u7246\u8a2d\u5b9a \u53c3\u8003\u8cc7\u6599\uff1ahttp:\/\/s2.naes.tn.edu.tw\/~kv\/iptables.htm
\n\u89c0\u5bdf\u76ee\u524d\u7684\u8a2d\u5b9a-\u7bc4\u4f8b\u70ba\u5168\u90e8\u901a\u904e ubuntu \u6307\u4ee4\uff1aiptables -L -n \u56de\u8986\u5167\u5bb9\uff1a Chain INPUT (policy ACCEPT) target prot opt source destination Chain FORWARD (policy ACCEPT) target prot opt source destination Chain OUTPUT (policy ACCEPT) target prot opt source destination
\nubuntu \u6307\u4ee4\uff1aiptables -t nat -L -n \u56de\u8986\u5167\u5bb9\uff1a Chain PREROUTING (policy ACCEPT) target prot opt source destination Chain POSTROUTING (policy ACCEPT) target prot opt source destination Chain OUTPUT (policy ACCEPT) target prot opt source destination
\n\u4f86\u81ea 192.168.0.1 \u9019\u500b IP \u7684\u5c01\u5305\u90fd\u4e88\u4ee5\u63a5\u53d7\uff1a ubuntu \u6307\u4ee4\uff1aiptables -A INPUT -i eth0 -p tcp -s 192.168.0.1 -j ACCEPT
\n\u4f86\u81ea 192.168.1.0 \u9019\u500b C Class \u7684\u7db2\u57df\u7684\u4efb\u4f55\u4e00\u90e8\u96fb\u8166\uff0c\u5c31\u4e88\u4ee5\u63a5\u53d7\uff01 ubuntu \u6307\u4ee4\uff1aiptables -A INPUT -i eth0 -p tcp -s 192.168.1.0\/24 -j ACCEPT
\n192.168.1.25 \u7684\u5c01\u5305\u90fd\u7d66\u4ed6\u4e1f\u68c4\u53bb\uff01 ubuntu \u6307\u4ee4\uff1aiptables -A INPUT -i eth0 -p tcp -s 192.168.1.25 -j DROP
\n192.168.0.24 \u9019\u500b IP \u7684\u5c01\u5305\uff0c\u60f3\u8981\u5230\u6211\u7684 137,138,139 \u57e0\u53e3\u6642\uff0c\u90fd\u63a5\u53d7 ubuntu \u6307\u4ee4\uff1aiptables -A INPUT -i eth0 -p tcp -s 192.168.0.24\/24 –dport 137:139j ACCEPT
\n\u8a2d\u5b9a\u5340\u7db2\u56fa\u5b9a ip\uff1a \u53c3\u8003\u6587\u4ef6\uff1a http:\/\/n198862320.pixnet.net\/blog\/post\/35199621-ubuntu%E8%A8%AD%E5%AE %9A%E5%9B%BA%E5%AE%9Aip%E6%96%B9%E6%B3%95 https:\/\/www.phpini.com\/linux\/ubuntu-setup-static-ip https:\/\/www.albert-yu.com\/2018\/01\/ubuntu-16-04-%E8%A8%AD%E5%AE%9A %E5%9B%BA%E5%AE%9Aip\/ https:\/\/blog.csdn.net\/greyfreedom\/article\/details\/41943713 http:\/\/52iot.net\/tw\/book\/Linux\/69.html
\n\u4fee\u6539 interfaces \u6a94 ubuntu \u6307\u4ee4\uff1asudo vim \/etc\/network\/interfaces
\n\u6587\u4ef6\u5167\u5bb9\uff1b auto lo # auto eth0 iface eth0 inet static # \u56fa\u5b9a eth0 \u7db2\u5361 (\u975c\u614b) IP address 192.168.1.100 # IP \u4f4d\u5740 netmask 255.255.255.0 # \u7db2\u8def\u906e\u7f69 gateway 192.168.1.1 # \u9810\u8a2d\u9598\u9053\uff0c\u5c0d\u5916\u7db2\u8def\u7531\u4f4d\u5740 dns-nameservers 168.95.1.1 #DNS \u7b2c\u4e00\u7d44 hinet dns-nameservers 8.8.8.8 #DNS \u7b2c\u4e8c\u7d44 google ~ ~ ~
\n\u8a2d\u5b9a\u6a94\u5982\u679c\u7121\u6548\uff0c\u53ef\u4f7f\u7528 ifconfig \u624b\u52d5\u8a2d\u5b9a ubuntu \u6307\u4ee4\uff1asudo ifconfig eth0 192.168.1.100 netmask 255.255.255.0
\n\u55ae\u7368\u95dc\u9589\u7db2\u8def\u5361 ubuntu \u6307\u4ee4\uff1aifconfig eth0 down
\n\u55ae\u7368\u958b\u555f\u7db2\u8def\u5361 ubuntu \u6307\u4ee4\uff1aifconfig eth0 up
\n\u8a2d\u5b9a\u5b8c\u7562\u4e4b\u5f8c\uff0c\u91cd\u65b0\u555f\u52d5\u7db2\u8def\u4ecb\u9762 ubuntu \u6307\u4ee4\uff1asudo \/etc\/init.d\/network restart
\n\u91cd\u555f\u5f8c\u6aa2\u67e5 IP\u662f\u5426\u6b63\u78ba ubuntu \u6307\u4ee4\uff1asudo ifconfig eth0
\n\u6aa2\u67e5\u8def\u7531\u8a2d\u5b9a ubuntu \u6307\u4ee4\uff1asudo route -n
\n\u6e2c\u8a66\u8def\u7531\u4e4b\u9593\u9023\u7dda ubuntu \u6307\u4ee4\uff1asudo ping -c 3 <\u8def\u7531 IP>
\n\u63d0\u9192\uff1a\u7bc4\u4f8b\u70ba\u624b\u52d5\u9010\u6b65\u5b89\u88dd\uff0c\u53ef\u76f4\u63a5\u5b89\u88dd XAMAPP \u7b49\u5de5\u5177<\/p>\n","protected":false},"excerpt":{"rendered":"