Hi, Larry, Thanks a lot for the reply!
On Mon, Nov 12, 2012 at 1:27 PM, Larry Martell <larry.mart...@gmail.com>wrote: > On Mon, Nov 12, 2012 at 2:11 PM, Tianyin Xu <t...@cs.ucsd.edu> 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/