Installing MySQL from source on linux

[Albert.Nawaro]

DOWNLOAD AND COMPILE

cd /usr/local/src 
wget http://dev.mysql.com/get/Downloads/MySQL-5.1/mysql-5.1.25-rc.tar.gz/from/http://mysql.he.net/ 
tar -zxvf mysql-5.1.25-rc.tar.gz 
cd mysql-5.1.25-rc 
./configure --prefix=/usr --enable-assembler --with-innodb 
make 
make install 

CREATE mysql USER


On ssh prompt, run

groupadd mysql 
useradd -g mysql -d /var/lib/mysql mysql 

Create log file

touch /var/log/mysqld.log 
chown mysql:mysql /var/log/mysqld.log 
chown -R mysql:mysql /backup/mysql 

init SCRIPT

      cp support-files/mysql.server /etc/rc.d/init.d/mysql 
chmod 755 /etc/rc.d/init.d/mysql 

CREATING /etc/my.cnf

Before you can start mysql, you need to create my.cnf gile

 vi /etc/my.cnf 

I have mysql data folder in /backup/mysql (default location is /var/lib/mysql), on my server my.cnf is

      [root@server52 php-5.2.6]# cat /etc/my.cnf 
[mysqld] 
datadir=/backup/mysql 
socket=/backup/mysql/mysql.sock 

[mysql.server] 
user=mysql 

[mysqld_safe] 
log-error=/var/log/mysqld.log 
pid-file=/var/run/mysqld/mysqld.pid 

[mysql] 
socket=/backup/mysql/mysql.sock 

[root@server52 php-5.2.6]# 

CREATE INITIAL DATABASE

Now create the initial database with

 ./scripts/mysql_install_db 

Here is what you get on running the command.

     
      [root@server52 mysql-5.1.23-ndb-6.2.15]# ./scripts/mysql_install_db 
Installing MySQL system tables... 
OK 
Filling help tables... 
OK 

To start mysqld at boot time you have to copy 
support-files/mysql.server to the right place for your system 

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! 
To do so, start the server, then issue the following commands: 

/usr/bin/mysqladmin -u root password 'new-password' 
/usr/bin/mysqladmin -u root -h server52.hosthat.com password 'new-password' 

Alternatively you can run: 
/usr/bin/mysql_secure_installation 

which will also give you the option of removing the test 
databases and anonymous user created by default.  This is 
strongly recommended for production servers. 

See the manual for more instructions. 

You can start the MySQL daemon with: 
cd /usr ; /usr/bin/mysqld_safe & 

You can test the MySQL daemon with mysql-test-run.pl 
cd /usr/mysql-test ; perl mysql-test-run.pl 

Please report any problems with the /usr/bin/mysqlbug script! 

The latest information about MySQL is available at http://www.mysql.com/ 
Support MySQL by buying support/licenses from http://shop.mysql.com/ 

[root@server52 mysql-5.1.23-ndb-6.2.15]# 

STARTING MySQL

To start MySQL run

 /etc/rc.d/init.d/mysql start 

If you have any problem with mysql startup, run

 /bin/sh -x /etc/rc.d/init.d/mysql start 

This will give you detailed information on what the start up script is doing and help you to fix the problem.

Also check the file /var/log/mysqld.log
STARTING MySQL ON BOOT

Run following commands to start MySQL on boot.

chkconfig --add mysql 
chkconfig mysql on 
chkconfig --list mysql 

Or you can enable mysql on graphical interface with command

ntsysv

START/STOP MySQL

service mysql stop 
service mysql start 

You can also use the init script directly.

      [root@server52 ~]# /etc/init.d/mysql 
Usage: /etc/init.d/mysql  {start|stop|restart|reload|force-reload|status}  [ MySQL server options ] 
[root@server52 ~]# 

AVOID MYSQL OVERWRITE BY YUM

When you install some program from yum (for example yum install exim) will install mysql also, will over write your existing MySQL installation.

To avoid happening this, edit /etc/yum.conf, add following line just below [main]

 exclude=mysql* 

echo "/usr/lib/mysql" >> /etc/ld.so.conf 
ldconfig 
ldconfig -p|grep mysql 

Albert.Nawaro Reviewed by Albert.Nawaro on 20th Feb 2012. Installing MySQL from source on linux DOWNLOAD AND COMPILE cd /usr/local/src wget http://dev.mysql.com/get/Downloads/MySQL-5.1/mysql-5.1.25-rc.tar.gz/from/http://mysql.he.net/ tar -zxvf mysql-5.1.25-rc.tar.gz cd mysql-5.1.25-rc ./configure --prefix=/usr --enable-assembler --with-innodb make Rating: 5