MySQL 5.6.29源码编译安装记录

MySQL 5.6.29源码编译安装记录 一、安装环境 1. 操作系统:CentOS 6.7 x86_64

# yum install make cmake gcc gcc-c++ gcc-g77 flex bison file libtool libtool-libs autoconf kernel-devel patch wget libjpeg libjpeg-devel libpng libpng-devel libpng10 libpng10-devel gd gd-devel libxml2 libxml2-devel zlib zlib-devel glib2 glib2-devel unzip tar bzip2 bzip2-devel libevent libevent-devel ncurses ncurses-devel curl curl-devel e2fsprogs e2fsprogs-devel krb5 krb5-devel libidn libidn-devel openssl openssl-devel vim-minimal gettext gettext-devel ncurses-devel gmp-devel pspell-devel unzip libcap diffutils net-tools libc-client-devel psmisc libXpm-devel git-core c-ares-devel perl  
2. cmake采用yum方式已安装，不需要再安装。

3. MySQL版本:mysql-5.6.29.tar.gz 4. 同样安装方式也适用于mysql-5.5.x.tar.gz 二、安装mysql-5.6.29.tar.gz 1. 下载编译版本mysql安装

tar zxvf mysql-5.6.29.tar.gz  
cd mysql-5.6.29    
patch -p1 < ../mysql-openssl.patch    
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/etc -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_ZLIB=system -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DWITH_FAST_MUTEXES=1 -DWITH_DEBUG=0    
make && make install

注：重新编驻译采用如下方式,ssl方式不需要采用，可以删除掉相关参数。
make clean    
rm -f CMakeCache.txt

2. 准备mysql用户

groupadd mysql  
useradd -g mysql -M -s /sbin/nologin mysql

3. 初始化mysql,数据库位置采用默认位置

chown -R mysql:mysql /usr/local/mysql  
/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

4. mysql服务配置

cd /usr/local/mysql  
cp support-files/my-medium.cnf /etc/my.cnf    
cp support-files/mysql.server  /etc/rc.d/init.d/mysqld    
chkconfig --add mysqld    
chkconfig mysqld on

5. 配置Mysql命令链接

ln -sf /usr/local/mysql/bin/mysql /usr/bin/mysql  
ln -sf /usr/local/mysql/bin/mysqldump /usr/bin/mysqldump    
ln -sf /usr/local/mysql/bin/myisamchk /usr/bin/myisamchk    
ln -sf /usr/local/mysql/bin/mysqld_safe /usr/bin/mysqld_safe

或通过加入环境变量中解决。

# vi /etc/profile    
export PATH=/usr/local/mysql/bin/:$PATH    
# source /etc/profile

6. 配置其它

ln -sv /usr/local/mysql/include  /usr/include/mysql    
echo '/usr/local/mysql/lib' > /etc/ld.so.conf.d/mysql.conf    
ldconfig

7. Mysql配置文件

vi /etc/my.cnf

[client]  
port        = 3306    
socket      = /tmp/mysql.sock

# The MySQL server  
[mysqld]    
port        = 3306    
socket      = /tmp/mysql.sock    
datadir = /usr/local/mysql/data    
skip-external-locking    
max_connections = 1000    
key_buffer_size = 16M    
max_allowed_packet = 1M    
table_open_cache = 64    
sort_buffer_size = 512K    
net_buffer_length = 8K    
read_buffer_size = 256K    
read_rnd_buffer_size = 512K    
myisam_sort_buffer_size = 8M

#skip-networking

log-bin=mysql-bin  
binlog_format=mixed    
server-id  = 1

innodb_data_home_dir = /usr/local/mysql/data  
innodb_data_file_path = ibdata1:10M:autoextend    
innodb_log_group_home_dir = /usr/local/mysql/data    
innodb_buffer_pool_size = 16M    
innodb_additional_mem_pool_size = 2M    
innodb_log_file_size = 5M    
innodb_log_buffer_size = 8M    
innodb_flush_log_at_trx_commit = 1    
innodb_lock_wait_timeout = 50

[mysqldump]  
quick    
max_allowed_packet = 16M

[mysql]  
no-auto-rehash

[myisamchk]  
key_buffer_size = 20M    
sort_buffer_size = 20M    
read_buffer = 2M    
write_buffer = 2M

[mysqlhotcopy]  
interactive-timeout    
expire_logs_days = 10

8. 启动mysql

service mysqld start

9. 修改管理员密码并测试

# /usr/local/mysql/bin/mysqladmin -u root password 'admin' #设置管理员密码  
# /usr/local/mysql/bin/mysql -u root -p  #测试密码输入

10. 配置mysql帐号安全

[root@test ~]# /usr/local/mysql/bin/mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL  
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!