{"id":3878,"date":"2019-04-01T00:12:48","date_gmt":"2019-03-31T16:12:48","guid":{"rendered":"http:\/\/switch.linesno.com\/?p=3878"},"modified":"2019-04-02T22:55:51","modified_gmt":"2019-04-02T14:55:51","slug":"04_mysql%e7%bd%91%e7%bb%9c%e5%ae%89%e8%a3%85","status":"publish","type":"post","link":"http:\/\/switch.linesno.com\/?p=3878","title":{"rendered":"04_MySQL\u7f51\u7edc\u5b89\u88c5"},"content":{"rendered":"<h2>\u8bf4\u660e<\/h2>\n<ol>\n<li>\u5047\u8bbe\u5b89\u88c5\u7684\u670d\u52a1\u5668\u4e3a:123.1.1.1<\/li>\n<\/ol>\n<p><strong>\u91c7\u8d2d\u4e86\u767e\u5ea6\u4e91\u670d\u52a1\u5668\uff0c\u53d1\u73b0\uff0c\u4f53\u9a8c\u592a\u5dee\u4e86\uff0c\u63a8\u8350\u8fd8\u662f\u963f\u91cc\u4e91<\/strong><\/p>\n<h2>\u5b89\u88c5 Mysql<\/h2>\n<blockquote><p>\u5b89\u88c5\u8fc7\u7a0b\u4f7f\u7528root\u64cd\u4f5c<\/p><\/blockquote>\n<ol>\n<li>\u5b89\u88c5\u4f9d\u8d56\u8f6f\u4ef6<\/li>\n<\/ol>\n<pre><code class=\"language-bash \">sudo yum install -y cmake , make , gcc , gcc-c++ , bison , ncurses , ncurses-devel\n<\/code><\/pre>\n<ol start=\"2\">\n<li>\u6dfb\u52a0\u5e93<br \/>\nvim \/etc\/yum.repos.d\/MariaDB.repo<\/li>\n<li>\u6dfb\u52a0\u6570\u636e\u6e90<\/li>\n<\/ol>\n<blockquote><p>\u7cfb\u7edf\u53ca\u7248\u672c\u9009\u62e9\uff1ahttps:\/\/downloads.mariadb.org\/mariadb\/repositories\/#mirror=tuna<\/p><\/blockquote>\n<pre><code class=\"\"># MariaDB 10.3 CentOS repository list - created 2019-03-29 02:33 UTC\n# http:\/\/downloads.mariadb.org\/mariadb\/repositories\/\n[mariadb]\nname = MariaDB\nbaseurl = http:\/\/yum.mariadb.org\/10.3\/centos7-amd64\ngpgkey=https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB\ngpgcheck=1\n<\/code><\/pre>\n<p>\u6e05\u7406yum\u7f13\u5b58<\/p>\n<pre><code class=\"\">yum clean headers  #\u6e05\u7406\/var\/cache\/yum\u7684headers\nyum clean packages #\u6e05\u7406\/var\/cache\/yum\u4e0b\u7684\u8f6f\u4ef6\u5305\nyum clean metadata\n\nyum clean all   #\u6e05\u9664Yum\u7f13\u5b58\nyum makecache   #\u628a\u670d\u52a1\u5668\u7684\u5305\u4fe1\u606f\u4e0b\u8f7d\u5230\u672c\u5730\u7535\u8111\u7f13\u5b58\u8d77\u6765\nyum update   #\u5347\u7ea7\u5305\u540c\u65f6\u4e5f\u5347\u7ea7\u8f6f\u4ef6\u548c\u7cfb\u7edf\u5185\u6838\n<\/code><\/pre>\n<p>\u91ca\u653e\u5185\u5b58<\/p>\n<pre><code class=\"\">sync; echo 2 &gt; \/proc\/sys\/vm\/drop_caches\nsync; echo 3 &gt; \/proc\/sys\/vm\/drop_caches\n\nfree -m    #\u67e5\u770b\u5185\u5b58\n<\/code><\/pre>\n<ol start=\"4\">\n<li>\u5b89\u88c5mariadb<\/li>\n<\/ol>\n<pre><code class=\"\">yum -y install MariaDB-server MariaDB-client\n<\/code><\/pre>\n<ol start=\"5\">\n<li>\u542f\u52a8\u6570\u636e\u5e93<\/li>\n<\/ol>\n<pre><code class=\"\">systemctl restart mariadb\nsystemctl status mariadb\n\n<\/code><\/pre>\n<p>\u5047\u5982\u5bc6\u7801\u5fd8\u8bb0:<br \/>\n\u4fee\u6539\/etc\/my.cnf\u6587\u4ef6,\u5728[mysqld]\u4e0b\u6dfb\u52a0 skip-grant-tables , \u518d\u542f\u52a8mariadb<\/p>\n<pre><code class=\"\">[client-server]\n\n# [mysqld]\n# skip-grant-tables\n\n#\n# include all files from the config directory\n#\n!includedir \/etc\/my.cnf.d\n<\/code><\/pre>\n<ol start=\"6\">\n<li>\u767b\u9646<\/li>\n<\/ol>\n<pre><code class=\"\">mysql\n\n\/\/ \u5b89\u5168\u914d\u7f6e\nmysql_secure_installation\n<\/code><\/pre>\n<p>\u6dfb\u52a0\u9632\u706b\u5899<\/p>\n<pre><code class=\"\">sudo firewall-cmd --zone=public --permanent --add-service=mysql\nsudo systemctl restart firewalld\n<\/code><\/pre>\n<ol start=\"6\">\n<li>\u91cd\u7f6e\u5bc6\u7801<\/li>\n<\/ol>\n<pre><code class=\"\">\/\/ \u91cd\u542f\u670d\u52a1\nsystemctl restart mysqld\nsystemctl status mysqld\n<\/code><\/pre>\n<ol start=\"7\">\n<li>\u91cd\u7f6e\u5bc6\u7801<\/li>\n<\/ol>\n<pre><code class=\"\">mysql -uroot -p\nuse mysql;\nupdate user set password=password('HouGuiYu@123!@#') where user='root' ;\n<\/code><\/pre>\n<ol start=\"8\">\n<li>\u5f00\u542f\u8fdc\u7a0b\u8bbf\u95ee<\/li>\n<\/ol>\n<pre><code class=\"\">mysql -uroot -p\n\n\/\/ %\u8868\u793a\u662f\u6240\u6709\u7684\u5916\u90e8\u673a\u5668\uff0c\u5982\u679c\u6307\u5b9a\u67d0\u4e00\u53f0\u673a\uff0c\u5c31\u5c06%\u6539\u4e3a\u76f8\u5e94\u7684\u673a\u5668\u540d\uff1b\u2018root\u2019\u5219\u662f\u6307\u8981\u4f7f\u7528\u7684\u7528\u6237\u540d\ngrant all privileges on *.* to 'root'@'%' identified by 'HouGuiYu@123!@#' with grant option;\n\n\/\/ \u8fd0\u884c\u6b64\u53e5\u624d\u751f\u6548\uff0c\u6216\u8005\u91cd\u542fMySQL\nflush privileges;\n<\/code><\/pre>\n<h2>\u5b89\u88c5phpadmin<\/h2>\n<blockquote><p>mysql\u7684\u754c\u9762\u7ba1\u7406\u5de5\u5177\uff0c\u7528\u4e8emysql\u7684\u53ef\u89c6\u5316\u7ba1\u7406<\/p><\/blockquote>\n<ol>\n<li>\u5b89\u88c5\u4f9d\u8d56\u5305<\/li>\n<\/ol>\n<pre><code class=\"\">yum -y install httpd php php-fpm php-mysql\n<\/code><\/pre>\n<ol start=\"2\">\n<li>\u5347\u7ea7php<\/li>\n<\/ol>\n<pre><code class=\"\">rpm -Uvh https:\/\/mirror.webtatic.com\/yum\/el7\/epel-release.rpm #\u66f4\u65b0\u6e90\nrpm -Uvh https:\/\/mirror.webtatic.com\/yum\/el7\/webtatic-release.rpm\nyum remove php-common -y  #\u79fb\u9664\u7cfb\u7edf\u81ea\u5e26\u7684php-common\nyum install -y php72w php72w-opcache php72w-xml php72w-mcrypt php72w-gd php72w-devel php72w-mysql php72w-intl php72w-mbstring  #\u5b89\u88c5\u4f9d\u8d56\u5305\n<\/code><\/pre>\n<ol start=\"3\">\n<li>\u5b89\u88c5apache<\/li>\n<\/ol>\n<pre><code class=\"\">\/\/ \u5b89\u88c5\nyum install httpd\n\n\/\/ \u91cd\u542f\nsystemctl restart httpd\n\n\/\/ \u67e5\u770b\u8fd0\u884c\u72b6\u6001\nsystemctl status httpd\n<\/code><\/pre>\n<p>\u8bbf\u95ee\u5730\u5740:http:\/\/123.1.1.1\/<\/p>\n<ol start=\"4\">\n<li>\u5b89\u88c5phpadmin<\/li>\n<\/ol>\n<blockquote><p>\u6b64\u9700\u8fdb\u5165\u76ee\u5f55 \/var\/www\/html \u76ee\u5f55\u64cd\u4f5c<\/p><\/blockquote>\n<pre><code class=\"\">\/\/ \u4e0b\u8f7dphpadmin\nwget https:\/\/files.phpmyadmin.net\/phpMyAdmin\/4.8.5\/phpMyAdmin-4.8.5-all-languages.zip\n\n\/\/ \u89e3\u538b\nunzip phpMyAdmin-4.8.5-all-languages.zip\n<\/code><\/pre>\n<ol start=\"3\">\n<li>\u4fee\u6539\u540d\u79f0<\/li>\n<\/ol>\n<pre><code class=\"\">mv phpMyAdmin-4.8.5-all-languages phpMyAdmin\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u8bf4\u660e \u5047\u8bbe\u5b89\u88c5\u7684\u670d\u52a1\u5668\u4e3a:123.1.1.1 \u91c7\u8d2d\u4e86\u767e\u5ea6\u4e91\u670d\u52a1\u5668\uff0c\u53d1\u73b0\uff0c\u4f53\u9a8c\u592a\u5dee\u4e86\uff0c\u63a8\u8350\u8fd8\u662f\u963f\u91cc\u4e91 \u5b89\u88c5 My [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[94,92],"tags":[],"class_list":["post-3878","post","type-post","status-publish","format-standard","hentry","category-08_mysql","category-alinesno-cloud-service"],"_links":{"self":[{"href":"http:\/\/switch.linesno.com\/index.php?rest_route=\/wp\/v2\/posts\/3878","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/switch.linesno.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/switch.linesno.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/switch.linesno.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/switch.linesno.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3878"}],"version-history":[{"count":5,"href":"http:\/\/switch.linesno.com\/index.php?rest_route=\/wp\/v2\/posts\/3878\/revisions"}],"predecessor-version":[{"id":3893,"href":"http:\/\/switch.linesno.com\/index.php?rest_route=\/wp\/v2\/posts\/3878\/revisions\/3893"}],"wp:attachment":[{"href":"http:\/\/switch.linesno.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3878"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/switch.linesno.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3878"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/switch.linesno.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3878"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}