mac双系统win10：无法启动MySQL服务错误1067

admin 数据库 2019-03-12 3245浏览 0

解决方法：

在配置文件my.ini内添加如下配置（[mysqld]下）

innodb_buffer_pool_size        = 256M
innodb_log_file_size           = 256M
innodb_thread_concurrency      = 16
innodb_flush_log_at_trx_commit = 2
innodb_flush_method            = normal

然后删除data目录下的文件

DESKTOP-K1N1S7A.err
ib_logfile0
ib_logfile1
ibdata1

重新安装即可！

官方解决方法：https://bugs.mysql.com/bug.php?id=85020

Make a fresh installation of mysql when it hang "in service start..."
make this:
open with notepad++ the file my.ini file and to innodb section add this:
#*** INNODB Specific options ***
innodb_buffer_pool_size        = 256M
innodb_log_file_size           = 256M
innodb_thread_concurrency      = 16
innodb_flush_log_at_trx_commit = 2
innodb_flush_method            = normal

Save the file, after
go a usually on windows
c:\ProgramData\MySQL\MySQL Server5.5\data and cancel this file:
DESKTOP-K1N1S7A.err
ib_logfile0
ib_logfile1
ibdata1

Now you can resume the installation ad yoy see the service start.
Note, If the installation not continue... no problem, close ed remake the installation.

转载请注明：梦绘设计 » 数据库 » mac双系统win10：无法启动MySQL服务错误1067