Make sure mysql is the owner of /usr/local/mysql.
With Linux the command is
chown -R mysql /usr/local/mysql
This recursively makes mysql the owner, and keeps security tight.
Xiaolin Zhao wrote:
>Dear Gerald,
>
>Many thanks!
>
>I just did a chmod -R a+r, then everything is fixed.
>
>It is kind of lasy and security breaking act, but at
>least that confirms the nature of the problem.
>
>Best regards,
>
>Allen Zhao
>
>--- Gerald Clark <gerald_clark@stripped>
>wrote:
>
>>Make sure mysql has search privileges through all
>>the
>>directories to the file.
>>
>>Xiaolin Zhao wrote:
>>
>>>Hi,
>>>
>>>Yes, it is existing:
>>>
>>>ibmaix:/usr/local/mysql # ls -al
>>>./share/mysql/english/errmsg.sys
>>>-rw-r--r-- 1 mysql system 12183 Sep 09
>>>
>>17:02
>>
>>>./share/mysql/english/errmsg.sys
>>>
>>>The mysqld is run as mysql user.
>>>
>>>That is why I can not understand it.
>>>
>>>Any idea?
>>>
>>>Best regards,
>>>
>>>Allen Zhao
>>>
>>>
>>>
>>>--- Gerald Clark <gerald_clark@stripped>
>>>wrote:
>>>
>>>>Is the file there, and readable by the user
>>>>
>>'mysql'
>>
>>>>?
>>>>
>>>>Xiaolin Zhao wrote:
>>>>
>>>>>Hi, All
>>>>>
>>>>>I am trying to make MySQL 4.0.3b work with AIX
>>>>>
>>>>4.3.3.
>>>>
>>>>>But whenever I did the `./bin/safe_mysqld &`
>>>>>
>>>>command,
>>>>
>>>>>I get following error:
>>>>>
>>>>>020910 08:31:33 mysqld started
>>>>>020910 8:31:33 Can't find messagefile
>>>>>'mysql-4.0.3b/share/mysql/english/errmsg.sys'
>>>>>020910 8:31:33 Aborting
>>>>>
>>>>>020910 08:31:33 mysqld ended
>>>>>
>>>>>The mysql is installed under
>>>>>
>>>>/usr/local/mysql-4.0.3b,
>>>>
>>>>>and /usr/local/mysql is sym link to mysql-4.0.3b.
>>>>>
>>>>>Can anyone pinpoint what the problem is? TIA
>>>>>
>>>>>Best regards,
>>>>>
>>>>>Allen Zhao
>>>>>
>>
>
>
>__________________________________________________
>Do You Yahoo!?
>Yahoo! Finance - Get real-time stock quotes
>http://finance.yahoo.com
>
