建站
咨詢
售后
建站咨詢
新聞中心
這里有您想知道的互聯(lián)網(wǎng)營(yíng)銷解決方案
MySQL5安裝過(guò)程中遇到的問(wèn)題的解決
以下的文章主要是對(duì)MySQL 5安裝的過(guò)程中遇到的相關(guān)問(wèn)題的解決，本文主要是以代碼的方式來(lái)對(duì)MySQL 5安裝的相關(guān)問(wèn)題的詳細(xì)解析，如果你對(duì)其實(shí)際的操作有興趣的話，你就可以 瀏覽以下的文章了。
成都創(chuàng)新互聯(lián)從2013年創(chuàng)立，是專業(yè)互聯(lián)網(wǎng)技術(shù)服務(wù)公司，擁有項(xiàng)目網(wǎng)站建設(shè)、成都做網(wǎng)站網(wǎng)站策劃，項(xiàng)目實(shí)施與項(xiàng)目整合能力。我們以讓每一個(gè)夢(mèng)想脫穎而出為使命，1280元寬甸做網(wǎng)站,已為上家服務(wù),為寬甸各地企業(yè)和個(gè)人服務(wù),聯(lián)系電話:028-86922220
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安裝遇到的問(wèn)題的介紹，望你能有所收獲。
文章名稱：MySQL5安裝過(guò)程中遇到的問(wèn)題的解決
網(wǎng)站地址：http://m.fisionsoft.com.cn/article/cdehedi.html
