在Mac OS X v10.6 (Snow Leopard)上，启动MySQL会出现以下错误:
服务器退出，没有更新PID文件
文件my.cnf
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 16K
pid-file=/var/run/mysqld/mysqld.pid
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
当前回答
不知何故，我搞砸了我在Mac OS X v10.11 (El Capitan)上的权限，决定从头开始重新安装MySQL。
我在El Capitan上使用Homebrew，并决定重新安装:
brew uninstall mysql
sudo rm -rf /usr/local/var/mysql
brew install mysql
mysql.server start # ... SUCCESS
新安装的文件权限从_mysql更改为包含我的用户名:
ls -alh /usr/local/var/mysql
drwxr-xr-x 22 lfender admin 748B Mar 22 09:58 .
# ... etc.
其他回答
尝试查找后缀为“.err”的日志文件。应该有更多的信息。它可能在:
/usr/local/var/mysql/your_computer_name.local.err
可能是权限有问题
检查是否有MySQL实例正在运行 Ps -ef | grep mysql 如果是，你应该停止它，或者终止进程: kill -9 PID 其中PID是显示在前一个命令输出的用户名旁边的数字 检查/usr/local/var/mysql/的所有权 ls -laF /usr/local/var/mysql/ 如果它是root的owner，你应该把它改为mysql或your_user sudo chown -R mysql /usr/local/var/mysql/
将日志文件“ib_logfile”移到“/var/lib/mysql”目录下，重启mysql。有时mysql会失败，因为它面临更新日志文件的困难
mv /var/lib/mysql/ib_logfile* /some/tmp/folder/
你也可以删除ib_logfile，因为它会在mysql重启后自动创建
现在重启mysql服务器
我希望这对你有用。
在检查错误日志后，我发现了这个:
120309 17:42:49 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
120309 17:42:50 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
120309 17:42:50 [Warning] You need to use --log-bin to make --binlog-format work.
120309 17:42:50 [Note] Plugin 'FEDERATED' is disabled.
120309 17:42:50 InnoDB: The InnoDB memory heap is disabled
120309 17:42:50 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120309 17:42:50 InnoDB: Compressed tables use zlib 1.2.3
120309 17:42:50 InnoDB: Initializing buffer pool, size = 16.0M
120309 17:42:50 InnoDB: Completed initialization of buffer pool
120309 17:42:50 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name /usr/local/mysql/data/ib_logfile0
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
120309 17:42:50 mysqld_safe mysqld from pid file /usr/local/mysql/data/lu1s.local.pid ended
为了解决这个问题，我给了整个mysql文件夹的所有权:
cd /usr/local
sudo chown mysql mysql
sudo chown mysql mysql-5.5.21-osx10.6-x86_64
sudo chown _mysql mysql
sudo chown _mysql mysql-5.5.21-osx10.6-x86_64
然后(你也可以做命令行)，我应用权限(一旦我把所有权给_mysql和mysql用户)，从文件夹/usr/local/mysql-5.5.21-osx10.6-x86_64的“获取信息”菜单中的所有附带的文件夹。你不需要把它传给别名，因为它只是一个别名。
文件夹的名称取决于MySQL的安装版本。
这是macOS中MySQL数据库最简单的“PID”错误解决方案:
执行如下命令:
$ sudo mysql.server start
Starting MySQL
.. SUCCESS!
使用此命令访问数据库:
$ mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 19
Server version: 8.0.31 Homebrew
Copyright (c) 2000, 2022, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
| Database |
|---|
| information_schema |
| mysql |
| performance_schema |
| sys |
| 4 rows in set (0.00 sec) |
我的回答很不专业，我不理解。我用的是CentOS和通用版的MySQL…当我用root用户启动mysql时，我的问题用——user=root解决了:
/path/to/mysql/support-files/mysql.server start --user=root
如果你正在使用systemctl启动mysql。服务，您需要更改mysql。/etc/systemd/system/mysql.service中的服务文件:
.
.
.
ExecStart=/path/tp/mysql/support-files/mysql.server start --user=root
ExecStop=/path/to/mysql/support-files/mysql.server stop --user=root
.
.
.
