为啥我启动不了mysql

nathane

windows 小皮面板无法启动mysql,不管用哪个引擎。甚至换了几个mysql版本都没办法启动,端口也换过一样的状态!

问题比较着急?请联系QQ:760483
  • 唐大勇
  • 唐大勇    2020-12-15 17:14:162楼

    遇到同样的问题,windows上应该可以去apache网站下载,我在mac上回天无力了。

    +添加回复

  • 回复
  • Peter·Python
  • Peter·Python  已被采纳  2020-12-04 18:05:011楼

    要根据日志来判断问题

    +添加回复

  • 回复

    你好,这个问题解决了哈,原因是旧宝塔mysql服务和小皮冲突了,卸掉旧宝塔的mysql服务就正常了。 现在有两个新问题, 问题一: mac 版的小皮最新版,每次修改apache的端口,然后重新启动apchae,就会报如下错误: httpd: Syntax error on line 506 of /Applications/phpstudy/Extensions/Apache2.4.41/conf/httpd.conf: Cannot load modules/mod_log_rotate.so into server: dlopen(/Applications/phpstudy/Extensions/Apache2.4.41/modules/mod_log_rotate.so, 10): image not found 且查看当前apache的httpd.conf就会自动生成日志分割文本这些。。。如下: LoadModule log_rotate_module modules/mod_log_rotate.so RotateLogs On RotateLogsLocalTime On 然后mac系统下又没有这个文件,我去拿win下的拷贝过来用,启动apache也会报错: httpd: Syntax error on line 506 of /Applications/phpstudy/Extensions/Apache2.4.41/conf/httpd.conf: Cannot load modules/mod_log_rotate.so into server: dlopen(/Applications/phpstudy/Extensions/Apache2.4.41/modules/mod_log_rotate.so, 10): no suitable image found. Did find:\n\t/Applications/phpstudy/Extensions/Apache2.4.41/modules/mod_log_rotate.so: unknown file type, first eight bytes: 0x4D 0x5A 0x90 0x00 0x03 0x00 0x00 0x00\n\t/Applications/phpstudy/Extensions/Apache2.4.41/modules/mod_log_rotate.so: unknown file type, first eight bytes: 0x4D 0x5A 0x90 0x00 0x03 0x00 0x00 0x00 问题二:有时候点启动会卡在 正在启动... 或 正在关闭... 点重启功能也是这样的情况~

    nathane  作者 · 2020-12-05 22:08:45
    回复

    问题一,我自己的临时解决方法是注释掉或者删除掉这些 LoadModule log_rotate_module modules/mod_log_rotate.so RotateLogs On RotateLogsLocalTime On 但是改端口后启动,就会自己生成出来,所以又得重新删除或注释。

    nathane  作者 · 2020-12-05 22:11:57
    回复

    附上error_log的日志: [Sat Dec 05 21:09:34.151153 2020] [mpm_event:notice] [pid 25414:tid 4336979456] AH00489: Apache/2.4.41 (Unix) mod_fcgid/2.3.9 configured -- resuming normal operations [Sat Dec 05 21:09:34.151864 2020] [core:notice] [pid 25414:tid 4336979456] AH00094: Command line: '/Applications/phpstudy/Extensions/Apache2.4.41/bin/httpd' [Sat Dec 05 21:11:42.570045 2020] [mpm_event:notice] [pid 25414:tid 4336979456] AH00491: caught SIGTERM, shutting down [Sat Dec 05 21:11:44.723014 2020] [mpm_event:notice] [pid 25591:tid 4538183168] AH00489: Apache/2.4.41 (Unix) mod_fcgid/2.3.9 configured -- resuming normal operations [Sat Dec 05 21:11:44.723543 2020] [core:notice] [pid 25591:tid 4538183168] AH00094: Command line: '/Applications/phpstudy/Extensions/Apache2.4.41/bin/httpd' [Sat Dec 05 21:12:24.853988 2020] [mpm_event:notice] [pid 25591:tid 4538183168] AH00491: caught SIGTERM, shutting down [Sat Dec 05 21:13:47.624159 2020] [mpm_event:notice] [pid 25748:tid 4437818880] AH00489: Apache/2.4.41 (Unix) mod_fcgid/2.3.9 configured -- resuming normal operations [Sat Dec 05 21:13:47.624634 2020] [core:notice] [pid 25748:tid 4437818880] AH00094: Command line: '/Applications/phpstudy/Extensions/Apache2.4.41/bin/httpd' [Sat Dec 05 21:25:05.336971 2020] [mpm_event:notice] [pid 25748:tid 4437818880] AH00491: caught SIGTERM, shutting down [Sat Dec 05 21:25:06.661679 2020] [mpm_event:notice] [pid 26639:tid 4421271040] AH00489: Apache/2.4.41 (Unix) mod_fcgid/2.3.9 configured -- resuming normal operations [Sat Dec 05 21:25:06.662163 2020] [core:notice] [pid 26639:tid 4421271040] AH00094: Command line: '/Applications/phpstudy/Extensions/Apache2.4.41/bin/httpd' [Sat Dec 05 21:45:28.014573 2020] [mpm_event:notice] [pid 26639:tid 4421271040] AH00491: caught SIGTERM, shutting down

    nathane  作者 · 2020-12-05 22:13:12
    回复