From: Michael Dykman Date: February 6 2012 8:54pm Subject: Re: mysql won't start with service, but starts with mysqld_safe List-Archive: http://lists.mysql.com/mysql/226738 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable On Mon, Feb 6, 2012 at 3:34 PM, Larry Martell wro= te: > On Mon, Feb 6, 2012 at 1:26 PM, Shawn Green (MySQL) > wrote: >> On 2/4/2012 19:57, Larry Martell wrote: >>> >>> Just installed mysql on centos 6.2. When I try to start it with service= I >>> get: >>> >>> #service mysqld start >>> MySQL Daemon failed to start. >>> Starting mysqld: =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 [FAILED] >>> >>> Nothing at all is written to the error log. >>> >>> But if I start it with mysqld_safe it comes up and works fine. >>> >>> Anyone know what could be going on here? >>> >>> -larry >>> >> >> If the daemon is attempting to change users during startup, then you mus= t be >> root when you start it. =A0Otherwise, become the user `mysql` then start= the >> daemon (service) under the proper credentials. >> >> http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld= _user > > I was root when issuing the 'service mysqld start' command. I just > tried it as the mysql user, and it failed in the same way. > > I traced the service mysqld start and I saw that it invoked > /etc/init.d/mysqld (which invokes mysqld_safe). When I invoke > /etc/init.d/mysqld (or mysqld_safe) the server comes up fine. Very > odd. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: =A0 =A0http://lists.mysql.com/mysql > I haven't seen it mentioned, so I'll give it a shot: Have you checked the permissions on your data directory? If you are getting no message in your .err file thhat is often the cause. It should be owned by the mysql user. --=20 =A0- michael dykman =A0- mdykman@stripped =A0May the Source be with you.