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 -y

useradd mysql

wget http://down1.chinaunix.net/distfiles/mysql-5.5.20.tar.gz

cd mysql-5.5.20

cmake . -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=0

make

make install

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

• 设置mysql为系统服务

cd /usr/local/mysql55
\cp support-files/my-large.cnf /etc/my.cnf
cp 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部署完成。