MySQL 5安装过程中遇到的问题的解决-mysql教程-PHP中文网

MySQL 5安装过程中遇到的问题的解决

php中文网

发布： 2016-06-07 16:09:38

原创

1281人浏览过

以下的文章主要是对MySQL 5安装的过程中遇到的相关问题的解决，本文主要是以代码的方式来对MySQL 5安装的相关问题的详细解析，如果你对其实际的操作有兴趣的话，你就可以浏览以下的文章了。 1、[root@localhost bin]# ./MySQLd_safe skip-grant-tables 出现

以下的文章主要是对mysql 5安装的过程中遇到的相关问题的解决，本文主要是以代码的方式来对mysql 5安装的相关问题的详细解析，如果你对其实际的操作有兴趣的话，你就可以浏览以下的文章了。

1、[root@localhost bin]# ./MySQLd_safe –skip-grant-tables

出现以下信息：

乐活途购物分享社区

beta v1.1版本为第一个版本，简单的整合了基础功能，各位站长拿到程序后，不要纠结后台的功能简单，后续将不断更新扩展。在beta v1.1版本使用过程中遇到什么问题，请登录 www.loftto.com 进行反馈！安装说明######重要提醒：程序不支持二级目录安装，请使用一级目录或二级目录绑定！#第一步，确定你的服务器支持PHP+mysql。#第二步，确定你的服务器开启了gd库。#第三步，

查看详情

<ol class="dp-xml"><li class="alt"><span>Installing MySQL system tables&hellip;  </span></li><li><span>090724 12:05:13 [Warning] option &lsquo;max_join_size&rsquo;: <br />unsigned value 18446744073709551615 adjusted to 4294967295  </span></li><li class="alt"><span>090724 12:05:13 [Warning] option &lsquo;max_join_size&rsquo;: <br />unsigned value 18446744073709551615 adjusted to 4294967295  </span></li><li><span>ERROR: 1062 Duplicate entry &lsquo;localhost-&rsquo; for key 1  </span></li><li class="alt"><span>090724 12:05:13 [ERROR] Aborting  </span></li><li><span>090724 12:05:13 [Note] /usr/local/</span>MySQL<span>5/libexec/</span>MySQL<span>d: Shutdown complete  </span></li><li class="alt"><span>Installation of system tables failed!  </span></li><li><span>Examine the logs in /var/lib/</span>MySQL<span>5 for more information.  </span></li><li class="alt"><span>You can try to start the </span>MySQL<span>d daemon with:  </span></li><li><span>/usr/local/</span>MySQL<span>5/libexec/</span>MySQL<span>d &ndash;skip-grant &  </span></li><li class="alt"><span>and use the command line tool  </span></li><li><span>/usr/local/</span>MySQL<span>5/bin/</span>MySQL<span> to connect to the </span>MySQL<span>  </span></li><li class="alt"><span>database and look at the grant tables:  </span></li><li><span>http://www.knowsky.com/  </span></li><li class="alt"><span>shell</span><span class="tag">></span><span> /usr/local/</span>MySQL<span>5/bin/</span>MySQL<span> -u root </span>MySQL<span>  </span></li><li>MySQL<span class="tag">></span><span> show tables  </span></li><li class="alt"><span>Try &lsquo;</span>MySQL<span>d &ndash;help&rsquo; if you have problems with paths. Using &ndash;log  </span></li><li><span>gives you a log in /var/lib/</span>MySQL<span>5 that may be helpful.  </span></li><li class="alt"><span>The latest information about </span>MySQL<span> is available on the web at  </span></li><li><span>http://www.</span>MySQL<span>.com  </span></li><li class="alt"><span>Please consult the </span>MySQL<span> manual section: &lsquo;Problems running </span>MySQL<span>_install_db&rsquo;,  </span></li><li><span>and the manual section that describes problems on your OS.  </span></li><li class="alt"><span>Another information source is the </span>MySQL<span> email archive.  </span></li><li><span>Please check all of the above before mailing us!  </span></li><li class="alt"><span>And if you do mail us, you MUST use the /usr/local/</span>MySQL<span>5/bin/</span>MySQL<span>bug script!  </span></li></ol>

登录后复制

2、[root@localhost bin]# /usr/local/MySQL5/libexec/MySQLd –skip-grant &

出现以下信息：

<ol class="dp-xml"><li class="alt"><span><span>[1] 6633  </span></span></li><li><span>[root@localhost bin]# 090724 12:05:34 [Warning] option &lsquo;max_join_size&rsquo;: <br />unsigned value 18446744073709551615 adjusted to 4294967295  </span></li><li class="alt"><span>090724 12:05:34 [Warning] option &lsquo;max_join_size&rsquo;: <br />unsigned value 18446744073709551615 adjusted to 4294967295  </span></li><li><span>090724 12:05:34 [ERROR] Fatal error: Please read &ldquo;Security&rdquo; <br />section of the manual to find out how to run </span>MySQL<span>d as root!  </span></li><li class="alt"><span>090724 12:05:34 [ERROR] Aborting  </span></li><li><span>090724 12:05:34 [Note] /usr/local/</span>MySQL<span>5/libexec/</span>MySQL<span>d: Shutdown complete  </span></li><li class="alt"><span>[1]+ Exit 1 /usr/local/</span>MySQL<span>5/libexec/</span>MySQL<span>d &ndash;skip-grant  </span></li></ol>

登录后复制

解决办法：在/etc/my.conf中的MySQLd这一节中加入：user=MySQL，以上的相关内容就是对MySQL 5安装遇到的问题的介绍，望你能有所收获。