服务器退出而不更新pid文件,Mysql启动问题|错误！服务器退出而不更新PID文件

最新推荐文章于 2024-12-16 10:29:14 发布

weixin_39540834

最新推荐文章于 2024-12-16 10:29:14 发布

阅读量497

点赞数

文章标签：服务器退出而不更新pid文件

用户在尝试启动MySQL服务器时遇到了错误，错误信息指出服务器未能更新PID文件，并且在日志中提到了'default-character-set=utf8'变量未知。这可能是由于MySQL配置文件中的设置问题导致的。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Joshs-MacBook-Pro:cdwhp joshc$ mysql.server start

Starting MySQL

.. ERROR! The server quit without updating PID file (/usr/local/var/mysql/Joshs-MacBook-Pro.local.pid).

错误日志

120927 13:08:35 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql

120927 13:08:36 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive

120927 13:08:36 InnoDB: The InnoDB memory heap is disabled

120927 13:08:36 InnoDB: Mutexes and rw_locks use GCC atomic builtins

120927 13:08:36 InnoDB: Compressed tables use zlib 1.2.5

120927 13:08:36 InnoDB: Initializing buffer pool, size = 128.0M

120927 13:08:36 InnoDB: Completed initialization of buffer pool

120927 13:08:36 InnoDB: highest supported file format is Barracuda.

120927 13:08:36 InnoDB: Waiting for the background threads to start

120927 13:08:37 InnoDB: 1.1.8 started; log sequence number 9531786

120927 13:08:37 [ERROR] /usr/local/Cellar/mysql/5.5.27/bin/mysqld: unknown variable 'default-character-set=utf8'

120927 13:08:37 [ERROR] Aborting

120927 13:08:37 InnoDB: Starting shutdown...

120927 13:08:37 InnoDB: Shutdown completed; log sequence number 9531786

120927 13:08:37 [Note] /usr/local/Cellar/mysql/5.5.27/bin/mysqld: Shutdown complete

120927 13:08:37 mysqld_safe mysqld from pid file /usr/local/var/mysql/Joshs-MacBook-Pro.local.pid ended

它看起来像你使用自制mysql安装。错误日志的位置在哪里？我遇到了类似的问题，但无法找到日志位置。 –

看看另一个问题的确切答案http://www.stackoverflow.com/questions/4963171/mysql-server-startup-error-the-server-quit-without-updating-pid-file –