http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_skip-networking On Sep 13, 2013, at 6:44 AM, Alexander Farber <alexander.farber at gmail.com> wrote: > Hello, > > I've only had experience with PostgreSQL sofar, > but have now to install MySQL (and WordPress) > on a CentOS 6.4 /64 bit server. > > I have installed the mysql-5.1.69-1.el6_4.x86_64 > package and executed the following commands: > > # chkconfig mysqld on > # service mysqld start > # /usr/bin/mysqladmin -u root password 'xxxxx' > # /usr/bin/mysql_secure_installation > > Then I've noticed that mysqld_safe process > is listening at 0.0.0.0 and decided to change that - > so that my WordPress installation only uses > domain sockets (or unix pipes? not sure). > > So I've modified the /etc/my.cnf to: > > [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 > > But now MySQL refuses to start: > > # service mysqld restart > Stopping mysqld: [ OK ] > MySQL Daemon failed to start. > Starting mysqld: [FAILED] > > The /var/log/mysqld.log contains: > > 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 > > I've searched Google and grepped > /usr/share/mysql/*.cnf for that directive, > but haven't found any hints there. > > Any hints please? > > Regards > Alex > _______________________________________________ > CentOS mailing list > CentOS at centos.org > http://lists.centos.org/mailman/listinfo/centos