{"id":84,"date":"2014-02-21T23:47:15","date_gmt":"2014-02-21T15:47:15","guid":{"rendered":"http:\/\/blog.cyszys.com\/?p=84"},"modified":"2014-02-21T23:48:46","modified_gmt":"2014-02-21T15:48:46","slug":"%e8%a7%a3%e5%86%b3xampp%e4%b8%admysql%e4%b8%8d%e5%90%af%e5%8a%a8%e7%9a%84%e9%97%ae%e9%a2%98","status":"publish","type":"post","link":"http:\/\/blog.cyszys.com\/?p=84","title":{"rendered":"\u89e3\u51b3xampp\u4e2dmysql\u4e0d\u542f\u52a8\u7684\u95ee\u9898"},"content":{"rendered":"<p>\u67d0\u4e9b\u7248\u672c\u7684xampp\u5b89\u88c5\u5b8c\u6210\u540e\u53ef\u80fd\u5b58\u5728mysql\u65e0\u6cd5\u542f\u52a8\u7684\u60c5\u51b5\uff0c\u5bfc\u81f4\u65e0\u6cd5\u542f\u52a8\u7684\u539f\u56e0\u5927\u6982\u5206\u4e3a\u4e24\u79cd\uff1a<!--more--><\/p>\n<p><strong>1\u3001<\/strong>\/opt\/lampp\/var\/mysql\u76ee\u5f55\u5c5e\u732a\u4e0d\u6b63\u786e\uff0c\u62a5\u9519\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n<pre class=\"brush:bash\">[root@ns2 lampp]# tail -f \/opt\/lampp\/var\/ns2.chinabtn.com.err\n130725 21:53:54 InnoDB: Compressed tables use zlib 1.2.8\n130725 21:53:54 InnoDB: Initializing buffer pool, size = 16.0M\n130725 21:53:54 InnoDB: Completed initialization of buffer pool\n130725 21:53:54  InnoDB: Operating system error number 13 in a file operation.\nInnoDB: The error means mysqld does not have the access rights to\nInnoDB: the directory.\nInnoDB: File name \/opt\/lampp\/var\/mysql\/ibdata1\nInnoDB: File operation call: 'create'.\nInnoDB: Cannot continue operation.\n130725 21:53:54 mysqld_safe mysqld from pid file \/opt\/lampp\/var\/ns2.chinabtn.com.pid ended<\/pre>\n<p>\u00a0<strong>\u89e3\u51b3\u65b9\u6cd5\uff1a<\/strong><\/p>\n<p>root\u4e0b\u6267\u884c\uff1a<\/p>\n<pre class=\"brush:bash\">chown -R nobody.root \/opt\/lampp\/var\/mysql<\/pre>\n<p><strong>2\u3001<\/strong>\u8fd9\u4e2a\u95ee\u9898\u662f\u56e0\u4e3a\u5728lampp\u63a7\u5236\u811a\u672c\u4e2d\u6ca1\u6709\u7533\u660elampp\u7684OS\u7c7b\u578b\u548clampp\u670d\u52a1\u5668\u8def\u5f84\u800c\u9020\u6210\u7684\u3002<\/p>\n<p><strong>\u89e3\u51b3\u65b9\u6cd5\uff1a<\/strong><\/p>\n<p>\u7f16\u8f91\/opt\/lampp\/lampp<\/p>\n<p>\u5728\u6587\u4ef6\u4e2d\u627e\u67e5\u627e<\/p>\n<pre class=\"brush:bash\">. $XAMPP_ROOT\/share\/xampp\/xampplib<\/pre>\n<p>\u00a0\u5728\u8fd9\u4e00\u884c\u4e4b\u4e0a\u7684\u4e24\u4e2aexport\u9879\u76ee\u4e4b\u4e0a\u6dfb\u52a0\u4ee5\u4e0b\u4e24\u884c\u4fe1\u606f\uff1a<\/p>\n<pre class=\"brush:bash\">##########user config###########\nXAMPP_OS=\"linux\"\nXAMPP_ROOT=\"\/opt\/lampp\"\n##########user config###########<\/pre>\n<p>\u00a0\u8fd9\u6837\u5728\u811a\u672c\u6267\u884c\u201cexport XAMPP_OS\u201d\u548c\u201cexport XAMPP_ROOT\u201d\u7684\u65f6\u5019\u5c31\u53ef\u4ee5\u5f97\u5230\u6b63\u786e\u7684\u73af\u5883\u53d8\u91cf\u4e86\u3002<\/p>","protected":false},"excerpt":{"rendered":"<p>\u67d0\u4e9b\u7248\u672c\u7684xampp\u5b89\u88c5\u5b8c\u6210\u540e\u53ef\u80fd\u5b58\u5728mysql\u65e0\u6cd5\u542f\u52a8\u7684\u60c5\u51b5\uff0c\u5bfc\u81f4\u65e0\u6cd5\u542f\u52a8\u7684\u539f\u56e0\u5927\u6982\u5206\u4e3a\u4e24\u79cd\uff1a<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,8,11],"tags":[43,18],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u67d0\u4e9b\u7248\u672c\u7684xampp\u5b89\u88c5\u5b8c\u6210\u540e\u53ef\u80fd\u5b58\u5728mysql\u65e0\u6cd5\u542f\u52a8\u7684\u60c5\u51b5\uff0c\u5bfc\u81f4\u65e0\u6cd5\u542f\u52a8\u7684\u539f\u56e0\u5927\u6982\u5206\u4e3a\u4e24\u79cd\uff1a 1\u3001\/opt\" \/>\n\t<meta name=\"author\" content=\"Eason.Cao\"\/>\n\t<link rel=\"canonical\" href=\"http:\/\/blog.cyszys.com\/?p=84\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"zh_CN\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Eason - \u54b8\u9c7c\u54af\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\u89e3\u51b3xampp\u4e2dmysql\u4e0d\u542f\u52a8\u7684\u95ee\u9898 - Eason\" \/>\n\t\t<meta property=\"og:description\" content=\"\u67d0\u4e9b\u7248\u672c\u7684xampp\u5b89\u88c5\u5b8c\u6210\u540e\u53ef\u80fd\u5b58\u5728mysql\u65e0\u6cd5\u542f\u52a8\u7684\u60c5\u51b5\uff0c\u5bfc\u81f4\u65e0\u6cd5\u542f\u52a8\u7684\u539f\u56e0\u5927\u6982\u5206\u4e3a\u4e24\u79cd\uff1a 1\u3001\/opt\" \/>\n\t\t<meta property=\"og:url\" content=\"http:\/\/blog.cyszys.com\/?p=84\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2014-02-21T15:47:15+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2014-02-21T15:48:46+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"\u89e3\u51b3xampp\u4e2dmysql\u4e0d\u542f\u52a8\u7684\u95ee\u9898 - Eason\" \/>\n\t\t<meta name=\"twitter:description\" content=\"\u67d0\u4e9b\u7248\u672c\u7684xampp\u5b89\u88c5\u5b8c\u6210\u540e\u53ef\u80fd\u5b58\u5728mysql\u65e0\u6cd5\u542f\u52a8\u7684\u60c5\u51b5\uff0c\u5bfc\u81f4\u65e0\u6cd5\u542f\u52a8\u7684\u539f\u56e0\u5927\u6982\u5206\u4e3a\u4e24\u79cd\uff1a 1\u3001\/opt\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?p=84#blogposting\",\"name\":\"\\u89e3\\u51b3xampp\\u4e2dmysql\\u4e0d\\u542f\\u52a8\\u7684\\u95ee\\u9898 - Eason\",\"headline\":\"\\u89e3\\u51b3xampp\\u4e2dmysql\\u4e0d\\u542f\\u52a8\\u7684\\u95ee\\u9898\",\"author\":{\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?author=1#author\"},\"publisher\":{\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/#person\"},\"datePublished\":\"2014-02-21T23:47:15+08:00\",\"dateModified\":\"2014-02-21T23:48:46+08:00\",\"inLanguage\":\"zh-CN\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?p=84#webpage\"},\"isPartOf\":{\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?p=84#webpage\"},\"articleSection\":\"Linux, Xampp, \\u6570\\u636e\\u5e93, mysql\\u65e0\\u6cd5\\u542f\\u52a8, xampp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?p=84#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/blog.cyszys.com#listItem\",\"position\":1,\"name\":\"\\u4e3b\\u9801\",\"item\":\"http:\\\/\\\/blog.cyszys.com\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?cat=8#listItem\",\"name\":\"Xampp\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?cat=8#listItem\",\"position\":2,\"name\":\"Xampp\",\"item\":\"http:\\\/\\\/blog.cyszys.com\\\/?cat=8\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?p=84#listItem\",\"name\":\"\\u89e3\\u51b3xampp\\u4e2dmysql\\u4e0d\\u542f\\u52a8\\u7684\\u95ee\\u9898\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/blog.cyszys.com#listItem\",\"name\":\"\\u4e3b\\u9801\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?p=84#listItem\",\"position\":3,\"name\":\"\\u89e3\\u51b3xampp\\u4e2dmysql\\u4e0d\\u542f\\u52a8\\u7684\\u95ee\\u9898\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?cat=8#listItem\",\"name\":\"Xampp\"}}]},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/#person\",\"name\":\"Eason.Cao\"},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?author=1#author\",\"url\":\"http:\\\/\\\/blog.cyszys.com\\\/?author=1\",\"name\":\"Eason.Cao\"},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?p=84#webpage\",\"url\":\"http:\\\/\\\/blog.cyszys.com\\\/?p=84\",\"name\":\"\\u89e3\\u51b3xampp\\u4e2dmysql\\u4e0d\\u542f\\u52a8\\u7684\\u95ee\\u9898 - Eason\",\"description\":\"\\u67d0\\u4e9b\\u7248\\u672c\\u7684xampp\\u5b89\\u88c5\\u5b8c\\u6210\\u540e\\u53ef\\u80fd\\u5b58\\u5728mysql\\u65e0\\u6cd5\\u542f\\u52a8\\u7684\\u60c5\\u51b5\\uff0c\\u5bfc\\u81f4\\u65e0\\u6cd5\\u542f\\u52a8\\u7684\\u539f\\u56e0\\u5927\\u6982\\u5206\\u4e3a\\u4e24\\u79cd\\uff1a 1\\u3001\\\/opt\",\"inLanguage\":\"zh-CN\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/#website\"},\"breadcrumb\":{\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?p=84#breadcrumblist\"},\"author\":{\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?author=1#author\"},\"creator\":{\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?author=1#author\"},\"datePublished\":\"2014-02-21T23:47:15+08:00\",\"dateModified\":\"2014-02-21T23:48:46+08:00\"},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/#website\",\"url\":\"http:\\\/\\\/blog.cyszys.com\\\/\",\"name\":\"Eason\",\"description\":\"\\u54b8\\u9c7c\\u54af\",\"inLanguage\":\"zh-CN\",\"publisher\":{\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\u89e3\u51b3xampp\u4e2dmysql\u4e0d\u542f\u52a8\u7684\u95ee\u9898 - Eason","description":"\u67d0\u4e9b\u7248\u672c\u7684xampp\u5b89\u88c5\u5b8c\u6210\u540e\u53ef\u80fd\u5b58\u5728mysql\u65e0\u6cd5\u542f\u52a8\u7684\u60c5\u51b5\uff0c\u5bfc\u81f4\u65e0\u6cd5\u542f\u52a8\u7684\u539f\u56e0\u5927\u6982\u5206\u4e3a\u4e24\u79cd\uff1a 1\u3001\/opt","canonical_url":"http:\/\/blog.cyszys.com\/?p=84","robots":"","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"http:\/\/blog.cyszys.com\/?p=84#blogposting","name":"\u89e3\u51b3xampp\u4e2dmysql\u4e0d\u542f\u52a8\u7684\u95ee\u9898 - Eason","headline":"\u89e3\u51b3xampp\u4e2dmysql\u4e0d\u542f\u52a8\u7684\u95ee\u9898","author":{"@id":"http:\/\/blog.cyszys.com\/?author=1#author"},"publisher":{"@id":"http:\/\/blog.cyszys.com\/#person"},"datePublished":"2014-02-21T23:47:15+08:00","dateModified":"2014-02-21T23:48:46+08:00","inLanguage":"zh-CN","mainEntityOfPage":{"@id":"http:\/\/blog.cyszys.com\/?p=84#webpage"},"isPartOf":{"@id":"http:\/\/blog.cyszys.com\/?p=84#webpage"},"articleSection":"Linux, Xampp, \u6570\u636e\u5e93, mysql\u65e0\u6cd5\u542f\u52a8, xampp"},{"@type":"BreadcrumbList","@id":"http:\/\/blog.cyszys.com\/?p=84#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"http:\/\/blog.cyszys.com#listItem","position":1,"name":"\u4e3b\u9801","item":"http:\/\/blog.cyszys.com","nextItem":{"@type":"ListItem","@id":"http:\/\/blog.cyszys.com\/?cat=8#listItem","name":"Xampp"}},{"@type":"ListItem","@id":"http:\/\/blog.cyszys.com\/?cat=8#listItem","position":2,"name":"Xampp","item":"http:\/\/blog.cyszys.com\/?cat=8","nextItem":{"@type":"ListItem","@id":"http:\/\/blog.cyszys.com\/?p=84#listItem","name":"\u89e3\u51b3xampp\u4e2dmysql\u4e0d\u542f\u52a8\u7684\u95ee\u9898"},"previousItem":{"@type":"ListItem","@id":"http:\/\/blog.cyszys.com#listItem","name":"\u4e3b\u9801"}},{"@type":"ListItem","@id":"http:\/\/blog.cyszys.com\/?p=84#listItem","position":3,"name":"\u89e3\u51b3xampp\u4e2dmysql\u4e0d\u542f\u52a8\u7684\u95ee\u9898","previousItem":{"@type":"ListItem","@id":"http:\/\/blog.cyszys.com\/?cat=8#listItem","name":"Xampp"}}]},{"@type":"Person","@id":"http:\/\/blog.cyszys.com\/#person","name":"Eason.Cao"},{"@type":"Person","@id":"http:\/\/blog.cyszys.com\/?author=1#author","url":"http:\/\/blog.cyszys.com\/?author=1","name":"Eason.Cao"},{"@type":"WebPage","@id":"http:\/\/blog.cyszys.com\/?p=84#webpage","url":"http:\/\/blog.cyszys.com\/?p=84","name":"\u89e3\u51b3xampp\u4e2dmysql\u4e0d\u542f\u52a8\u7684\u95ee\u9898 - Eason","description":"\u67d0\u4e9b\u7248\u672c\u7684xampp\u5b89\u88c5\u5b8c\u6210\u540e\u53ef\u80fd\u5b58\u5728mysql\u65e0\u6cd5\u542f\u52a8\u7684\u60c5\u51b5\uff0c\u5bfc\u81f4\u65e0\u6cd5\u542f\u52a8\u7684\u539f\u56e0\u5927\u6982\u5206\u4e3a\u4e24\u79cd\uff1a 1\u3001\/opt","inLanguage":"zh-CN","isPartOf":{"@id":"http:\/\/blog.cyszys.com\/#website"},"breadcrumb":{"@id":"http:\/\/blog.cyszys.com\/?p=84#breadcrumblist"},"author":{"@id":"http:\/\/blog.cyszys.com\/?author=1#author"},"creator":{"@id":"http:\/\/blog.cyszys.com\/?author=1#author"},"datePublished":"2014-02-21T23:47:15+08:00","dateModified":"2014-02-21T23:48:46+08:00"},{"@type":"WebSite","@id":"http:\/\/blog.cyszys.com\/#website","url":"http:\/\/blog.cyszys.com\/","name":"Eason","description":"\u54b8\u9c7c\u54af","inLanguage":"zh-CN","publisher":{"@id":"http:\/\/blog.cyszys.com\/#person"}}]},"og:locale":"zh_CN","og:site_name":"Eason - \u54b8\u9c7c\u54af","og:type":"article","og:title":"\u89e3\u51b3xampp\u4e2dmysql\u4e0d\u542f\u52a8\u7684\u95ee\u9898 - Eason","og:description":"\u67d0\u4e9b\u7248\u672c\u7684xampp\u5b89\u88c5\u5b8c\u6210\u540e\u53ef\u80fd\u5b58\u5728mysql\u65e0\u6cd5\u542f\u52a8\u7684\u60c5\u51b5\uff0c\u5bfc\u81f4\u65e0\u6cd5\u542f\u52a8\u7684\u539f\u56e0\u5927\u6982\u5206\u4e3a\u4e24\u79cd\uff1a 1\u3001\/opt","og:url":"http:\/\/blog.cyszys.com\/?p=84","article:published_time":"2014-02-21T15:47:15+00:00","article:modified_time":"2014-02-21T15:48:46+00:00","twitter:card":"summary_large_image","twitter:title":"\u89e3\u51b3xampp\u4e2dmysql\u4e0d\u542f\u52a8\u7684\u95ee\u9898 - Eason","twitter:description":"\u67d0\u4e9b\u7248\u672c\u7684xampp\u5b89\u88c5\u5b8c\u6210\u540e\u53ef\u80fd\u5b58\u5728mysql\u65e0\u6cd5\u542f\u52a8\u7684\u60c5\u51b5\uff0c\u5bfc\u81f4\u65e0\u6cd5\u542f\u52a8\u7684\u539f\u56e0\u5927\u6982\u5206\u4e3a\u4e24\u79cd\uff1a 1\u3001\/opt"},"aioseo_meta_data":[],"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/blog.cyszys.com\" title=\"\u4e3b\u9801\">\u4e3b\u9801<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/blog.cyszys.com\/?cat=8\" title=\"Xampp\">Xampp<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t\u89e3\u51b3xampp\u4e2dmysql\u4e0d\u542f\u52a8\u7684\u95ee\u9898\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"\u4e3b\u9801","link":"http:\/\/blog.cyszys.com"},{"label":"Xampp","link":"http:\/\/blog.cyszys.com\/?cat=8"},{"label":"\u89e3\u51b3xampp\u4e2dmysql\u4e0d\u542f\u52a8\u7684\u95ee\u9898","link":"http:\/\/blog.cyszys.com\/?p=84"}],"_links":{"self":[{"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=\/wp\/v2\/posts\/84"}],"collection":[{"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=84"}],"version-history":[{"count":2,"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=\/wp\/v2\/posts\/84\/revisions"}],"predecessor-version":[{"id":86,"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=\/wp\/v2\/posts\/84\/revisions\/86"}],"wp:attachment":[{"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=84"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=84"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=84"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}