【求助】mysql無法使用



贊助商連結


皮皮
2003-08-10, 02:48 AM
《請求》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
http://www.innodb.com/ibman.html
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...不知道是否需要更新什麼套件檔案的意思嗎?

贊助商連結


billyao
2003-08-10, 03:45 AM
請檢查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!

innodb_data_file_path = /ibdata/ibdata1:100M:autoextend

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!

skip-innodb

#innodb_data_home_dir =
#innodb_data_file_path = /var/lib/mysql/ibdata/ibdata1:100M:autoextend