[問題] Centos MySQL 啟動失敗

看板Linux作者ezsome (簡易體)時間15年前 (2010/07/21 12:08)推噓2(2推 0噓 1→)

留言3則, 2人參與討論串1/2 (看更多)

我用yum安裝完mysql之後下service mysqld start 這個指令啟動mysql 等了很久卻出現下面這行訊息 Timeout error occurred trying to start MySQL Daemon. 然後到/var/lib/mysql會出現三個檔案ibdata1 ib_logfile0 ib_logfile1 和兩個空目錄mysql test 爬文後找不到類似的問題我試過移除mysql 他會連相關套件也一併移除之後我把所有套件再安裝進去還是一樣的結果不知道有沒有大大有發生過類似情形 -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 211.23.205.205

推

Adama

07/21 12:10, , 1^F

07/21 12:10, 1^F

這是我在mysqld.log檔裡找到的 100721 11:25:44 mysqld started 100721 11:25:44 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 100721 11:25:44 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 100721 11:25:45 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 100721 11:25:45 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 100721 11:25:46 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 100721 11:25:47 InnoDB: Started; log sequence number 0 0 100721 11:25:47 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 100721 11:25:47 mysqld ended ※ 編輯: ezsome 來自: 211.23.205.205 (07/21 12:25) 另外我輸入/usr/bin/mysql_install_db 則會跳出下面訊息: Installing MySQL system tables... 100721 14:28:07 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 100721 14:28:07 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 OK Filling help tables... 100721 14:28:07 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 100721 14:28:07 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 OK To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h centos.csie.cgu.edu.tw password 'new-password' Alternatively you can run: /usr/bin/mysql_secure_installation which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers. See the manual for more instructions. You can start the MySQL daemon with: cd /usr ; /usr/bin/mysqld_safe & You can test the MySQL daemon with mysql-test-run.pl cd mysql-test ; perl mysql-test-run.pl Please report any problems with the /usr/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at http://shop.mysql.com 我看了一下空間還沒滿...應該可以排除空間問題 ※ 編輯: ezsome 來自: 211.23.205.205 (07/21 14:31)