MySQL 5安裝過程中遇到的問題的解決
作者：佚名
我們今天主要和大家分享的是MySQL 5安裝的過程中遇到的相關問題的解決，下面就是文章的具體內(nèi)容的介紹，望你在瀏覽之后會有所收獲。
以下的文章主要是對MySQL 5安裝的過程中遇到的相關問題的解決，本文主要是以代碼的方式來對MySQL 5安裝的相關問題的詳細解析，如果你對其實際的操作有興趣的話，你就可以 瀏覽以下的文章了。
1、[root@localhost bin]# ./MySQLd_safe –skip-grant-tables
出現(xiàn)以下信息：
- Installing MySQL system tables…
- 090724 12:05:13 [Warning] option ‘max_join_size’:
unsigned value 18446744073709551615 adjusted to 4294967295- 090724 12:05:13 [Warning] option ‘max_join_size’:
unsigned value 18446744073709551615 adjusted to 4294967295- ERROR: 1062 Duplicate entry ‘localhost-’ for key 1
- 090724 12:05:13 [ERROR] Aborting
- 090724 12:05:13 [Note] /usr/local/MySQL5/libexec/MySQLd: Shutdown complete
- Installation of system tables failed!
- Examine the logs in /var/lib/MySQL5 for more information.
- You can try to start the MySQLd daemon with:
- /usr/local/MySQL5/libexec/MySQLd –skip-grant &
- and use the command line tool
- /usr/local/MySQL5/bin/MySQL to connect to the MySQL
- database and look at the grant tables:
- http://www.knowsky.com/
- shell> /usr/local/MySQL5/bin/MySQL -u root MySQL
- MySQL> show tables
- Try ‘MySQLd –help’ if you have problems with paths. Using –log
- gives you a log in /var/lib/MySQL5 that may be helpful.
- The latest information about MySQL is available on the web at
- http://www.MySQL.com
- Please consult the MySQL manual section: ‘Problems running MySQL_install_db’,
- and the manual section that describes problems on your OS.
- Another information source is the MySQL email archive.
- Please check all of the above before mailing us!
- And if you do mail us, you MUST use the /usr/local/MySQL5/bin/MySQLbug script!
2、[root@localhost bin]# /usr/local/MySQL5/libexec/MySQLd –skip-grant &
出現(xiàn)以下信息：
- [1] 6633
- [root@localhost bin]# 090724 12:05:34 [Warning] option ‘max_join_size’:
unsigned value 18446744073709551615 adjusted to 4294967295- 090724 12:05:34 [Warning] option ‘max_join_size’:
unsigned value 18446744073709551615 adjusted to 4294967295- 090724 12:05:34 [ERROR] Fatal error: Please read “Security”
section of the manual to find out how to run MySQLd as root!- 090724 12:05:34 [ERROR] Aborting
- 090724 12:05:34 [Note] /usr/local/MySQL5/libexec/MySQLd: Shutdown complete
- [1]+ Exit 1 /usr/local/MySQL5/libexec/MySQLd –skip-grant
解決辦法：在/etc/my.conf中的MySQLd這一節(jié)中加入：user=MySQL，以上的相關內(nèi)容就是對MySQL 5安裝遇到的問題的介紹，望你能有所收獲。
【編輯推薦】
- MySQL隱藏空間相關問題的解答
- MySQL數(shù)據(jù)庫命令的基礎簡介
- MySQL數(shù)字類型中的三種常用種類
- MySQL force Index 強制索引概述
- MySQL參數(shù)設置如何解決瓶頸效應？
責任編輯：佚名
來源：
博客園
