{"id":2251,"date":"2017-05-20T00:08:24","date_gmt":"2017-05-19T16:08:24","guid":{"rendered":"http:\/\/cn.hostease.com\/xueyuan\/?p=2251"},"modified":"2017-05-20T00:08:24","modified_gmt":"2017-05-19T16:08:24","slug":"centos7%e4%b8%8b%e9%85%8d%e7%bd%aephpmyadmin%e6%8f%90%e4%be%9bhttps%e6%9c%8d%e5%8a%a1","status":"publish","type":"post","link":"https:\/\/cn.hostease.com\/xueyuan\/uncategorized\/centos7%e4%b8%8b%e9%85%8d%e7%bd%aephpmyadmin%e6%8f%90%e4%be%9bhttps%e6%9c%8d%e5%8a%a1\/","title":{"rendered":"Centos7\u4e0b\u914d\u7f6ephpMyAdmin(\u63d0\u4f9bHTTPS\u670d\u52a1)"},"content":{"rendered":"<h1>Centos7\u4e0b\u914d\u7f6ephpMyAdmin(\u63d0\u4f9bHTTPS\u670d\u52a1)<\/h1>\n<p><img decoding=\"async\" style=\"border-width: 0px; padding: 0px; margin: 0px;\" src=\"https:\/\/pic.baike.soso.com\/ugc\/baikepic\/34291\/cut-20140312155714-709118046.jpg\/0\" alt=\"0\" \/><\/p>\n<blockquote><p>phpMyAdmin\u53ef\u4ee5\u901a\u8fc7web\u65b9\u5f0f\u63a7\u5236\u548c\u64cd\u4f5cMySQL\u6570\u636e\u5e93\u3002\u901a\u8fc7phpMyAdmin \u53ef\u4ee5\u5b8c\u5168\u5bf9\u6570\u636e\u5e93\u8fdb\u884c\u64cd\u4f5c\uff0c\u4f8b\u5982\u5efa\u7acb\u3001\u590d\u5236\u548c\u5220\u9664\u6570\u636e\u7b49\u7b49\u3002<\/p><\/blockquote>\n<h2>\u914d\u7f6e\u73af\u5883<\/h2>\n<ul class=\"list-paddingleft-2\">\n<li>Centos7 2\u53f0\uff08IP1:192.168.70 ; IP2:192.168.1.71\uff09<\/li>\n<li>\u5173\u95ed\u9632\u706b\u5899<\/li>\n<li>\u5173\u95edselinux<\/li>\n<li>\u76f8\u5173\u8f6f\u4ef6\uff1a\n<pre>php-5.4.16\r\nphp-mbstring-5.4.16\u00a0\u00a0\r\nhttpd-2.4.6-45\r\nmariadb-server\r\nphp-mysql-5.4.16\r\nphpMyAdmin-4.4.14.1-all-languages.zip\r\nmod_ssl-2.4.6-45<\/pre>\n<\/li>\n<\/ul>\n<h3>\u914d\u7f6ehttps\u73af\u5883(192.168.1.70)<\/h3>\n<pre>#yum\u00a0-y\u00a0install\u00a0httpd\u00a0php\u00a0php-mysql\u00a0mariadb-server\r\n#\u65b0\u5efa\u4e00\u4e2a\u9875\u9762\uff0c\u6d4b\u8bd5PHP\r\n#\u00a0cat\u00a0\/var\/www\/html\/index.php\u00a0\r\n\u00a0&lt;?php\r\n\u00a0\u00a0phpinfo();\r\n\u00a0?&gt;\r\n#\u00a0systemctl\u00a0start\u00a0httpd.service\r\n#\u00a0systemctl\u00a0start\u00a0mariadb.service\r\n#\u00a0\u67e5\u770b\u7aef\u53e3\uff08\u670d\u52a1\u662f\u5426\u8d77\u6765\uff09\r\n#ss\u00a0-tnl\u00a0\u00a0\u00a0\u00a0\r\n#\u5728\u6d4f\u89c8\u5668\u4e2d\u8f93\u5165192.168.70\u67e5\u770b\u751f\u6210\u7684PHP\u6d4b\u8bd5\u9875\u9762<\/pre>\n<h3>\u5efa\u7acb\u79c1\u6709CA<\/h3>\n<blockquote><p>CA:\u7b7e\u8bc1\u673a\u6784\uff1b RA\uff1a\u6ce8\u518c\u673a\u6784\uff1bCRL:\u8bc1\u4e66\u540a\u9500\u5217\u8868<\/p><\/blockquote>\n<p><strong>\u8bc1\u4e66\u7533\u8bf7\u53ca\u7b7e\u7f72\u6b65\u9aa4\uff1a<\/strong>\u00a0\u751f\u6210\u8bc1\u4e66\u7533\u8bf7\u8bf7\u6c42&#8211;&gt;RA\u6821\u9a8c&#8211;&gt;CA\u7b7e\u7f72&#8211;&gt;\u83b7\u5f97\u8bc1\u4e66<\/p>\n<p><em>\u57fa\u4e8e192.168.1.71<\/em><\/p>\n<pre>#\u00a0cd\u00a0\/etc\/pki\/CA\/\r\n#(umask\u00a0077;openssl\u00a0genrsa\u00a0-out\u00a0private\/cakey.pem\u00a02048)\r\n#\u00a0touch\u00a0index.txt\r\n#\u00a0echo\u00a001\u00a0&gt;\u00a0serial\r\n#\u81ea\u7b7e\u8bc1\u4e66\r\n#\u00a0openssl\u00a0req\u00a0-x509\u00a0-key\u00a0\u00a0private\/cakey.pem\u00a0-days\u00a07300\u00a0-out\u00a0\/etc\/pki\/CA\/cacert.pem\r\n-----\r\nCountry\u00a0Name\u00a0(2\u00a0letter\u00a0code)\u00a0[XX]:CN\r\nState\u00a0or\u00a0Province\u00a0Name\u00a0(full\u00a0name)\u00a0[]:BEIJING\r\nLocality\u00a0Name\u00a0(eg,\u00a0city)\u00a0[Default\u00a0City]:BEIJING\r\nOrganization\u00a0Name\u00a0(eg,\u00a0company)\u00a0[Default\u00a0Company\u00a0Ltd]:JIAJIE\r\nOrganizational\u00a0Unit\u00a0Name\u00a0(eg,\u00a0section)\u00a0[]:OPS\r\nCommon\u00a0Name\u00a0(eg,\u00a0your\u00a0name\u00a0or\u00a0your\u00a0server's\u00a0hostname)\u00a0[]:jiajiez.com\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\nEmail\u00a0Address\u00a0[]:jiajie@126.com\r\n#\u540e\u9762\u7684\u8bf7\u6c42\u9700\u8981\u548c\u8fd9\u91cc\u7684\u56fd\u5bb6\u57ce\u5e02\u4e00\u81f4<\/pre>\n<h3>\u751f\u6210\u8bc1\u4e66\u7b7e\u7f72\u8bf7\u6c42<\/h3>\n<p><em>\u57fa\u4e8e192.168.1.70<\/em><\/p>\n<pre>#\u00a0mkdir\u00a0\/etc\/httpd\/ssl\r\n#\u00a0cd\u00a0ssl\r\n#\u00a0(umask\u00a0077;openssl\u00a0genrsa\u00a0-out\u00a0\/etc\/httpd\/ssl\/httpd.key\u00a02048)\r\n#\u00a0openssl\u00a0req\u00a0-new\u00a0-key\u00a0\/etc\/httpd\/ssl\/httpd.key\u00a0-out\u00a0\/etc\/httpd\/ssl\/httpd.csr\r\n#\u8fd9\u91cc\u7533\u8bf7\u683c\u5f0f\u7684\u56fd\u5bb6\u57ce\u5e02\u5e94\u548c\u4e0a\u9762\u7684\u4e00\u81f4\r\n#\u5c06\u8bc1\u4e66\u53d1\u9001\u7ed9CA\r\n#\u00a0scp\u00a0httpd.csr\u00a0root@192.168.1.71:\/tmp\/<\/pre>\n<p><em>\u57fa\u4e8e192.168.1.71<\/em><\/p>\n<pre>#CA\u7b7e\u7f72\u8bc1\u4e66\u5e76\u5c06\u53d1\u8fd8\u7ed9\u8bf7\u6c42\u516c\u53f8\r\n#\u00a0openssl\u00a0ca\u00a0-in\u00a0\/tmp\/httpd.csr\u00a0-out\u00a0\/etc\/pki\/CA\/certs\/web1.jiajie.com.crt\u00a0-days\u00a0365\r\n#\u00a0scp\u00a0certs\/web1.jiajie.com.crt\u00a0root@192.168.1.70:\/etc\/httpd\/ssl<\/pre>\n<p>\u914d\u7f6eHTTPS\u652f\u6301ssl\u53ca\u4f7f\u7528\u8bc1\u4e66(\u57fa\u4e8e192.168.1.70)<\/p>\n<pre>#\u00a0yum\u00a0-y\u00a0install\u00a0mod_ssl\r\n#\u4fee\u6539\u914d\u7f6e\u6587\u4ef6\r\n#\u00a0vim\u00a0\/etc\/httpd\/conf.d\/ssl.conf\u00a0\r\nDocumentRoot\u00a0\"\/var\/www\/html\"\r\nServerName\u00a0web1.jiajie.com:443\r\nSSLCertificateFile\u00a0\/etc\/httpd\/ssl\/web1.jiajie.com.crt\r\nSSLCertificateKeyFile\u00a0\/etc\/httpd\/ssl\/httpd.key\r\n#\u00a0systemctl\u00a0reload\u00a0httpd.service\r\n#\u67e5\u770b443\u7aef\u53e3\u662f\u5426\u542f\u52a8\r\n#\u00a0ssl\u00a0-tnl<\/pre>\n<blockquote><p>\u8fd9\u4e2a\u65f6\u5019\u4f60\u53ef\u4ee5\u5c06CA\u7684\u8bc1\u4e66<code>cacert.pem<\/code>\u53d1\u9001\u5230Windows\u5ba2\u6237\u7aef\uff0c\u4fee\u6539\u5176\u540e\u7f00\u540d\u79f0\u4e3a\u00a0<code>.crt<\/code>,\u7136\u540e\u5c06\u8be5\u8bc1\u4e66\u5b89\u88c5\u5728\u8bc1\u4e66\u5217\u8868\u91cc\u3002\u5c06<code>192.168.1.70 web1.jaijie.com<\/code>\u653e\u5230Windows\u5ba2\u6237\u7aef\u7684hosts\u6587\u4ef6\u91cc\u3002\u5c31\u53ef\u4ee5\u5728\u6d4f\u89c8\u5668\u91cc\u57fa\u4e8eHTTPS\u8bbf\u95eeweb1\u670d\u52a1\u5668\u4e86\u3002<\/p><\/blockquote>\n<h3>\u5b89\u88c5phpMyAdmin<\/h3>\n<pre>#wget\u00a0https:\/\/files.phpmyadmin.net\/phpMyAdmin\/4.4.14.1\/phpMyAdmin-4.4.14.1-all-languages.zip\r\n#unzip\u00a0phpMyAdmin-4.4.14.1-all-languages.zip\u00a0-d\u00a0\/var\/www\/html\/\r\n#cd\u00a0\/var\/www\/html\r\n#mv\u00a0phpMyAdmin-4.4.14.1-all-languages\u00a0phpmyadmin\r\n#cd\u00a0phpmyadmin\r\n#cp\u00a0config.sample.inc.php\u00a0config.inc.php\r\n#\u00a0\u6253\u5f00\u914d\u7f6e\u6587\u4ef6\uff0c\u5728\u4e0b\u9762\u7684\u5206\u53f7\u91cc\u9762\u586b\u5165\u968f\u673a\u6570\u00a0\r\n#\u00a0vim\u00a0\/var\/www\/html\/phpmyadmin\/config.inc.php\u00a0\r\n$cfg['blowfish_secret']\u00a0=\u00a0'4fzsmEIOLHYeAaeoGHgn3dFkE+kXgwqKvgd2dS3u';\u00a0\/*\u00a0YOU\u00a0MUST\u00a0FILL\u00a0IN\u00a0THIS\u00a0FOR\u00a0COOKIE\u00a0AUTH!\u00a0*\/\r\n#\u968f\u673a\u6570\u7684\u4ea7\u751f\u65b9\u6cd5\uff1a#\u00a0openssl\u00a0rand\u00a0-base64\u00a025<\/pre>\n<blockquote><p>\u8fd9\u65f6\u5019\u6253\u5f00\u6d4f\u89c8\u5668\u8bbf\u95eehttps:\/\/web1.jiajie.com\/phpmyadmin\/\u53d1\u73b0\u4ee5\u4e0b\u62a5\u9519\uff1a<\/p><\/blockquote>\n<pre>phpMyAdmin\u00a0-\u00a0Error\r\nThe\u00a0mbstring\u00a0extension\u00a0is\u00a0missing.\u00a0Please\u00a0check\u00a0your\u00a0PHP\u00a0configuration.\u6ca1\u6709\u5b89\u88c5mbstring,\u00a0yum\u00a0-y\u00a0install\u00a0php-mbstring\u5373\u53ef\u3002<\/pre>\n<p>\u7136\u540e\u91cd\u65b0\u8bbf\u95ee\u7f51\u7ad9\u5c31\u53ef\u4ee5\u8fdb\u5165 phpmyadmin\u7684\u767b\u9646\u9875\u9762\u4e86\u3002<\/p>\n<p><a href=\"https:\/\/cn.hostease.com\/xueyuan\/wp-content\/uploads\/2017\/05\/image.png\" rel=\"attachment wp-att-2252\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2252\" src=\"https:\/\/cn.hostease.com\/xueyuan\/wp-content\/uploads\/2017\/05\/image-300x256.png\" alt=\"image\" width=\"300\" height=\"256\" srcset=\"https:\/\/cn.hostease.com\/xueyuan\/wp-content\/uploads\/2017\/05\/image-300x256.png 300w, https:\/\/cn.hostease.com\/xueyuan\/wp-content\/uploads\/2017\/05\/image.png 501w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>\u63a5\u4e0b\u6765\u521b\u5efa\u767b\u9646\u8d26\u53f7\u548c\u5bc6\u7801\uff1a<\/p>\n<pre>#mysql\r\nMariaDB\u00a0[(none)]&gt;\u00a0SET\u00a0PASSWORD\u00a0FOR\u00a0'root'@'localhost'=PASSWORD('jiajie');\r\nMariaDB\u00a0[(none)]&gt;\u00a0SET\u00a0PASSWORD\u00a0FOR\u00a0'root'@'127.0.0.1'=PASSWORD('jiajie');\r\nMariaDB\u00a0[(none)]&gt;\u00a0FLUSH\u00a0PRIVILEGES;<\/pre>\n<p>\u4f7f\u7528root\u8d26\u53f7\u548c\u5bc6\u7801\uff1ajiajie \u5c31\u53ef\u4ee5\u767b\u9646\u4e86\u3002<\/p>\n<p><a href=\"https:\/\/cn.hostease.com\/xueyuan\/wp-content\/uploads\/2017\/05\/image-1.png\" rel=\"attachment wp-att-2253\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2253\" src=\"https:\/\/cn.hostease.com\/xueyuan\/wp-content\/uploads\/2017\/05\/image-1-300x152.png\" alt=\"image\" width=\"300\" height=\"152\" srcset=\"https:\/\/cn.hostease.com\/xueyuan\/wp-content\/uploads\/2017\/05\/image-1-300x152.png 300w, https:\/\/cn.hostease.com\/xueyuan\/wp-content\/uploads\/2017\/05\/image-1.png 492w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Centos7\u4e0b\u914d\u7f6ephpMyAdmin(\u63d0\u4f9bHTTPS\u670d\u52a1) phpMyAdmin\u53ef\u4ee5\u901a\u8fc7web\u65b9\u5f0f\u63a7\u5236\u548c\u64cd &#8230; <a title=\"Centos7\u4e0b\u914d\u7f6ephpMyAdmin(\u63d0\u4f9bHTTPS\u670d\u52a1)\" class=\"read-more\" href=\"https:\/\/cn.hostease.com\/xueyuan\/uncategorized\/centos7%e4%b8%8b%e9%85%8d%e7%bd%aephpmyadmin%e6%8f%90%e4%be%9bhttps%e6%9c%8d%e5%8a%a1\/\" aria-label=\"\u9605\u8bfb Centos7\u4e0b\u914d\u7f6ephpMyAdmin(\u63d0\u4f9bHTTPS\u670d\u52a1)\">\u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":1,"featured_media":2252,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[82,299],"class_list":["post-2251","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-centos","tag-phpmyadmin"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/cn.hostease.com\/xueyuan\/wp-content\/uploads\/2017\/05\/image.png","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/2251","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/comments?post=2251"}],"version-history":[{"count":1,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/2251\/revisions"}],"predecessor-version":[{"id":2254,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/2251\/revisions\/2254"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/media\/2252"}],"wp:attachment":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/media?parent=2251"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/categories?post=2251"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/tags?post=2251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}