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
> > 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:
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
121112 13:46:28 [ERROR] Aborting
What a mess...
> On CentOS and RHEL I did not have this issue.
Probably I shall go to GDB to understand what's happening here...