Hello,

The complie was sucessed, but I can't start the service by
/usr/local/share/mysql/mysql.server

[root@mysql mysql]# ./mysql.server start
Starting MySQL.Manager of pid-file quit without updating fi[FAILED]
[root@mysql mysql]#

Thx

For successful installation you should follow these steps.

[root@localhost mysql-5.0.45]# groupadd mysql
[root@localhost mysql-5.0.45]# useradd -g mysql mysql
[root@localhost mysql-5.0.45]# ./configure --prefix=/usr/local/mysql--enable-thread-safe-client
make
make install


cp /mysql-5.0.45/support-files/my-huge.cnf /etc/my.cnf
cp /mysql-5.0.45/support-files/mysql.server /etc/rc.d/init.d/mysql
cd /etc/rc.d/init.d/
chmod 755 mysql
cd /data01/lamp/mysql
chown -R mysql .
chgrp -R mysql .
bin/mysql_install_db --user=mysql
chown -R root .
chown -R mysql var
bin/mysqld_safe --user=mysql &

cd /usr/bin/
ln -s /usr/local/mysql/bin/mysql .
ln -s /usr/local/mysql/bin/mysql_config .
ln -s /usr/local/mysql/bin/mysqldump .
ln -sf -s /usr/local/mysql/bin/mysql .
cd /usr/lib/
ln -sf /usr/local/mysql/lib/mysql/lib* .
cd /usr/include/
mkdir mysql
cd /usr/include/mysql/
ln -sf /usr/local/mysql/include/mysql/* .



now you give service mysql start

then it will start successfully.

Regards,
Prakash.

Thank you, I will try this method later, but I want to know what's data01?

Could you explain the following lines?

what's cd /data01/lamp/mysql
chown -R mysql .
chgrp -R mysql .
bin/mysql_install_db --user=mysql
chown -R root .
chown -R mysql var
bin/mysqld_safe --user=mysql &

Line 1: I don't know what's data01

Line 2: So I can't find a mysql file to change owner and group

Line 5: Don't know where's root, mysql and var files.


Thanks

Hi,


Sorry for that data01/lamp/mysql.

Its just the prefix i used to store mysql files. You can have it as /usr/local/mysql if you follow my above steps as

./configure --prefix=/usr/local/mysql--enable-thread-safe-client


All that lines say about giving complete permissions to user mysql which you created in the first statement i have posted.



For this, if you give any prefix statement in addition to ./configure step you will find these directories in that location.

If you did not give any prefix there, you will find these files in /usr/local/ bin or var or what ever it is.

Regards,
Prakash.

ok , thanks