[root@webserver ~]# yum -y install gcc gcc-devel gcc-c++ gcc-c++-devel autoconf* automake* zlib* libxml* ncurses-devel ncurses libgcrypt* libtool* cmake openssl openssl-devel bison bison-devel unzip
2.创建mysql安装目录和数据库目录
mkdir -p /opt/mysql/datamkdir -p /opt/mysql/etcmkdir -p /opt/mysql/log
3.更改mysql目录的权限为自己当前用户（我的用户名是mysql）
chown mysql.mysql /opt/mysql
chown mysql.mysql /opt/mysql/data -
4.解压mysql-5.6.21.tar.gz源码包
tar zxvf ~/下载/mysql-5.6.21.tar.gz -c /usr/local/src/chown mysql.mysql /usr/share/src/mysql-5.6.21hown mysql.mysql /usr/share/src/mysql-5.6.21/ -r
5.下载gmock-1.6.0.zip，解压至源码中的source_downloads目录下
http://bbs.ithome.com/forum.php?mod=attachment&aid=ntk1mjywfgnkyznjzdm0fde0mtm4ntu1mzr8mja5ndi5nnw2mzg1nta%3dunzip ~/下载/gmock-1.6.0.zipmv gmock-1.6.0 /usr/local/src/mysql-5.6.21/source_downloads/cd /usr/local/src/mysql-5.6.21/source_downloads/gmock-1.6.0./configuremakecd ../../
6.编译安装
cmake \-dcmake_install_prefix=/opt/mysql \-dmysql_datadir=/opt/mysql/database \-dwith_myisam_storage_engine=1 \-dwith_innobase_storage_engine=1 \-dwith_memory_storage_engine=1 \-dwith_archive_storage_engine=1 \-dwith_partition_storage_engine=1 \-dwith_blackhole_storage_engine=1 \-dwith_readline=1 \-denable_downloads=1 \-denabled_local_infile=1 \-dmysql_unix_addr=/var/lib/mysql/mysql.sock \-dmysql_tcp_port=3306 \-dextra_charsets=all \-ddefault_charset=utf8 \-ddefault_collation=utf8_general_cimakemake install
7.创建配置文件
cp /opt/mysql/support-files/my-default.cnf /opt/mysql/etc/my.cnf[root@master support-files]# cat /opt/mysql/etc/my.cnf[mysqld]datadir = /opt/mysqldatadir = /opt/mysql/data#socket = /tmp/mysql.socksocket = /opt/mysql/data/mysql.sock#log = /opt/mysql/log/mysql.logpid-file = /opt/mysql/data/mysql.piduser = mysqlport = 3306#tmpdir = /tmplog-error = /opt/mysql/log/mysql.err[client]socket = /opt/mysql/data/mysql.sock
8.初始化数据库
/opt/mysql/scripts/mysql_install_db --user=mysql --basedir=/opt/mysql --datadir=/opt/mysql/data
9.创建管理mysql数据库的shell脚本
root@master support-files]# cp mysql.server /etc/init.d/mysql[root@master support-files]# chmod +x /etc/init.d/mysql[root@master support-files]# service mysql startstarting mysql.. [确定][root@master support-files]#
10.设置mysql root用户的密码
/opt/msql/bin/mysqladmin -u root password 123123 #修改mysql数据库的root账户密码是123123
11.登录mysql
[root@master support-files]# mysql -uroot -p123123warning: using a password on the command line interface can be insecure.welcome to the mysql monitor. commands end with ; or \g.your mysql connection id is 1server version: 5.6.21 source distributioncopyright (c) 2000, 2014, oracle and/or its affiliates. all rights reserved.oracle is a registered trademark of oracle corporation and/or itsaffiliates. other names may be trademarks of their respectiveowners.type 'help;' or '\h' for help. type '\c' to clear the current input statement.