二、概述
1.环境准备
(1).安装yum源
[root@node6 src]# wget http://mirrors.hustunique.com/epel/6/x86_64/epel-release-6-8.noarch.rpm
[root@node6 src]# rpm -ivh epel-release-6-8.noarch.rpm
(2).同步时间(系统与硬件)
[root@node6 src]# yum install -y ntp
[root@node6 src]# ntpdate 202.120.2.101
[root@node6 src]# hwclock -w
2.安装mysql 5.1
[root@node6 mysql-5.1.73]# tar xf mysql-5.1.73.tar.gz
[root@node6 mysql-5.1.73]# cd mysql-5.1.73
[root@node6 mysql-5.1.73]# ./configure --prefix=/usr/local/mysql --localstatedir=/data/mysql --enable-assembler --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static --with-pthread --enable-static --with-big-tables --without-ndb-debug --with-charset=utf8 --with-extra-charsets=all --without-debug --enable-thread-safe-client --enable-local-infile --with-plugins=max
出错1：checking for termcap functions library... configure: error: No curses/termcap library found。
原因：缺少ncurses安装包。
解决方法，
1 [root@node6 mysql-5.1.73]# yum -y install ncurses ncurses-devel
下面继续，
[root@node6 mysql-5.1.73]# ./configure --prefix=/usr/local/mysql --localstatedir=/data/mysql --enable-assembler --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static --with-pthread --enable-static --with-big-tables --without-ndb-debug --with-charset=utf8 --with-extra-charsets=all --without-debug --enable-thread-safe-client --enable-local-infile --with-plugins=max
上面配置内容省略……
This version of MySQL Cluster is no longer maintained.
Please use the separate sources provided for MySQL Cluster instead.
See http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster.html
for more details.
Thank you for choosing MySQL!
Remember to check the platform specific part of the reference manual
for hints about installing MySQL on your platform.
Also have a look at the files in the Docs directory.
到这里我们编译配置就完成了，下面我们编译并安装。
1 [root@node6 mysql-5.1.73]# make && make install
注，编译与安装时间比较长请大家耐心等待，当然会看各位博友机器的配置，相对来说配置越好，相对的编译与安装时间相对就少。
3.创建数据目录并授权
12345678 [root@node6 mysql-5.1.73]# mkdir -pv /data/mysql
mkdir: 已创建目录 "/data/mysql"
[root@node6 mysql-5.1.73]# useradd mysql
[root@node6 mysql-5.1.73]# chown mysql.mysql /data/mysql/
[root@node6 mysql-5.1.73]# ll /data/
总用量 20
drwx------. 2 root root 16384 8月 17 18:42 lost+found
drwxr-xr-x. 2 mysql mysql 4096 1月 4 16:10 mysql
4.为mysql提供配置文件
[root@node6 mysql-5.1.73]# cp support-files/my-huge.cnf /etc/my.cnf
cp：是否覆盖"/etc/my.cnf"？ y
5.简单修改一下配置文件
[root@node6 mysql-5.1.73]# vim /etc/my.cnf
[client]
default-character-set = utf8
[mysqld]
default-character-set = utf8
datadir = /data/mysql
6.提供启动脚本
[root@node6 mysql-5.1.73]# cp support-files/mysql.server /etc/init.d/mysqld
[root@node6 mysql-5.1.73]# chmod +x /etc/init.d/mysqld
[root@node6 ~]# chkconfig mysqld --add
[root@node6 ~]# chkconfig mysqld on
7.初始化mysql
[root@node6 mysql-5.1.73]# /usr/local/mysql/bin/mysql_install_db --basedir=/usr/local/mysql/ --datadir=/data/mysql/ --user=mysql
Installing MySQL system tables...
140104 16:18:43 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead.
140104 16:18:43 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
OK
Filling help tables...
140104 16:18:43 [Warning] '--default-cha