错误！找不到MySQL管理器或服务器PID文件！品质保证计划 [英] ERROR! MySQL manager or server PID file could not be found! QNAP

问题描述

我遇到了QNAP NAS上无法启动MySQL的问题.

I am having an issue where MySQL isn't starting on my QNAP NAS.

我首先无法通过phpMyAdmin登录，发现了这一点-出现错误:

I found this first by not being able to log in through phpMyAdmin - was getting error:

#2002 Cannot log in to the MySQL server

然后我尝试启动mysql，因为我猜这是一个普遍的问题，但它只是给出了一个一般性错误.

I then went to attempt to start mysql, as I guess this is a common issue with this, but it just gave a generic error.

我对mysql.sock文件和所有内容进行了故障排除，更改了其权限，但是没有任何效果.

I went through troubleshooting the mysql.sock file and everything, changing its permissions, but nothing is working.

我已经多次重启NAS.

I have rebooted my NAS many times.

我最终尝试重新启动mysql.这样我得到:

I eventually tried to restart mysql. In doing so I get:

ERROR! MySQL manager or server PID file could not be found!

我找不到任何特定于QNAP的内容或任何常规类型的疑难解答.我发现的所有内容似乎都与OSX有关.

I can't find anything specific to the QNAP or any general type troubleshooting for this. Everything I find seems to be OSX related.

推荐答案

我最终自己搞清楚了.

在搜索日志时，我进入了

In searching for my logs I went into

cd /usr/local/mysql/var

在其中找到名为[MyNAS] .pid的文件(用您的NAS的名称替换[MyNAS].

In there I found the file named [MyNAS].pid (replace [MyNAS] with the name of your NAS.

然后我运行以下命令删除文件

I then ran the following to remove the file

rm -rf /usr/local/mysql/var/[MyNAS].pid

然后我重新启动mysql

I then restarted mysql

[/usr/local/mysql/var] # /etc/init.d/mysqld.sh restart        
/mnt/ext/opt/mysql
/mnt/ext/opt/mysql
Try to shutting down MySQL
ERROR! MySQL manager or server PID file could not be found!
/mnt/ext/opt/mysql
Starting MySQL. SUCCESS! 

我测试了所有内容，一切再次变得像魅力！

I tested everything and it all works like a charm again!

这篇关于错误！找不到MySQL管理器或服务器PID文件！品质保证计划的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！