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 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... Could anyone take a look at the error log? Thanks a lot! T -------------------------------------------------------------- 121112 13:00:59 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 121112 13:00:59 [ERROR] An old style --language value with language specific part detected: /usr/local/mysql/data/ 121112 13:00:59 [ERROR] Use --lc-messages-dir without language specific part instead. 121112 13:00:59 [ERROR] Can't read from messagefile '/usr/local/mysql/data/errmsg.sys' 121112 13:00:59 InnoDB: The InnoDB memory heap is disabled 121112 13:00:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins 121112 13:00:59 InnoDB: Compressed tables use zlib 1.2.3.4 121112 13:00:59 InnoDB: Initializing buffer pool, size = 128.0M 121112 13:00:59 InnoDB: Completed initialization of buffer pool 121112 13:00:59 InnoDB: highest supported file format is Barracuda. 121112 13:00:59 InnoDB: Waiting for the background threads to start 121112 13:01:00 InnoDB: 1.1.8 started; log sequence number 1595675 121112 13:01:00 [ERROR] Aborting 121112 13:01:00 InnoDB: Starting shutdown... 121112 13:01:00 InnoDB: Shutdown completed; log sequence number 1595675 121112 13:01:00 [Note] 121112 13:01:00 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 121112 13:03:49 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 121112 13:03:49 [ERROR] Can't find messagefile '/usr/share/errmsg.sys' 121112 13:03:49 InnoDB: The InnoDB memory heap is disabled 121112 13:03:49 InnoDB: Mutexes and rw_locks use GCC atomic builtins 121112 13:03:49 InnoDB: Compressed tables use zlib 1.2.3.4 121112 13:03:49 InnoDB: Initializing buffer pool, size = 128.0M 121112 13:03:49 InnoDB: Completed initialization of buffer pool 121112 13:03:49 InnoDB: highest supported file format is Barracuda. 121112 13:03:49 InnoDB: Waiting for the background threads to start 121112 13:03:50 InnoDB: 1.1.8 started; log sequence number 1595675 121112 13:03:50 [ERROR] Aborting 121112 13:03:50 InnoDB: Starting shutdown... 121112 13:03:50 InnoDB: Shutdown completed; log sequence number 1595675 121112 13:03:50 [Note] 121112 13:03:50 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended -- Tianyin XU, http://cseweb.ucsd.edu/~tixu/