Home > Database > Mysql Tutorial > MySQL 5安装过程中遇到的问题的解决

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

WBOY
Release: 2016-06-07 16:09:38
Original
1115 people have browsed it

以下的文章主要是对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

出现以下信息:

<ol class="dp-xml">
<li class="alt"><span>Installing MySQL system tables…  </span></li>
<li><span>090724 12:05:13 [Warning] option ‘max_join_size’: <br>unsigned value 18446744073709551615 adjusted to 4294967295  </span></li>
<li class="alt"><span>090724 12:05:13 [Warning] option ‘max_join_size’: <br>unsigned value 18446744073709551615 adjusted to 4294967295  </span></li>
<li><span>ERROR: 1062 Duplicate entry ‘localhost-’ 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 –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 ‘</span>MySQL<span>d –help’ if you have problems with paths. Using –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: ‘Problems running </span>MySQL<span>_install_db’,  </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>
Copy after login

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 ‘max_join_size’: <br>unsigned value 18446744073709551615 adjusted to 4294967295  </span></li>
<li class="alt"><span>090724 12:05:34 [Warning] option ‘max_join_size’: <br>unsigned value 18446744073709551615 adjusted to 4294967295  </span></li>
<li>
<span>090724 12:05:34 [ERROR] Fatal error: Please read “Security” <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 –skip-grant  </span>
</li>
</ol>
Copy after login

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


Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template