MySQL数据库无法在XAMPP Manager-osx中启动 [英] MySQL Database won't start in XAMPP Manager-osx

问题描述

我大约一个月前下载了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}

这应该看起来像这样:杀死-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

Minimal Guide

1. sudo killall mysqld

2. manager-osx>启动mysql

2. manager-osx > start mysql

sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start

Google错误...

错误:

ERROR! The server quit without updating PID file (/Applications/XAMPP/xamppfiles/var/mysql/<computername>.local.pid)

我的解决方案:

在/Applications/XAMPP/xamppfiles/etc/my.cnf中，从id命令更改user = <uid>，使<uid>是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
...

这篇关于MySQL数据库无法在XAMPP Manager-osx中启动的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！