Mysql Installation from source but not succeeded yet
 

Hello all there.......
Please anybody help me out in installing mysql form source. I am installing mysql from tarball. But getting problem to install mysqld service and unable to start mysql sevice. When i'm installing there is problem to generate the /usr/local/src/mysql/data/ directory. I've download the mysql-4.0.22.tar.gz version for installation and my operationg system is CentOS 4.
First I've untared the mysql tar in /usr/local/src then i created group and user for mysql with following commands:
#groupadd mysql
#useradd *g mysql *c "MySQL Server" *d /dev/null *s /sbin/nologin mysql
then
compiled the ./configure file with following parameters:
#./configure \
**prefix=/usr/local/mysql \
**localstatedir=/usr/local/mysql/data \
**disable*maintainer*mode \
**with*mysqld*user=mysql \
**with*unix*socket*path=/tmp/mysql.sock \
**without*comment \
**without*debug \
**without*bench
then i run make && make install command and it got installed successfully. After thar i installed initial databases by running ./scripts/mysql_install_db script and now when i'm changing the ownership for following dirictories it's giving me error /usr/local/mysql/data directory not exist.
#chown *R root:mysql /usr/local/mysql
#chown *R mysql:mysql /usr/local/mysql/data
why is it so please help me out solving this problem.
plz.....

Have you checked to see if the /usr/local/mysql directory exists? How about the /usr/local/mysql/data directory?? If not, why don't you try to create it? It doesn't show where you're actually looking for that directory, just that you're trying to chown it.

Hello TBone thanks for your reply very soon...
Yes the /usr/local/mysql directory is exist, but only the data directory won't. And as per ur suggetion i've tried creating data directory manually but it didn't work.
Now if you have tried installing mysql from source before then plz write what you did from scratch step by step, it will help me more...
thanks once again....