mysql - 服务器退出而不更新 PID 文件 - Ubuntu 12.04 服务器

Question

我点击此链接升级我的 mysql，https://rtcamp.com/tutorials/mysql/mysql-5-6-ubuntu-12-04/

这篇文章ubuntu是x64的，但是我的ubuntu是x32的，所以我把下载链接改成http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.16-debian6.0 -i686.deb

当我完成安装后，当我输入以下命令启动 mysql 时:$ service mysql.server start

它提醒我:

Starting MySQL
. * The server quit without updating PID file (/var/run/mysqld/mysqld.pid).

当我尝试输入 service mysql-server restart 时，它提醒我一点不同:

 * MySQL server PID file could not be found!
Starting MySQL
. * The server quit without updating PID file (/var/run/mysqld/mysqld.pid).

可能有一些帮助:

• my.cnf 位于/etc/mysql/my.cnf
• ps 辅助 | grep mysql 将在键入 ps aux | 时显示不同的 PID | grep mysql 再次

my.cnf 文件有如下行

# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port        = 3306
socket      = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket      = /var/run/mysqld/mysqld.sock
nice        = 0

Answer 1

在文件夹“/var/run/mysqld/”中创建一个名为“mysqld.pid”的新文件然后编辑该文件，将第 1 行设置为:例如 1329 然后再次启动服务器