Installation - MySQL (with embedded server)

Downloads install package: mysql-5.1.24-rc.tar.tar

# Add user/group for MySQL

> groupadd mysql

> useradd -g mysql mysql

>  tar zxf mysql-5.1.24-rc.tar.tar

> cd mysql-5.1.24-rc

# check, compile, and install

> ./configure --prefix=/usr/local/mysql5.1.24 --with-embedded-server 

> make

> make install

# configure modifier, db info

> cp support-files/my-medium.cnf /etc/my.cnf

> cd /usr/local/mysql5.1.24

> chown -R mysql .

> chgrp -R mysql .

> bin/mysql_install_db --user=mysql

> chown -R root .

> chown -R mysql var

> bin/mysqld_safe --user=mysql &

# as service

> rm -f /etc/rc.d/init.d/mysqld

> cp support-files/mysql.server /etc/rc.d/init.d/mysqld

> chmod +755 /etc/rc.d/init.d/mysqld

> /sbin/chkconfig --add mysqld

> /sbin/chkconfig --level 345 mysqld on

# as lib

> vi /etc/ld.so.conf

/usr/local/mysql5.1.24/lib/mysql

> ldconfig /etc/ld.so.conf

> ldconfig　－v | grep mysql  (Optional)