MySQL5.5.38安裝出現(xiàn)的問題

卸掉5.1.73， 安裝5.5.38，出現(xiàn)的一些問題。 系統(tǒng)啟動、關(guān)閉 net start mysql; net stop mysql; 刪除服務(wù)：兩種方法 sc delete mysql mysqld -remove 安裝 mysqld --install mysql --defaults-file=D:\mysql 5.5.38\my.ini --install 后面跟的事服務(wù)名。 5.5

卸掉5.1.73， 安裝5.5.38，出現(xiàn)的一些問題。

系統(tǒng)啟動、關(guān)閉

net start mysql;

net stop mysql;

刪除服務(wù)：兩種方法

sc delete mysql

mysqld -remove

安裝

mysqld --install mysql --defaults-file="D:\mysql 5.5.38\my.ini"

--install 后面跟的事服務(wù)名。

5.5.38與5.1.73中不同之處：

mysqld

5.1.73 default-character-set=utf8

5.5.38 character-set-server=utf8

日志叫法也有區(qū)別，記得不是特別清楚

slow_query_log

log_slow_query

另外dir設(shè)置出問題也會導(dǎo)致1067系統(tǒng)錯誤。

#系統(tǒng)基本目錄

basedir= C:/srv/mysql-5.5.19
#用戶數(shù)據(jù)目錄

datadir= E:/myWeb/mysql5data/data

e it.

貼出錯誤日志：

140707 11:37:55 InnoDB: Starting shutdown...
140707 11:37:55 InnoDB: Shutdown completed; log sequence number 1595675
140707 11:37:55 [Note] D:\MySQL 5.5.38\bin\mysqld: Shutdown complete


140707 11:40:27 [Note] Plugin 'FEDERATED' is disabled.
140707 11:40:27 InnoDB: The InnoDB memory heap is disabled
140707 11:40:27 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140707 11:40:27 InnoDB: Compressed tables use zlib 1.2.3
140707 11:40:27 InnoDB: Initializing buffer pool, size = 2.0G
140707 11:40:27 InnoDB: Completed initialization of buffer pool
140707 11:40:27 InnoDB: highest supported file format is Barracuda.
140707 11:40:28 InnoDB: Waiting for the background threads to start
140707 11:40:29 InnoDB: 5.5.38 started; log sequence number 1595675
140707 11:40:29 [ERROR] D:\MySQL 5.5.38\bin\mysqld: unknown option '--skip-locking'
140707 11:40:29 [ERROR] Aborting


140707 11:40:29 InnoDB: Starting shutdown...
140707 11:40:30 InnoDB: Shutdown completed; log sequence number 1595675
140707 11:40:30 [Note] D:\MySQL 5.5.38\bin\mysqld: Shutdown complete


140707 11:43:45 [Note] Plugin 'FEDERATED' is disabled.
140707 11:43:45 InnoDB: The InnoDB memory heap is disabled
140707 11:43:45 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140707 11:43:45 InnoDB: Compressed tables use zlib 1.2.3
140707 11:43:45 InnoDB: Initializing buffer pool, size = 2.0G
140707 11:43:45 InnoDB: Completed initialization of buffer pool
140707 11:43:45 InnoDB: highest supported file format is Barracuda.
140707 11:43:46 InnoDB: Waiting for the background threads to start
140707 11:43:47 InnoDB: 5.5.38 started; log sequence number 1595675
140707 11:43:47 [ERROR] D:\MySQL 5.5.38\bin\mysqld: unknown variable 'default-character-set=utf8'
140707 11:43:47 [ERROR] Aborting


140707 11:43:47 InnoDB: Starting shutdown...
140707 11:43:47 InnoDB: Shutdown completed; log sequence number 1595675
140707 11:43:47 [Note] D:\MySQL 5.5.38\bin\mysqld: Shutdown complete


140707 11:45:51 [Note] Plugin 'FEDERATED' is disabled.
140707 11:45:51 InnoDB: The InnoDB memory heap is disabled
140707 11:45:51 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140707 11:45:51 InnoDB: Compressed tables use zlib 1.2.3
140707 11:45:51 InnoDB: Initializing buffer pool, size = 2.0G
140707 11:45:52 InnoDB: Completed initialization of buffer pool
140707 11:45:52 InnoDB: highest supported file format is Barracuda.
140707 11:45:52 InnoDB: Waiting for the background threads to start
140707 11:45:53 InnoDB: 5.5.38 started; log sequence number 1595675
140707 11:45:53 [ERROR] D:\MySQL 5.5.38\bin\mysqld: unknown variable 'default-character-set=utf8'
140707 11:45:53 [ERROR] Aborting


140707 11:45:53 InnoDB: Starting shutdown...
140707 11:45:54 InnoDB: Shutdown completed; log sequence number 1595675
140707 11:45:54 [Note] D:\MySQL 5.5.38\bin\mysqld: Shutdown complete

聲明：本網(wǎng)頁內(nèi)容旨在傳播知識，若有侵權(quán)等問題請及時與本網(wǎng)聯(lián)系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com