Deployment of MySQL-5.5.10

softwoare ：

OS type： RHEL5

version： mysql-5.5.10.tar.gz

(1) check whether the compile tools have been installed ,such as gcc , gcc-c++ ,cmake etc

If they haven’t been installed, you can install them by yum

yum install gcc gcc-c++ make cmake automake

(2) create mysql installation dictionary and data dictionary

[root@ rhel5~]#mkdir -p /usr/local/mysql

[root@ rhel5~]#mkdir -p /usr/local/mysql/data

(3) create mysql user and it’s group

[root@ rhel5~]groupadd mysql

[root@ rhel5~]useradd -r -g mysql mysql

(4) formal installation

[root@ rhel5 local]#tar -zxv -f mysql-5.5.10.tar.gz

compile parameter：

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql

-DMYSQL_DATADIR=/usr/local/mysql/data

-DDEFAULT_CHARSET=utf8

-DDEFAULT_COLLATION=utf8_general_ci

-DEXTRA_CHARSETS=all

-DENABLED_LOCAL_INFILE=1

[root@ rhel5 mysql-5.5.10]#make && make install

This command will take a long time, please be patient.

(5) set permission for mysql dictionary

[root@ rhel5~]# cd /usr/local/mysql

[root@ rhel5 mysql]# chown -R mysql:mysql .

[root@ rhel5 mysql]# chown -R mysql:mysql data

(6)cp original configuration file and startup script

[root@ rhel5 mysql]# cp …/mysql/support-files/my-default.cnf /etc/my.cnf

[root@ rhel5 mysql]# cp …/mysql/support-files/mysql.server /etc/init.d/mysqld

(7) mysql initialization

[root@ rhel5 mysql]# cd /usr/local/mysql

[root@ rhel5 mysql]# scripts/mysql_install_db –user=mysql

(8) start mysql

[root@ rhel5~]# cd /usr/local/mysql

[root@ rhel5 mysql]# ./bin/mysqld_safe –user=mysql &

(9) set root password and it’s permission, making root can connect mysql from any client.

[root@ rhel5~]# mysql -u root mysql

mysql> GRANT ALL PRIVILEGES ON *.* TO root@”%” IDENTIFIED BY “root”;

mysql>flush privileges;

mysql>quit

If you can not connect it from remote client , you may need to exam iptables configuration，

checking whether port 3306 is opening or not.