【求助】mysql無法使用 《請求》1.皮皮的主機被不知名人士串改了mysql資料庫的使用者密碼 1.皮皮的主機被不知名人士串改了mysql資料庫的使用者密碼 root也進不去...密碼都被改了! 不知道有什麼辦法修正回來!! 2.看了log檔 163.26.220.11 218.174.153.160 61.231.69.208 這幾ip是從那來的...log檔記錄他們似乎有做壞事的動作!!!! 晚上又上主機看看....發現log的訊息如下/var/log/mysql.log 030810 02:08:23 mysqld started Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add to the [mysqld] section, for example, innodb_data_file_path = ibdata1:10M:autoextend But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at [url]http://www.innodb.com/ibman.html[/url] 030810 2:08:23 Found invalid password for user: 'root@localhost'; Ignoring user 030810 2:08:23 Found old style password for user 'muse'. Ignoring user. (You may want to restart using --old-protocol) /usr/libexec/mysqld: ready for connections 剛剛vi了一下mysql內的user.MYD 發現原來密碼跟帳號都沒變 於是RESTART了mysql還是不行連結到mysql reboot也一樣...@_@ 上面是mysql的log...不知道是否需要更新什麼套件檔案的意思嗎? |
回覆: 【求助】mysql無法使用 請檢查InnoDB tables的路徑,可能是'innodb_data_file_path' 設定有問題,檢視my.cnf的設定,範例如下: [mysqld] #You can write your other MySQL server options here #Read the manual if you want to enable InnoDB! [B]innodb_data_file_path = /ibdata/ibdata1:100M:autoextend[/B] set-variable = innodb_buffer_pool_size=70M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_log_file_size=20M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 如果不想設定 InnoDB tables,則增加一列skip-innodb,範例如下: [mysqld] #If You can not write your other MySQL server options here #Read the manual if you want to enable InnoDB! [B]skip-innodb[/B] #innodb_data_home_dir = #innodb_data_file_path = /var/lib/mysql/ibdata/ibdata1:100M:autoextend |
所有時間均為 +8。現在的時間是 10:08 PM。 |
XML | RSS 2.0 | RSS |
本論壇所有文章僅代表留言者個人意見,並不代表本站之立場,討論區以「即時留言」方式運作,故無法完全監察所有即時留言,若您發現文章可能有異議,請 email :[email protected] 處理。