MySQL 数据库不会在 XAMPP Manager-osx 中启动

2022-01-14 00:00:00 macos xampp php mysql

我大约一个月前下载了 XAMPP,它运行良好.今天我安装了一个语音识别软件,然后重新启动了我的电脑.从那时起,MySQL 就不会在我的 manager-osx 应用程序中启动.它不会让我在应用程序日志中出现问题.它是这样说的:

I downloaded XAMPP about a month ago and it was working just fine. Today I installed a voice recognition software and then restarted my computer. Ever since, MySQL won't start in my manager-osx application. It doesn't throw me an in the application log. This is what it says:

Stopping all servers...
Stopping Apache Web Server...
/Applications/XAMPP/xamppfiles/apache2/scripts/ctl.sh : httpd stopped
Stopping ProFTPD...
Checking syntax of configuration file
/Applications/XAMPP/xamppfiles/proftpd/scripts/ctl.sh : proftpd stopped
Restarting 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

我的 ProFTPD 和我的 Apache Web 服务器都在运行.MySQL 不是.当我转到 phpmyadmin 时,它会向我抛出此错误消息.

Both my ProFTPD and my Apache Web Server are running. MySQL isn't. When I go to phpmyadmin, it throws me this error message.

#2002 - No such file or directory
The server is not responding (or the local server's socket is not correctly configured).

请帮助我.我不知道该怎么办.

Please help me. I have no idea what to do.

更新:

在网上浏览了一下之后,我发现一个用户在使用 MAMP 时遇到了类似的问题,另一个用户建议杀死 mysql 进程,这意味着什么.这可以解决我的问题吗?

After looking around the internet a bit, I found a similar problem a user had with MAMP, another user recommended killing the mysql process, what ever that means. Could this be a fix to my problem?

更新 2:

我找到了问题的答案,但我还不能回答.所以这里是答案:

I found the answer to my problem but I can't answer it yet. So here's the answer:

1) 打开终端并输入

sudo su

然后输入你的密码

2) 然后输入

ps aux | grep mysql

(复制粘贴即可)

3) 你需要获取mysql的进程ID.顶部附近应该有数字,例如 739 或 8827

3) You will need to get the process id of mysql. There should be number near the top, something like 739 or 8827

4) 使用终止进程

kill -9 {process id}

这应该看起来像这样:kill -9 739

this should look something like this: kill -9 739

5) 在 manager-osx 中重启 MySQL

5) Restart MySQL in manager-osx

推荐答案

小指南

1.sudo killall mysqld

2.manager-osx > 启动mysql

2. manager-osx > start mysql

sudo/Applications/XAMPP/xamppfiles/bin/mysql.server 启动

Google 错误...

错误:

错误!服务器退出而不更新PID文件(/Applications/XAMPP/xamppfiles/var/mysql/.local.pid)

我的解决方案:

/Applications/XAMPP/xamppfiles/etc/my.cnf 中将 user = <uid> 改为 <uid>id 命令中的 uid.

In /Applications/XAMPP/xamppfiles/etc/my.cnf change user = <uid> s that <uid> is uid from id command.

$ id
uid=...

$ vim /Applications/XAMPP/xamppfiles/etc/my.cnf
...

相关文章