以下的文章主要是对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>
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>
解决办法:在/etc/my.conf中的MySQLd这一节中加入:user=MySQL,以上的相关内容就是对MySQL 5安装遇到的问题的介绍,望你能有所收获。