最新文章专题视频专题问答1问答10问答100问答1000问答2000关键字专题1关键字专题50关键字专题500关键字专题1500TAG最新视频文章推荐1 推荐3 推荐5 推荐7 推荐9 推荐11 推荐13 推荐15 推荐17 推荐19 推荐21 推荐23 推荐25 推荐27 推荐29 推荐31 推荐33 推荐35 推荐37视频文章20视频文章30视频文章40视频文章50视频文章60 视频文章70视频文章80视频文章90视频文章100视频文章120视频文章140 视频2关键字专题关键字专题tag2tag3文章专题文章专题2文章索引1文章索引2文章索引3文章索引4文章索引5123456789101112131415文章专题3
当前位置: 首页 - 科技 - 知识百科 - 正文

配置文件-mysql非安装版无法启动报1067错误

来源:懂视网 责编:小采 时间:2020-11-09 16:32:54
文档

配置文件-mysql非安装版无法启动报1067错误

配置文件-mysql非安装版无法启动报1067错误:配置文件mysql 在网上查说是配置文件的事。my.ini复制自my_small.ini。只增加了mysql字段basedir = D:/mysql-5.5.24-winx64datadir = D:/mysql-5.5.24-winx64/datacharacter-set-server=utf8client字段defaul
推荐度:
导读配置文件-mysql非安装版无法启动报1067错误:配置文件mysql 在网上查说是配置文件的事。my.ini复制自my_small.ini。只增加了mysql字段basedir = D:/mysql-5.5.24-winx64datadir = D:/mysql-5.5.24-winx64/datacharacter-set-server=utf8client字段defaul

配置文件mysql

在网上查说是配置文件的事。
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也还是这个错误。

文档

配置文件-mysql非安装版无法启动报1067错误

配置文件-mysql非安装版无法启动报1067错误:配置文件mysql 在网上查说是配置文件的事。my.ini复制自my_small.ini。只增加了mysql字段basedir = D:/mysql-5.5.24-winx64datadir = D:/mysql-5.5.24-winx64/datacharacter-set-server=utf8client字段defaul
推荐度:
  • 热门焦点

最新推荐

猜你喜欢

热门推荐

专题
Top