Installation, setup and configure of MySQL on Linux CentOS, Fedore, Red Hat and step by step.

Step 1 : Preparation of MySQL

[root@CIS /]# groupadd mysql
[root@CIS /]# useradd -g mysql mysql
[root@CIS /]# passwd mysql

[root@CIS /]# useadd john
[root@CIS /]# passwd john

Step 2 : Download Mysql

 Download mysql-5.0.41.tar.gz to /usr/local/src

[root@CIS /]# cd /usr/local/src
[root@CIS /]# tar xzvf mysql-5.0.41.tar.gz

Step 3 : Install MySQL

[root@CIS /]# cd /usr/local/src/mysql-5.0.41
[root@CIS /]# ./configure -- prefix=/usr/local/mysql \
                                         -- with-charset=ujis \
                                         -- with-extra-charsets=all \
                                         -- with-mysqld-user=mysql \
                                         -- with-server-suffix=-max \
                                         -- with-berkeley-db \
                                         -- with-innodb

[root@CIS /]# make
[root@CIS /]# make install

Step 4 : Initialize MySQL

[root@CIS /]# /usr/local/mysql/bin/mysql_install_db
[root@CIS /]# chown -R mysql /usr/local/mysql/var
[root@CIS /]# chgrp -R mysql /usr/local/mysql/var
[root@CIS /]# touch /etc/my.cnf as
                        [mysqld]
                        innodb_data_file_path=ibdata1:1000M

in /root/ .bashrc
  PATH="$PATH": /usr/local/mysql/bin

in /home/mysql/ .bashrc
  PATH="$PATH": /usr/local/mysql/bin

Step 5 : Auto start of MySQL

[root@CIS /]# cp /usr/lcoal/mysql/share/mysql/mysql.server /etc/init.d/mysqld
[root@CIS /]# chmod +x /etc/init.d/mysqld
[root@CIS /]# cd /etc/rc3.d
[root@CIS /]# ln -s /etc/init.d/mysqld S98mysqld
[root@CIS /]# cd /etc/rc0.d
[root@CIS /]# ln -s /etc/init.d/mysqld K10mysqld
[root@CIS /]# reboot

Step 6 : Set Password of MySQL root

[root@CIS /]# su - mysql
[mysql@CIS /]# mysql -u root
mysql>use mysql;
mysql>update user set Password=PASSWORD('newpasswd') WHERE User='root';
mysql>flush privileges;
mysql>exit;

Step 7 : Delete preusers

[root@CIS /]# su - mysql
[mysql@CIS /]# mysql -u root
mysql>use mysql;
mysql>delete from user where user='';
mysql>flush privileges;
mysql>exit;

Step 8 : Add mysql user and database

[root@CIS /]# su - mysql
[mysql@CIS /]# mysql -u root -p
mysql>grant all on *.* to cis identified by 'password';
mysql>create database cis;
mysql>show databases;
mysql>exit;

Step 9 : Test Connection

[root@CIS /]# su - mysql
[mysql@CIS /]# mysql -u root -p kimura
mysql>exit;