When mysql daemon start, error message

[Choi Eun Kyoung]

When mysql daemon start, I have problem as below.. Help me


touch: /opt/mysql/var/icu6.err cannot create
chown: unknown user id mysql
Starting mysqld daemon with databases from /opt/mysql/var
./bin/safe_mysqld[229]: /opt/mysql/var/icu6.err: Cannot create the specified file.
./bin/safe_mysqld[235]: /opt/mysql/var/icu6.err: Cannot create the specified file.
tee: cannot open /opt/mysql/var/icu6.err
020823 18:00:28 mysqld ended
tee: cannot open /opt/mysql/var/icu6.err

[T G Manikandan]

I am not sure about the procedure to start mysql daemon but from the messages I can guess as

The daemon requires a user 'mysql'

I think you need to create a user with name mysql with home directory as /opt/mysql

Also you should provide a

chown -R mysql /opt/mysql

THanks

[T G Manikandan]

Just went through some pages found this.



//*

The basic commands you must execute to install a MySQL source distribution are:

shell> groupadd mysql
shell> useradd -g mysql mysql
shell> gunzip < mysql-VERSION.tar.gz | tar -xvf -
shell> cd mysql-VERSION
shell> ./configure --prefix=/opt/mysql
shell> make
shell> make install
shell> scripts/mysql_install_db
shell> chown -R root /opt/mysql
shell> chown -R mysql /opt/mysql/var
shell> chgrp -R mysql /opt/mysql
shell> cp support-files/my-medium.cnf /etc/my.cnf
shell> /opt/mysql/bin/safe_mysqld --user=mysql &
or
shell> /opt/mysql/bin/mysqld_safe --user=mysql &
if you are running MySQL 4.x.

*//