phpstudy安装后 启动mysql无限重启 错误日志显示以下内容

电脑用户994600

G3{PXQ0~7XQTIB(_D(NMEVB.png

首先是8.0.12的错误日志:

2020-04-30T07:07:53.966423Z 0 [System] [MY-010910] [Server] D:\phpstudy_pro\COM\..\Extensions\MySQL8.0.12\\bin\mysqld.exe: Shutdown complete (mysqld 8.0.12)  MySQL Community Server - GPL.

2020-04-30T07:07:56.331558Z 0 [System] [MY-010116] [Server] D:\phpstudy_pro\COM\..\Extensions\MySQL8.0.12\\bin\mysqld.exe (mysqld 8.0.12) starting as process 4568

2020-04-30T07:07:58.501682Z 0 [ERROR] [MY-011071] [Server] unknown variable 'query_cache_size=0'

2020-04-30T07:07:58.502682Z 0 [ERROR] [MY-010119] [Server] Aborting

2020-04-30T07:08:00.015769Z 0 [System] [MY-010910] [Server] D:\phpstudy_pro\COM\..\Extensions\MySQL8.0.12\\bin\mysqld.exe: Shutdown complete (mysqld 8.0.12)  MySQL Community Server - GPL.

2020-04-30T07:08:02.372904Z 0 [System] [MY-010116] [Server] D:\phpstudy_pro\COM\..\Extensions\MySQL8.0.12\\bin\mysqld.exe (mysqld 8.0.12) starting as process 7796

2020-04-30T07:08:04.559029Z 0 [ERROR] [MY-011071] [Server] unknown variable 'query_cache_size=0'

2020-04-30T07:08:04.560029Z 0 [ERROR] [MY-010119] [Server] Aborting

2020-04-30T07:08:06.082116Z 0 [System] [MY-010910] [Server] D:\phpstudy_pro\COM\..\Extensions\MySQL8.0.12\\bin\mysqld.exe: Shutdown complete (mysqld 8.0.12)  MySQL Community Server - GPL.

2020-04-30T07:08:08.344245Z 0 [System] [MY-010116] [Server] D:\phpstudy_pro\COM\..\Extensions\MySQL8.0.12\\bin\mysqld.exe (mysqld 8.0.12) starting as process 12456

2020-04-30T07:08:10.500369Z 0 [ERROR] [MY-011071] [Server] unknown variable 'query_cache_size=0'

之后是5.7.26的错误日志:

2020-04-30T03:54:49.877851Z 0 [ERROR] unknown variable 'table_cache=256'

2020-04-30T03:54:49.903852Z 0 [ERROR] Aborting

 

2020-04-30T03:54:52.377994Z 0 [ERROR] unknown variable 'table_cache=256'

2020-04-30T03:54:52.378994Z 0 [ERROR] Aborting

 

2020-04-30T03:54:55.336163Z 0 [ERROR] unknown variable 'table_cache=256'

2020-04-30T03:54:55.337163Z 0 [ERROR] Aborting

新手还没学习PHP 安装环境这卡了好久了 咋整 谢谢大家!

问题比较着急?请联系QQ:760483
  • 三三@xp.cn
  • 三三@xp.cn    2020-04-30 17:59:401楼

    能否贴一下 mysql8 的配置上来

    +添加回复

  • 回复

    [mysql] default-character-set=utf8 [mysqld] port=3306 default_authentication_plugin=mysql_native_password basedir=D:/phpstudy_pro/Extensions/MySQL8.0.12/ datadir=D:/phpstudy_pro/Extensions/MySQL8.0.12/data/ character-set-server=utf8 default-storage-engine=MyIsam collation-server=utf8_unicode_ci init_connect='SET NAMES utf8' innodb_buffer_pool_size=64M innodb_flush_log_at_trx_commit=1 innodb_lock_wait_timeout=120 innodb_log_buffer_size=4M innodb_log_file_size=256M interactive_timeout=120 join_buffer_size=2M key_buffer_size=32M log-error=D:/phpstudy_pro/Extensions/MySQL8.0.12/data log_error_verbosity=1 max_allowed_packet=16M max_connections=100 max_heap_table_size=64M myisam_max_sort_file_size=64G myisam_sort_buffer_size=32M read_buffer_size=512kb read_rnd_buffer_size=4M server_id=1 skip-external-locking=on sort_buffer_size=256kb table_open_cache=256 thread_cache_size=16 tmp_table_size=64M wait_timeout=120 [client] port=3306 default-character-set=utf8 这个是配置 下载后就没动过-。-

    电脑用户994600  作者 · 2020-04-30 18:26:55
    回复