List:General Discussion« Previous MessageNext Message »
From:Tianyin Xu Date:November 12 2012 9:47pm
Subject:Re: mysqld cannot start.
View as plain text  
Hi, Larry,

Thanks a lot for the reply!


On Mon, Nov 12, 2012 at 1:27 PM, Larry Martell <larry.martell@stripped>wrote:

> On Mon, Nov 12, 2012 at 2:11 PM, Tianyin Xu <tixu@stripped> wrote:
> > Hi, guys,
> >
> > I'm new to MySQL. I installed MySQL step-by-step according to the manual
> > from source code. The version is mysql-5.5.28.
> >
> > When I start the server using:
> > #bin/mysqld_safe --user=mysql
> >
> > The server failed to start with the following message in the log
> (attached
> > below).
> >
> > There're two problems according to the log messages:
> >
> > 1.
> >
> > 121112 13:00:59 [ERROR] Can't read from messagefile
> > '/usr/local/mysql/data/errmsg.sys
> >
> > I'm confused because I do have this file which is owned by user "mysql":
> >
> > #ll /usr/local/mysql/data/errmsg.sys
> > -rw-r--r-- 1 mysql mysql 0 Nov 12 12:35 /usr/local/mysql/data/errmsg.sys
>
> Check the permissions of all the dirs in that path: /usr, /usr/local,
> /usr/local/mysql, /usr/local/mysql/data. The mysql user will need r-x
> access to all of them.
>
>
I already did so. It's weird... From the log, it seems that mysqld
encountered some problem when reading the messagefile. But the file does
exist with permission.



> > 2.
> >
> > 121112 13:00:59 [ERROR] An old style --language value with language
> > specific part detected: /usr/local/mysql/data/
> >
> > I commented the "lc-messages-dir" configuration entry in the my.cnf, but
> > the error still exists...
>
> Don't know what platform you're on, but on my Mac I had this issue,
> and I got around it by starting the server with:
>
> --lc-messages-dir="/usr/local/mysql/share/"
>

I'm working on Ubuntu-12.04. Yes, the configuration parameter is set as
/usr/local/mysql/data/ (see the error message). I tried your setting but
this time mysqld tells me

121112 13:46:28 [ERROR] bin/mysqld: unknown variable
'lc-message-dir=/usr/local/mysql/share/'
121112 13:46:28 [ERROR] Aborting

What a mess...



>
> On CentOS and RHEL I did not have this issue.
>
> HTH-
> larry
>


Probably I shall go to GDB to understand what's happening here...

Great thanks!
T

-- 
Tianyin XU,
http://cseweb.ucsd.edu/~tixu/

Thread
mysqld cannot start.Tianyin Xu12 Nov
  • Re: mysqld cannot start.Larry Martell12 Nov
    • Re: mysqld cannot start.Tianyin Xu12 Nov
      • Re: mysqld cannot start.Tianyin Xu12 Nov