MySQL 5安裝過程中遇到的問題的解決
以下的文章主要是對(duì)MySQL 5安裝的過程中遇到的相關(guān)問題的解決,本文主要是以代碼的方式來對(duì)MySQL 5安裝的相關(guān)問題的詳細(xì)解析,如果你對(duì)其實(shí)際的操作有興趣的話,你就可以 瀏覽以下的文章了。
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,以上的相關(guān)內(nèi)容就是對(duì)MySQL 5安裝遇到的問題的介紹,望你能有所收獲。
【編輯推薦】
- MySQL隱藏空間相關(guān)問題的解答
- MySQL數(shù)據(jù)庫命令的基礎(chǔ)簡(jiǎn)介
- MySQL數(shù)字類型中的三種常用種類
- MySQL force Index 強(qiáng)制索引概述
- MySQL參數(shù)設(shè)置如何解決瓶頸效應(yīng)?