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
> There're two problems according to the log messages:
> 121112 13:00:59 [ERROR] Can't read from messagefile
> 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.
> 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:
On CentOS and RHEL I did not have this issue.