{"id":214,"date":"2015-10-21T12:27:12","date_gmt":"2015-10-21T04:27:12","guid":{"rendered":"http:\/\/cn.hostease.com\/xueyuan\/?p=214"},"modified":"2024-12-31T14:57:28","modified_gmt":"2024-12-31T06:57:28","slug":"phpmyadmin4-4-7%e5%ae%89%e8%a3%85%e5%8f%8a%e9%85%8d%e7%bd%ae","status":"publish","type":"post","link":"https:\/\/cn.hostease.com\/xueyuan\/jishu\/shujuku\/phpmyadmin4-4-7%e5%ae%89%e8%a3%85%e5%8f%8a%e9%85%8d%e7%bd%ae\/","title":{"rendered":"phpMyAdmin4.4.7\u5b89\u88c5\u53ca\u914d\u7f6e"},"content":{"rendered":"\n

\u73af\u5883\u8bf4\u660e\uff1a<\/strong><\/p>\n\n\n\n

\u7cfb\u7edf\u7248\u672c\uff1acentos 6.6 32bit<\/p>\n\n\n\n

\u8f6f\u4ef6\u7248\u672c\uff1amysql 5.6.25 \u3001nginx1.6.2 \u3001 php5.4.37 LNMP\u67b6\u6784<\/p>\n\n\n\n

\u8bf4\u660e\uff1amysql5.5\u7248\u672c\u4ee5\u4e0a\u9700\u8981\u4f7f\u7528phpmyadmin4.4\u7248\u672c\u4ee5\u4e0a\uff1b<\/strong><\/p>\n\n\n\n

\u6b65\u9aa4\u5982\u4e0b\uff1a<\/strong><\/p>\n\n\n\n

# unzip phpMyAdmin-4.4.7-all-languages.zip<\/p>\n\n\n\n

# mv phpMyAdmin-4.4.7-all-languages\/* \/usr\/local\/nginx\/html\/phpmyadmin\/<\/p>\n\n\n\n

# cd \/usr\/local\/nginx\/html\/phpmyadmin\/<\/p>\n\n\n\n

# cp config.sample.inc.php config.inc.php<\/p>\n\n\n\n

\u6d4f\u89c8\u5668\u8bbf\u95ee 192.168.20.5\/phpmyadmin<\/strong>
\u4f7f\u7528root\u7528\u6237\uff0c\u5bc6\u7801\u4e3amysql\u5bc6\u7801\u767b\u5f55\uff1b<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

\u62a5\u9519\u5982\u4e0b\u56fe\uff1a<\/strong>\u65e0\u6cd5\u767b\u5f55MySQL\u670d\u52a1\u5668\uff1b<\/strong><\/p>\n\n\n\n

\u51fa\u73b0\u8fd9\u4e2a\u9519\u8bef\uff0c\u8868\u793a\u6ca1\u6709\u8fde\u63a5\u5230\u6570\u636e\u5e93<\/strong><\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

<\/p>\n\n\n\n

\u89e3\u51b3\u65b9\u6cd5\uff1a<\/strong><\/p>\n\n\n\n

# vi config.inc.php<\/p>\n\n\n\n

\u627e\u5230\u8fd9\u4e00\u884c    $cfg[‘Servers’][$i][‘host’] = ‘localhost’;<\/p>\n\n\n\n

\u4fee\u6539\u4e3a\uff1a$cfg[‘Servers’][$i][‘host’] = ‘127.0.0.1<\/strong>‘;<\/p>\n\n\n\n

\u91cd\u65b0\u8fde\u63a5\u5c31\u767b\u5f55\u8fdb\u53bb\u4e86\uff1b<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

nginx\u865a\u62df\u4e3b\u673a\u914d\u7f6e\u5982\u4e0b\uff1a<\/strong><\/p>\n\n\n\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n<\/td>\n
\n
\n
# cat \/usr\/local\/nginx\/conf\/vhosts\/default.conf <\/code><\/div>\n
server<\/code><\/div>\n
{<\/code><\/div>\n
    <\/code>listen 80;<\/code><\/div>\n
    <\/code>server_name 192.168.20.5;<\/code><\/div>\n
    <\/code>index index.html index.htm index.php;<\/code><\/div>\n
    <\/code>root <\/code>\/usr\/local\/nginx\/html<\/code>;<\/code><\/div>\n
    <\/code><\/div>\n
    <\/code>location ~ \\.php$ {<\/code><\/div>\n
    <\/code>include fastcgi_params;<\/code><\/div>\n
    <\/code>fastcgi_pass unix:<\/code>\/tmp\/php-fcgi<\/code>.sock;<\/code><\/div>\n
    <\/code>fastcgi_index index.php;<\/code><\/div>\n
    <\/code>fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;<\/code><\/div>\n
    <\/code>}<\/code><\/div>\n
}<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n\n\n\n

php-fpm\u914d\u7f6e\u5982\u4e0b\uff1a<\/strong><\/p>\n\n\n\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n<\/td>\n
\n
\n
# cat \/usr\/local\/php\/etc\/php-fpm.conf<\/code><\/div>\n
[global]<\/code><\/div>\n
pid = <\/code>\/usr\/local\/php\/var\/run\/php-fpm<\/code>.pid<\/code><\/div>\n
error_log = <\/code>\/usr\/local\/php\/var\/log\/php-fpm<\/code>.log<\/code><\/div>\n
[www]<\/code><\/div>\n
user = php-fpm<\/code><\/div>\n
group = php-fpm<\/code><\/div>\n
listen = <\/code>\/tmp\/php-fcgi<\/code>.sock<\/code><\/div>\n
listen.mode = 0666<\/code><\/div>\n
pm = dynamic<\/code><\/div>\n
pm.max_children = 50<\/code><\/div>\n
pm.start_servers = 20<\/code><\/div>\n
pm.min_spare_servers = 5<\/code><\/div>\n
pm.max_spare_servers = 35<\/code><\/div>\n
pm.max_requests = 500<\/code><\/div>\n
rlimit_files = 1024<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\u73af\u5883\u8bf4\u660e\uff1a \u7cfb\u7edf\u7248\u672c\uff1acentos 6.6 32bit \u8f6f\u4ef6\u7248\u672c\uff1amysql 5.6.25 \u3001nginx1.6 … \u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[10],"tags":[45,61],"class_list":["post-214","post","type-post","status-publish","format-standard","hentry","category-shujuku","tag-mysql","tag-phpadmin4-4-7"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/214","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=214"}],"version-history":[{"count":3,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/214\/revisions"}],"predecessor-version":[{"id":8682,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/214\/revisions\/8682"}],"wp:attachment":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/media?parent=214"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/categories?post=214"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/tags?post=214"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}