-
【求助】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