centos6源码安装mysql5.6.16

centos6源码安装mysql5.6.16

一、创建数据库所需目录

mkdir -p /data/mysql && chown mysql.mysql /data/mysql
mkdir -p /etc/my.cnf.d/
mkdir -p /var/log/mysql && touch /var/log/mysql/mysqld.log && chown mysql.mysql /var/log/mysql
mkdir -p /var/run/mysqld && touch /var/run/mysqld/mysql.sock &&  touch /var/run/mysqld/mysqld.pid && chown mysql.mysql /var/run/mysqld

二、下载mysql源码

wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.16.tar.gz 

三、安装依赖

yum -y install make gcc-c++ cmake bison-devel ncurses-devel gcc autoconf automake zlib* fiex* libxml* libmcrypt* libtool-ltdl-devel* 

四、编译安装

tar xvf mysql-5.6.16.tar.gz 
cd mysql-5.6.16 
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/data/mysql \
-DSYSCONFDIR=/etc \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DENABLED_PROFILING=1 \
-DWITH_DEBUG=0 \
-DDOWNLOAD_BOOST=1;

make -j `grep processor /proc/cpuinfo | wc -l` && make install

五、设置开机启动

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld &&chmod a+x /etc/init.d/mysqld &&chkconfig --add mysqld &&chkconfig mysqld on

六、初始化配置

cd /usr/local/mysql
scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/data/mysql --user=mysql

七、编辑配置文件
vim /etc/my.cnf

[mysqld]
bind-address=0.0.0.0
port=3306
datadir=/data/mysql
socket=/data/mysql/mysql.sock
user=mysql
skip-name-resolve
slow_query_log=on
long_query_time=5
slow_query_log_file=/data/mysql/mysql-slow.log
expire_logs_days=15
innodb-file-per-table=1
max_connections = 1000
innodb_flush_log_at_trx_commit = 2
log_warnings = 1
connect_timeout = 60
net_read_timeout = 120
performance_schema_max_table_instances = 400

[mysqld_safe]
log-error=/data/mysql/mysqld.log
pid-file=/data/mysql/mysqld.pid

八、设置权限

chown mysql.mysql /data/mysql/

九、启动mysql

cp support-files/mysql.server /etc/init.d/mysqld
chkconfig mysqld on
service mysqld start  

十、修改密码

mysql -uroot
mysql> SET PASSWORD = PASSWORD('123456');
flush privileges;