在网上查说是配置文件的事。
my.ini复制自my_small.ini。
只增加了
mysql字段
basedir = d:/mysql-5.5.24-winx64
datadir = d:/mysql-5.5.24-winx64/data
character-set-server=utf8
client字段
default-character-set = utf8
另外在安装时候cmd使用管理员身份启动的。是不是这个有影响???
错误日志:
140217 9:59:30 [note] plugin 'federated' is disabled.
140217 9:59:30 innodb: the innodb memory heap is disabled
140217 9:59:30 innodb: mutexes and rw_locks use windows interlocked functions
140217 9:59:30 innodb: compressed tables use zlib 1.2.3
140217 9:59:30 innodb: initializing buffer pool, size = 128.0m
140217 9:59:30 innodb: completed initialization of buffer pool
innodb: the first specified data file .\ibdata1 did not exist:
innodb: a new database to be created!
140217 9:59:30 innodb: setting file .\ibdata1 size to 10 mb
innodb: database physically writes the file full: wait...
140217 9:59:30 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...
140217 9:59:30 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: 127 rollback segment(s) active.
innodb: creating foreign key constraint system tables
innodb: foreign key constraint system tables created
140217 9:59:31 innodb: waiting for the background threads to start
140217 9:59:32 innodb: 1.1.8 started; log sequence number 0
140217 9:59:32 [error] mysql: unknown variable 'default-character-set=gbk'
140217 9:59:32 [error] aborting
140217 9:59:32 innodb: starting shutdown...
140217 9:59:33 innodb: shutdown completed; log sequence number 1595675
140217 9:59:33 [note] mysql: shutdown complete
各种查资料各种解决不了。求大神帮忙。
附加:很神奇的是为什么会有 unknown variable 'default-character-set=gbk'
我根本就没有设置default-character-set=gbk,设置了default-character-set=tutf8也还是这个错误。
