试图在CentOS 6.4 / 64位服务器上安装MySQL(用于WordPress)。
我已经安装了mysql-server-5.1.69-1.el6_4.x86_64包并执行了以下命令:
# chkconfig mysqld on # service mysqld start # /usr/bin/mysqladmin -u root password 'xxxxx' # /usr/bin/mysql_secure_installation
然后我注意到, mysqld_safe进程正在监听0.0.0.0,并决定改变 – 以便我的WordPress安装只使用域套接字(或unixpipe道?不知道正确的术语)。
所以我修改了/etc/my.cnf来:
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 bind-address = localhost skip-networking enable-named-pipe [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
但是现在MySQL拒绝启动:
# service mysqld restart Stopping mysqld: [ OK ] MySQL Daemon failed to start. Starting mysqld: [FAILED]
/var/log/mysqld.log包含:
mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql InnoDB: Initializing buffer pool, size = 8.0M InnoDB: Completed initialization of buffer pool InnoDB: Started; log sequence number 0 44233 [ERROR] /usr/libexec/mysqld: unknown option '--enable-named-pipe' [ERROR] Aborting InnoDB: Starting shutdown... InnoDB: Shutdown completed; log sequence number 0 44233 [Note] /usr/libexec/mysqld: Shutdown complete mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
我search了Google,并为该指令写了grepped /usr/share/mysql/*.cnf ,但是还没有find任何提示。
没有提示?
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 bind-address = localhost skip-networking enable-named-pipe <------------------- [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
根据该版本的MySQL的在线文档 :
--enable-named-pipe Command-Line Format --enable-named-pipe Option-File Format enable-named-pipe Platform Specific windows <--------------------
启用对命名pipe道的支持。 该选项只能用于支持命名pipe道连接的mysqld-nt和mysqld-debug服务器。
从/etc/my.cnf删除该设置并重新启动该进程。