{"id":294,"date":"2009-12-31T20:08:04","date_gmt":"2009-12-31T12:08:04","guid":{"rendered":"http:\/\/amjet.dyndns.biz\/blog\/IT\/?p=294"},"modified":"2013-03-01T19:49:55","modified_gmt":"2013-03-01T11:49:55","slug":"%e8%a8%ad%e5%ae%9a-phpmyadmin-%e7%ae%a1%e7%90%86%e5%a4%9a%e7%b5%84-mysql-%e4%bc%ba%e6%9c%8d%e5%99%a8","status":"publish","type":"post","link":"https:\/\/blog.amjet.biz\/IT\/?p=294","title":{"rendered":"\u8a2d\u5b9a phpMyAdmin \u7ba1\u7406\u591a\u7d44 MySQL \u4f3a\u670d\u5668"},"content":{"rendered":"<p><a href=\"http:\/\/www.phpmyadmin.net\" target=\"_blank\">phpMyAdmin<\/a> \u662f\u4e00\u7d44\u76f8\u7576\u65b9\u4fbf\u7684 MySQL \u4f3a\u670d\u5668\u7ba1\u7406\u5de5\u5177\uff0c\u5b89\u88dd\u90e8\u4efd Fedora\u3001CentOS\u3001Ubuntu \u90fd\u6709\u73fe\u6210\u7684\u5957\u4ef6\u4e86\uff0c\u53ea\u8981\u4fee\u6539 apache \u7684\u8a2d\u5b9a\u6a94\uff0c\u6307\u5b9a\u5141\u8a31\u9023\u7dda\u7684 IP \u5373\u53ef\u3002\u6700\u8fd1\u6709\u7ba1\u7406\u591a\u7d44 MySQL \u7684\u9700\u6c42\uff0c\u9806\u4fbf\u8a18\u9304\u4e00\u4e0b\u8a2d\u5b9a\u7684\u65b9\u6cd5\u3002<\/p>\n<p>mySQL \u4f3a\u670d\u5668\u6709 production\u3001development \u90192\u53f0\uff0c\u4ee5 Fedora\u3001CentOS \u70ba\u4f8b\uff0c\u8a2d\u5b9a\u6a94\u5728 \/etc\/phpMyAdmin \u76ee\u9304\u4e0b\u3002<\/p>\n<p>\u9996\u5148\u628a config.inc.php \u8907\u88fd 2 \u4efd\uff0c\u5206\u5225\u662f config.production.php \u3001 config.development.php \uff0c\u90192\u500b\u6a94\u6848\u53ea\u5305\u542b\u5404\u5225\u4f3a\u670d\u5668\u8a2d\u5b9a\uff0c\u5927\u81f4\u5167\u5bb9\u5982\u4e0b\uff1a<\/p>\n<p>&lt;?php<br \/>\n$i++;<br \/>\n$cfg[&#8216;Servers&#8217;][$i][&#8216;host&#8217;]\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = &#8216;192.168.1.10;<\/p>\n<p>.<\/p>\n<p>.<\/p>\n<p>?&gt;<\/p>\n<p>\u7136\u5f8c\u5c07 config.inc.php \u63db\u6210\u4ee5\u4e0b\u7a0b\u5f0f\u78bc\uff1a<\/p>\n<p>&lt;?php<br \/>\n$i = 0;<br \/>\n$cfg[&#8216;blowfish_secret&#8217;] = &#8216;mysecret&#8217;;<br \/>\n\/**<br \/>\n* Server(s) configuration<br \/>\n*\/<br \/>\nrequire_once(&#8216;config.production.php&#8217;);<br \/>\nrequire_once(&#8216;config.development.php&#8217;);<\/p>\n<p>?&gt;<\/p>\n<p>\u9019\u6a23\u4ee5\u5f8c\u8981\u518d\u589e\u52a0 mySQL \u4f3a\u670d\u5668\u6642\uff0c\u53ea\u8981\u628a config.production.php \u8907\u88fd\u4e00\u4efd\uff0c\u6839\u64da\u65b0\u4f3a\u670d\u5668\u8cc7\u6599\u4fee\u6539\u5167\u5bb9\uff0cconfig.inc.php \u518d\u65b0\u589e\u4e00\u884c require_once \u5373\u53ef\u3002<\/p>\n<p><strong>[ratings]<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>phpMyAdmin \u662f\u4e00\u7d44\u76f8\u7576\u65b9\u4fbf\u7684 MySQL \u4f3a\u670d\u5668\u7ba1\u7406\u5de5\u5177\uff0c\u5b89\u88dd\u90e8\u4efd Fedora\u3001CentOS\u3001Ubuntu \u90fd\u6709\u73fe\u6210\u7684\u5957\u4ef6\u4e86\uff0c\u53ea\u8981\u4fee\u6539 apache \u7684\u8a2d\u5b9a\u6a94\uff0c\u6307\u5b9a\u5141\u8a31\u9023\u7dda\u7684 IP \u5373\u53ef\u3002\u6700\u8fd1\u6709\u7ba1\u7406\u591a\u7d44 MySQL \u7684\u9700\u6c42\uff0c\u9806\u4fbf\u8a18\u9304\u4e00\u4e0b\u8a2d\u5b9a\u7684\u65b9\u6cd5\u3002 mySQL \u4f3a\u670d\u5668\u6709 production\u3001development \u90192\u53f0\uff0c\u4ee5 Fedora\u3001CentOS \u70ba\u4f8b\uff0c\u8a2d\u5b9a\u6a94\u5728 \/etc\/phpMyAdmin \u76ee\u9304\u4e0b\u3002 \u9996\u5148\u628a config.inc.php \u8907\u88fd 2 \u4efd\uff0c\u5206\u5225\u662f config.production.php \u3001 config.development.php \uff0c\u90192\u500b\u6a94\u6848\u53ea\u5305\u542b\u5404\u5225\u4f3a\u670d\u5668\u8a2d\u5b9a\uff0c\u5927\u81f4\u5167\u5bb9\u5982\u4e0b\uff1a &lt;?php $i++; $cfg[&#8216;Servers&#8217;][$i][&#8216;host&#8217;]\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = &#8216;192.168.1.10; . . ?&gt; \u7136\u5f8c\u5c07 config.inc.php \u63db\u6210\u4ee5\u4e0b\u7a0b\u5f0f\u78bc\uff1a &lt;?php $i = 0; $cfg[&#8216;blowfish_secret&#8217;] = &#8216;mysecret&#8217;; \/** * Server(s) configuration *\/ require_once(&#8216;config.production.php&#8217;); require_once(&#8216;config.development.php&#8217;); ?&gt; [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[26,27],"class_list":["post-294","post","type-post","status-publish","format-standard","hentry","category-other","tag-mysql","tag-phpmyadmin"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"phpMyAdmin \u662f\u4e00\u7d44\u76f8\u7576\u65b9\u4fbf\u7684 MySQL \u4f3a\u670d\u5668\u7ba1\u7406\u5de5\u5177\uff0c\u5b89\u88dd\u90e8\u4efd Fedora\u3001CentOS\u3001Ubuntu \u90fd\u6709\u73fe\u6210\u7684\u5957\u4ef6\u4e86\uff0c\u53ea\u8981\u4fee\u6539 apache \u7684\u8a2d\u5b9a\u6a94\uff0c\u6307\u5b9a\u5141\u8a31\u9023\u7dda\u7684 IP \u5373\u53ef\u3002\u6700\u8fd1\u6709\u7ba1\u7406\u591a\u7d44 MySQL \u7684\u9700\u6c42\uff0c\u9806\u4fbf\u8a18\u9304\u4e00\u4e0b\u8a2d\u5b9a\u7684\u65b9\u6cd5\u3002 mySQL \u4f3a\u670d\u5668\u6709 production\u3001development \u90192\u53f0\uff0c\u4ee5 Fedora\u3001CentOS \u70ba\u4f8b\uff0c\u8a2d\u5b9a\u6a94\u5728 \/etc\/phpMyAdmin \u76ee\u9304\u4e0b\u3002 \u9996\u5148\u628a config.inc.php \u8907\u88fd 2 \u4efd\uff0c\u5206\u5225\u662f config.production.php \u3001 config.development.php \uff0c\u90192\u500b\u6a94\u6848\u53ea\u5305\u542b\u5404\u5225\u4f3a\u670d\u5668\u8a2d\u5b9a\uff0c\u5927\u81f4\u5167\u5bb9\u5982\u4e0b\uff1a\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"vincent\"\/>\n\t<meta name=\"keywords\" content=\"mysql,phpmyadmin\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/blog.amjet.biz\/IT\/?p=294\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"AmJet IT Blog | for IT professionals\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\u8a2d\u5b9a phpMyAdmin \u7ba1\u7406\u591a\u7d44 MySQL \u4f3a\u670d\u5668 | AmJet IT Blog\" \/>\n\t\t<meta property=\"og:description\" content=\"phpMyAdmin \u662f\u4e00\u7d44\u76f8\u7576\u65b9\u4fbf\u7684 MySQL \u4f3a\u670d\u5668\u7ba1\u7406\u5de5\u5177\uff0c\u5b89\u88dd\u90e8\u4efd Fedora\u3001CentOS\u3001Ubuntu \u90fd\u6709\u73fe\u6210\u7684\u5957\u4ef6\u4e86\uff0c\u53ea\u8981\u4fee\u6539 apache \u7684\u8a2d\u5b9a\u6a94\uff0c\u6307\u5b9a\u5141\u8a31\u9023\u7dda\u7684 IP \u5373\u53ef\u3002\u6700\u8fd1\u6709\u7ba1\u7406\u591a\u7d44 MySQL \u7684\u9700\u6c42\uff0c\u9806\u4fbf\u8a18\u9304\u4e00\u4e0b\u8a2d\u5b9a\u7684\u65b9\u6cd5\u3002 mySQL \u4f3a\u670d\u5668\u6709 production\u3001development \u90192\u53f0\uff0c\u4ee5 Fedora\u3001CentOS \u70ba\u4f8b\uff0c\u8a2d\u5b9a\u6a94\u5728 \/etc\/phpMyAdmin \u76ee\u9304\u4e0b\u3002 \u9996\u5148\u628a config.inc.php \u8907\u88fd 2 \u4efd\uff0c\u5206\u5225\u662f config.production.php \u3001 config.development.php \uff0c\u90192\u500b\u6a94\u6848\u53ea\u5305\u542b\u5404\u5225\u4f3a\u670d\u5668\u8a2d\u5b9a\uff0c\u5927\u81f4\u5167\u5bb9\u5982\u4e0b\uff1a\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/blog.amjet.biz\/IT\/?p=294\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2009-12-31T12:08:04+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2013-03-01T11:49:55+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"\u8a2d\u5b9a phpMyAdmin \u7ba1\u7406\u591a\u7d44 MySQL \u4f3a\u670d\u5668 | AmJet IT Blog\" \/>\n\t\t<meta name=\"twitter:description\" content=\"phpMyAdmin \u662f\u4e00\u7d44\u76f8\u7576\u65b9\u4fbf\u7684 MySQL \u4f3a\u670d\u5668\u7ba1\u7406\u5de5\u5177\uff0c\u5b89\u88dd\u90e8\u4efd Fedora\u3001CentOS\u3001Ubuntu \u90fd\u6709\u73fe\u6210\u7684\u5957\u4ef6\u4e86\uff0c\u53ea\u8981\u4fee\u6539 apache \u7684\u8a2d\u5b9a\u6a94\uff0c\u6307\u5b9a\u5141\u8a31\u9023\u7dda\u7684 IP \u5373\u53ef\u3002\u6700\u8fd1\u6709\u7ba1\u7406\u591a\u7d44 MySQL \u7684\u9700\u6c42\uff0c\u9806\u4fbf\u8a18\u9304\u4e00\u4e0b\u8a2d\u5b9a\u7684\u65b9\u6cd5\u3002 mySQL \u4f3a\u670d\u5668\u6709 production\u3001development \u90192\u53f0\uff0c\u4ee5 Fedora\u3001CentOS \u70ba\u4f8b\uff0c\u8a2d\u5b9a\u6a94\u5728 \/etc\/phpMyAdmin \u76ee\u9304\u4e0b\u3002 \u9996\u5148\u628a config.inc.php \u8907\u88fd 2 \u4efd\uff0c\u5206\u5225\u662f config.production.php \u3001 config.development.php \uff0c\u90192\u500b\u6a94\u6848\u53ea\u5305\u542b\u5404\u5225\u4f3a\u670d\u5668\u8a2d\u5b9a\uff0c\u5927\u81f4\u5167\u5bb9\u5982\u4e0b\uff1a\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/?p=294#article\",\"name\":\"\\u8a2d\\u5b9a phpMyAdmin \\u7ba1\\u7406\\u591a\\u7d44 MySQL \\u4f3a\\u670d\\u5668 | AmJet IT Blog\",\"headline\":\"\\u8a2d\\u5b9a phpMyAdmin \\u7ba1\\u7406\\u591a\\u7d44 MySQL \\u4f3a\\u670d\\u5668\",\"author\":{\"@id\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/?author=2#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/#organization\"},\"datePublished\":\"2009-12-31T20:08:04+08:00\",\"dateModified\":\"2013-03-01T19:49:55+08:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/?p=294#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/?p=294#webpage\"},\"articleSection\":\"Other, mysql, phpmyadmin\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/?p=294#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.amjet.biz\\\/IT#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/?cat=9#listItem\",\"name\":\"System\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/?cat=9#listItem\",\"position\":2,\"name\":\"System\",\"item\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/?cat=9\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/?cat=18#listItem\",\"name\":\"Other\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.amjet.biz\\\/IT#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/?cat=18#listItem\",\"position\":3,\"name\":\"Other\",\"item\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/?cat=18\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/?p=294#listItem\",\"name\":\"\\u8a2d\\u5b9a phpMyAdmin \\u7ba1\\u7406\\u591a\\u7d44 MySQL \\u4f3a\\u670d\\u5668\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/?cat=9#listItem\",\"name\":\"System\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/?p=294#listItem\",\"position\":4,\"name\":\"\\u8a2d\\u5b9a phpMyAdmin \\u7ba1\\u7406\\u591a\\u7d44 MySQL \\u4f3a\\u670d\\u5668\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/?cat=18#listItem\",\"name\":\"Other\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/#organization\",\"name\":\"AmJet Digital\",\"description\":\"for IT professionals\",\"url\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/?author=2#author\",\"url\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/?author=2\",\"name\":\"vincent\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/?p=294#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/8c6bcd6e8e7e1c9bce74184354da4a5c294d71657c7abc161841c4799d1b1a46?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"vincent\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/?p=294#webpage\",\"url\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/?p=294\",\"name\":\"\\u8a2d\\u5b9a phpMyAdmin \\u7ba1\\u7406\\u591a\\u7d44 MySQL \\u4f3a\\u670d\\u5668 | AmJet IT Blog\",\"description\":\"phpMyAdmin \\u662f\\u4e00\\u7d44\\u76f8\\u7576\\u65b9\\u4fbf\\u7684 MySQL \\u4f3a\\u670d\\u5668\\u7ba1\\u7406\\u5de5\\u5177\\uff0c\\u5b89\\u88dd\\u90e8\\u4efd Fedora\\u3001CentOS\\u3001Ubuntu \\u90fd\\u6709\\u73fe\\u6210\\u7684\\u5957\\u4ef6\\u4e86\\uff0c\\u53ea\\u8981\\u4fee\\u6539 apache \\u7684\\u8a2d\\u5b9a\\u6a94\\uff0c\\u6307\\u5b9a\\u5141\\u8a31\\u9023\\u7dda\\u7684 IP \\u5373\\u53ef\\u3002\\u6700\\u8fd1\\u6709\\u7ba1\\u7406\\u591a\\u7d44 MySQL \\u7684\\u9700\\u6c42\\uff0c\\u9806\\u4fbf\\u8a18\\u9304\\u4e00\\u4e0b\\u8a2d\\u5b9a\\u7684\\u65b9\\u6cd5\\u3002 mySQL \\u4f3a\\u670d\\u5668\\u6709 production\\u3001development \\u90192\\u53f0\\uff0c\\u4ee5 Fedora\\u3001CentOS \\u70ba\\u4f8b\\uff0c\\u8a2d\\u5b9a\\u6a94\\u5728 \\\/etc\\\/phpMyAdmin \\u76ee\\u9304\\u4e0b\\u3002 \\u9996\\u5148\\u628a config.inc.php \\u8907\\u88fd 2 \\u4efd\\uff0c\\u5206\\u5225\\u662f config.production.php \\u3001 config.development.php \\uff0c\\u90192\\u500b\\u6a94\\u6848\\u53ea\\u5305\\u542b\\u5404\\u5225\\u4f3a\\u670d\\u5668\\u8a2d\\u5b9a\\uff0c\\u5927\\u81f4\\u5167\\u5bb9\\u5982\\u4e0b\\uff1a\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/?p=294#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/?author=2#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/?author=2#author\"},\"datePublished\":\"2009-12-31T20:08:04+08:00\",\"dateModified\":\"2013-03-01T19:49:55+08:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/#website\",\"url\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/\",\"name\":\"AmJet IT Blog\",\"description\":\"for IT professionals\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/blog.amjet.biz\\\/IT\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\u8a2d\u5b9a phpMyAdmin \u7ba1\u7406\u591a\u7d44 MySQL \u4f3a\u670d\u5668 | AmJet IT Blog","description":"phpMyAdmin \u662f\u4e00\u7d44\u76f8\u7576\u65b9\u4fbf\u7684 MySQL \u4f3a\u670d\u5668\u7ba1\u7406\u5de5\u5177\uff0c\u5b89\u88dd\u90e8\u4efd Fedora\u3001CentOS\u3001Ubuntu \u90fd\u6709\u73fe\u6210\u7684\u5957\u4ef6\u4e86\uff0c\u53ea\u8981\u4fee\u6539 apache \u7684\u8a2d\u5b9a\u6a94\uff0c\u6307\u5b9a\u5141\u8a31\u9023\u7dda\u7684 IP \u5373\u53ef\u3002\u6700\u8fd1\u6709\u7ba1\u7406\u591a\u7d44 MySQL \u7684\u9700\u6c42\uff0c\u9806\u4fbf\u8a18\u9304\u4e00\u4e0b\u8a2d\u5b9a\u7684\u65b9\u6cd5\u3002 mySQL \u4f3a\u670d\u5668\u6709 production\u3001development \u90192\u53f0\uff0c\u4ee5 Fedora\u3001CentOS \u70ba\u4f8b\uff0c\u8a2d\u5b9a\u6a94\u5728 \/etc\/phpMyAdmin \u76ee\u9304\u4e0b\u3002 \u9996\u5148\u628a config.inc.php \u8907\u88fd 2 \u4efd\uff0c\u5206\u5225\u662f config.production.php \u3001 config.development.php \uff0c\u90192\u500b\u6a94\u6848\u53ea\u5305\u542b\u5404\u5225\u4f3a\u670d\u5668\u8a2d\u5b9a\uff0c\u5927\u81f4\u5167\u5bb9\u5982\u4e0b\uff1a","canonical_url":"https:\/\/blog.amjet.biz\/IT\/?p=294","robots":"max-image-preview:large","keywords":"mysql,phpmyadmin","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.amjet.biz\/IT\/?p=294#article","name":"\u8a2d\u5b9a phpMyAdmin \u7ba1\u7406\u591a\u7d44 MySQL \u4f3a\u670d\u5668 | AmJet IT Blog","headline":"\u8a2d\u5b9a phpMyAdmin \u7ba1\u7406\u591a\u7d44 MySQL \u4f3a\u670d\u5668","author":{"@id":"https:\/\/blog.amjet.biz\/IT\/?author=2#author"},"publisher":{"@id":"https:\/\/blog.amjet.biz\/IT\/#organization"},"datePublished":"2009-12-31T20:08:04+08:00","dateModified":"2013-03-01T19:49:55+08:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/blog.amjet.biz\/IT\/?p=294#webpage"},"isPartOf":{"@id":"https:\/\/blog.amjet.biz\/IT\/?p=294#webpage"},"articleSection":"Other, mysql, phpmyadmin"},{"@type":"BreadcrumbList","@id":"https:\/\/blog.amjet.biz\/IT\/?p=294#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/blog.amjet.biz\/IT#listItem","position":1,"name":"Home","item":"https:\/\/blog.amjet.biz\/IT","nextItem":{"@type":"ListItem","@id":"https:\/\/blog.amjet.biz\/IT\/?cat=9#listItem","name":"System"}},{"@type":"ListItem","@id":"https:\/\/blog.amjet.biz\/IT\/?cat=9#listItem","position":2,"name":"System","item":"https:\/\/blog.amjet.biz\/IT\/?cat=9","nextItem":{"@type":"ListItem","@id":"https:\/\/blog.amjet.biz\/IT\/?cat=18#listItem","name":"Other"},"previousItem":{"@type":"ListItem","@id":"https:\/\/blog.amjet.biz\/IT#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/blog.amjet.biz\/IT\/?cat=18#listItem","position":3,"name":"Other","item":"https:\/\/blog.amjet.biz\/IT\/?cat=18","nextItem":{"@type":"ListItem","@id":"https:\/\/blog.amjet.biz\/IT\/?p=294#listItem","name":"\u8a2d\u5b9a phpMyAdmin \u7ba1\u7406\u591a\u7d44 MySQL \u4f3a\u670d\u5668"},"previousItem":{"@type":"ListItem","@id":"https:\/\/blog.amjet.biz\/IT\/?cat=9#listItem","name":"System"}},{"@type":"ListItem","@id":"https:\/\/blog.amjet.biz\/IT\/?p=294#listItem","position":4,"name":"\u8a2d\u5b9a phpMyAdmin \u7ba1\u7406\u591a\u7d44 MySQL \u4f3a\u670d\u5668","previousItem":{"@type":"ListItem","@id":"https:\/\/blog.amjet.biz\/IT\/?cat=18#listItem","name":"Other"}}]},{"@type":"Organization","@id":"https:\/\/blog.amjet.biz\/IT\/#organization","name":"AmJet Digital","description":"for IT professionals","url":"https:\/\/blog.amjet.biz\/IT\/"},{"@type":"Person","@id":"https:\/\/blog.amjet.biz\/IT\/?author=2#author","url":"https:\/\/blog.amjet.biz\/IT\/?author=2","name":"vincent","image":{"@type":"ImageObject","@id":"https:\/\/blog.amjet.biz\/IT\/?p=294#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/8c6bcd6e8e7e1c9bce74184354da4a5c294d71657c7abc161841c4799d1b1a46?s=96&d=mm&r=g","width":96,"height":96,"caption":"vincent"}},{"@type":"WebPage","@id":"https:\/\/blog.amjet.biz\/IT\/?p=294#webpage","url":"https:\/\/blog.amjet.biz\/IT\/?p=294","name":"\u8a2d\u5b9a phpMyAdmin \u7ba1\u7406\u591a\u7d44 MySQL \u4f3a\u670d\u5668 | AmJet IT Blog","description":"phpMyAdmin \u662f\u4e00\u7d44\u76f8\u7576\u65b9\u4fbf\u7684 MySQL \u4f3a\u670d\u5668\u7ba1\u7406\u5de5\u5177\uff0c\u5b89\u88dd\u90e8\u4efd Fedora\u3001CentOS\u3001Ubuntu \u90fd\u6709\u73fe\u6210\u7684\u5957\u4ef6\u4e86\uff0c\u53ea\u8981\u4fee\u6539 apache \u7684\u8a2d\u5b9a\u6a94\uff0c\u6307\u5b9a\u5141\u8a31\u9023\u7dda\u7684 IP \u5373\u53ef\u3002\u6700\u8fd1\u6709\u7ba1\u7406\u591a\u7d44 MySQL \u7684\u9700\u6c42\uff0c\u9806\u4fbf\u8a18\u9304\u4e00\u4e0b\u8a2d\u5b9a\u7684\u65b9\u6cd5\u3002 mySQL \u4f3a\u670d\u5668\u6709 production\u3001development \u90192\u53f0\uff0c\u4ee5 Fedora\u3001CentOS \u70ba\u4f8b\uff0c\u8a2d\u5b9a\u6a94\u5728 \/etc\/phpMyAdmin \u76ee\u9304\u4e0b\u3002 \u9996\u5148\u628a config.inc.php \u8907\u88fd 2 \u4efd\uff0c\u5206\u5225\u662f config.production.php \u3001 config.development.php \uff0c\u90192\u500b\u6a94\u6848\u53ea\u5305\u542b\u5404\u5225\u4f3a\u670d\u5668\u8a2d\u5b9a\uff0c\u5927\u81f4\u5167\u5bb9\u5982\u4e0b\uff1a","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/blog.amjet.biz\/IT\/#website"},"breadcrumb":{"@id":"https:\/\/blog.amjet.biz\/IT\/?p=294#breadcrumblist"},"author":{"@id":"https:\/\/blog.amjet.biz\/IT\/?author=2#author"},"creator":{"@id":"https:\/\/blog.amjet.biz\/IT\/?author=2#author"},"datePublished":"2009-12-31T20:08:04+08:00","dateModified":"2013-03-01T19:49:55+08:00"},{"@type":"WebSite","@id":"https:\/\/blog.amjet.biz\/IT\/#website","url":"https:\/\/blog.amjet.biz\/IT\/","name":"AmJet IT Blog","description":"for IT professionals","inLanguage":"en-US","publisher":{"@id":"https:\/\/blog.amjet.biz\/IT\/#organization"}}]},"og:locale":"en_US","og:site_name":"AmJet IT Blog | for IT professionals","og:type":"article","og:title":"\u8a2d\u5b9a phpMyAdmin \u7ba1\u7406\u591a\u7d44 MySQL \u4f3a\u670d\u5668 | AmJet IT Blog","og:description":"phpMyAdmin \u662f\u4e00\u7d44\u76f8\u7576\u65b9\u4fbf\u7684 MySQL \u4f3a\u670d\u5668\u7ba1\u7406\u5de5\u5177\uff0c\u5b89\u88dd\u90e8\u4efd Fedora\u3001CentOS\u3001Ubuntu \u90fd\u6709\u73fe\u6210\u7684\u5957\u4ef6\u4e86\uff0c\u53ea\u8981\u4fee\u6539 apache \u7684\u8a2d\u5b9a\u6a94\uff0c\u6307\u5b9a\u5141\u8a31\u9023\u7dda\u7684 IP \u5373\u53ef\u3002\u6700\u8fd1\u6709\u7ba1\u7406\u591a\u7d44 MySQL \u7684\u9700\u6c42\uff0c\u9806\u4fbf\u8a18\u9304\u4e00\u4e0b\u8a2d\u5b9a\u7684\u65b9\u6cd5\u3002 mySQL \u4f3a\u670d\u5668\u6709 production\u3001development \u90192\u53f0\uff0c\u4ee5 Fedora\u3001CentOS \u70ba\u4f8b\uff0c\u8a2d\u5b9a\u6a94\u5728 \/etc\/phpMyAdmin \u76ee\u9304\u4e0b\u3002 \u9996\u5148\u628a config.inc.php \u8907\u88fd 2 \u4efd\uff0c\u5206\u5225\u662f config.production.php \u3001 config.development.php \uff0c\u90192\u500b\u6a94\u6848\u53ea\u5305\u542b\u5404\u5225\u4f3a\u670d\u5668\u8a2d\u5b9a\uff0c\u5927\u81f4\u5167\u5bb9\u5982\u4e0b\uff1a","og:url":"https:\/\/blog.amjet.biz\/IT\/?p=294","article:published_time":"2009-12-31T12:08:04+00:00","article:modified_time":"2013-03-01T11:49:55+00:00","twitter:card":"summary","twitter:title":"\u8a2d\u5b9a phpMyAdmin \u7ba1\u7406\u591a\u7d44 MySQL \u4f3a\u670d\u5668 | AmJet IT Blog","twitter:description":"phpMyAdmin \u662f\u4e00\u7d44\u76f8\u7576\u65b9\u4fbf\u7684 MySQL \u4f3a\u670d\u5668\u7ba1\u7406\u5de5\u5177\uff0c\u5b89\u88dd\u90e8\u4efd Fedora\u3001CentOS\u3001Ubuntu \u90fd\u6709\u73fe\u6210\u7684\u5957\u4ef6\u4e86\uff0c\u53ea\u8981\u4fee\u6539 apache \u7684\u8a2d\u5b9a\u6a94\uff0c\u6307\u5b9a\u5141\u8a31\u9023\u7dda\u7684 IP \u5373\u53ef\u3002\u6700\u8fd1\u6709\u7ba1\u7406\u591a\u7d44 MySQL \u7684\u9700\u6c42\uff0c\u9806\u4fbf\u8a18\u9304\u4e00\u4e0b\u8a2d\u5b9a\u7684\u65b9\u6cd5\u3002 mySQL \u4f3a\u670d\u5668\u6709 production\u3001development \u90192\u53f0\uff0c\u4ee5 Fedora\u3001CentOS \u70ba\u4f8b\uff0c\u8a2d\u5b9a\u6a94\u5728 \/etc\/phpMyAdmin \u76ee\u9304\u4e0b\u3002 \u9996\u5148\u628a config.inc.php \u8907\u88fd 2 \u4efd\uff0c\u5206\u5225\u662f config.production.php \u3001 config.development.php \uff0c\u90192\u500b\u6a94\u6848\u53ea\u5305\u542b\u5404\u5225\u4f3a\u670d\u5668\u8a2d\u5b9a\uff0c\u5927\u81f4\u5167\u5bb9\u5982\u4e0b\uff1a"},"aioseo_meta_data":{"post_id":"294","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"Article","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2020-12-24 02:26:56","updated":"2025-06-05 09:08:26","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/blog.amjet.biz\/IT\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/blog.amjet.biz\/IT\/?cat=9\" title=\"System\">System<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/blog.amjet.biz\/IT\/?cat=18\" title=\"Other\">Other<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t\u8a2d\u5b9a phpMyAdmin \u7ba1\u7406\u591a\u7d44 MySQL \u4f3a\u670d\u5668\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/blog.amjet.biz\/IT"},{"label":"System","link":"https:\/\/blog.amjet.biz\/IT\/?cat=9"},{"label":"Other","link":"https:\/\/blog.amjet.biz\/IT\/?cat=18"},{"label":"\u8a2d\u5b9a phpMyAdmin \u7ba1\u7406\u591a\u7d44 MySQL \u4f3a\u670d\u5668","link":"https:\/\/blog.amjet.biz\/IT\/?p=294"}],"_links":{"self":[{"href":"https:\/\/blog.amjet.biz\/IT\/index.php?rest_route=\/wp\/v2\/posts\/294","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.amjet.biz\/IT\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.amjet.biz\/IT\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.amjet.biz\/IT\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.amjet.biz\/IT\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=294"}],"version-history":[{"count":5,"href":"https:\/\/blog.amjet.biz\/IT\/index.php?rest_route=\/wp\/v2\/posts\/294\/revisions"}],"predecessor-version":[{"id":681,"href":"https:\/\/blog.amjet.biz\/IT\/index.php?rest_route=\/wp\/v2\/posts\/294\/revisions\/681"}],"wp:attachment":[{"href":"https:\/\/blog.amjet.biz\/IT\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.amjet.biz\/IT\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=294"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.amjet.biz\/IT\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}