MySQL 数据库无法在 XAMPP for Mac 上启动-php问题

MySQL Database cannot start on XAMPP for Mac(MySQL 数据库无法在 XAMPP for Mac 上启动)

本文介绍了MySQL 数据库无法在 XAMPP for Mac 上启动的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

突然间，我在我的 mac 上遇到了这个问题.我无法启动我的 MySQL 数据库.我只能启动我的 ProFTPD 和 Apache Web 服务器.

All of a sudden I am encountering this problem on my mac. I cant start my MySQL Database. I can only start my ProFTPD and Apache Web Server.

这是应用程序日志:

Starting all servers...
Starting MySQL Database...

Starting Apache Web Server...
/Applications/XAMPP/xamppfiles/apache2/scripts/ctl.sh : httpd started
Starting ProFTPD...
Checking syntax of configuration file
/Applications/XAMPP/xamppfiles/proftpd/scripts/ctl.sh : proftpd started

我什至通过 stackoverflow 做了一些研究.首先，我试图通过我的活动监视器结束该过程，因为我在过滤器搜索区域中找不到关键字 sql.我尝试的第二种方法是添加 unset DYLD_LIBRARY_PATH但这甚至对我都没有用.

I have even did some research through stackoverflow. First i tried to end the process through my activity monitor by i couldnt find the keyword sql on the filter search area. The second method i tried was adding the unset DYLD_LIBRARY_PATHbut that didnt even worked for me.

我能知道如何解决这个问题吗?帮助将不胜感激.谢谢

Can i know how to solve this problem. Helps would be really appreciated. Thank you

推荐答案

#1. Open XAMPP Installation Directory
#2. Open "etc" Folder
#3. Find "my.cnf" file and open it in any text editor
#4. Change Port from 3306 to 3307 (if you have installed skype or other apps)
#5. Add "innodb_force_recovery=1" under "myisam_sort_buffer_size=8M"
#6. Save "my.cnf" file
#7. Restart Mysql Server By Your Terminal by command:
"sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start" 

You Get A message "Starting MySQL SUCCESS! "

这篇关于MySQL 数据库无法在 XAMPP for Mac 上启动的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！