mysql编译安装

• 环境

192.168.2.118 mysql主 CentOS release 6.3 (Final)
192.168.2.119 mysql从 CentOS release 6.3 (Final)

• 配置主机名

vi /etc/hosts
127.0.0.1 mysqlM
192.168.2.118 mysqlM
192.168.2.119 mysqlS

• 分别在两个服务器编译安装mysql

yum install gcc-c++ gcc ncurses ncurses-devel  openssl-devel cmake tcp_wrappers-devel bison-devel bison -yuseradd mysqlwget http://down1.chinaunix.net/distfiles/mysql-5.5.20.tar.gzcd mysql-5.5.20cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql55 \-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \-DMYSQL_DATADIR=/data/mysql \-DSYSCONFDIR=/etc \-DMYSQL_USER=mysql \-DMYSQL_TCP_PORT=3306 \-DWITH_XTRADB_STORAGE_ENGINE=1 \-DWITH_INNOBASE_STORAGE_ENGINE=1 \-DWITH_PARTITION_STORAGE_ENGINE=1 \-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \-DWITH_MYISAM_STORAGE_ENGINE=1 \-DWITH_READLINE=1 \-DENABLED_LOCAL_INFILE=1 \-DWITH_EXTRA_CHARSETS=1 \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci \-DEXTRA_CHARSETS=all \-DWITH_BIG_TABLES=1 \-DWITH_DEBUG=0makemake install

mysql55目录下有一个文件夹support-files，mysql的常用模版配置文件都在该目录下

• 设置mysql为系统服务

cd /usr/local/mysql55\cp support-files/my-large.cnf /etc/my.cnfcp support-files/mysql.server /etc/init.d/mysqld

• 初始化数据库

mkdir -p  /data/mysql/usr/local/mysql55/scripts/mysql_install_db --user=mysql --datadir=/data/mysql/ --basedir=/usr/local/mysql55/ln  -s  /usr/local/mysql55/bin/* /usr/bin/service mysqld start

• 检查数据库运行情况

ps -ef | grep mysql或netstat -tunlp | grep 3306

• 设置root密码

mysql进入数据库update mysql.user set password=password('123456') WHERE User='root';flush privileges;

再次进入mysql就需要输入上面设置的密码才能成功登陆mysql

mysql部署完成。