如何进行Mysql5.6或Centos6.5源码编译安装_好文资源

这篇文章给大家介绍如何进行Mysql5.6或Centos6.5源码编译安装，内容非常详细，感兴趣的小伙伴们可以参考借鉴，希望对大家能有所帮助。## 说明不同服务器需要改变 server_id ,同一台机器上需要改变 port1. 关闭防火墙

[root@mysql ~]# service iptables status –查看防火墙状态

[root@mysql ~]# service iptables stop –关闭防火墙

[root@mysql ~]# chkconfig iptables off –永久关闭

[root@mysql ~]# vim /etc/sysconfig/selinux

SELINUX=disabled2. 配置sysctl.conf

生产环境下建议根据情况配置，虚拟机安装可以不设置3. 检查操作系统上是否已经安装了mysql，如果有进行卸载

[root@mysql yum.repos.d]# rpm -qa |grep mysql

[root@mysql yum.repos.d]# yum remove mysql4. 下载mysql源码包

https://dev.mysql.com/downloads/file/?id=4690125. 添加用户和组

[root@mysql u01]# userdel -r mysql –删除原先的mysql用户 -r会删掉附带的group

[root@mysql u01]# groupadd mysql

[root@mysql u01]# useradd -d /home/mysql -g mysql -m mysql

[root@mysql u01]# passwd mysql

Changing password for user mysql.

New password:

BAD PASSWORD: it is based on a dictionary word

Retype new password:

passwd: all authentication tokens updated successfully.

[root@mysql u01]# id mysql

uid=500(mysql) gid=500(mysql) groups=500(mysql)6. 配置mysql环境变量

[mysql@mysql ~]$ vim .bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin:/u01/my3306/bin

export PATH

[mysql@mysql ~]$ source .bash_profile7. 创建目录及授权

[root@mysql u01]# cd /u01

[root@mysql u01]# mkdir -p /u01/my3306/data

[root@m开发云主机域名ysql u01]# mkdir -p /u01/my3306/log/iblog

[root@mysql u01]# mkdir -p /u01/my3306/log/binlog

[root@mysql u01]# mkdir -p /u01/my3306/run

[root@mysql u01]# mkdir -p /u01/my3306/tmp

[root@mysql u01]# chown -R mysql:mysql /u01/my3306

[root@mysql u01]# chmod 755 /u01/my33068. 解压mysql

[root@mysql u01]# tar -xzvf mysql-5.6.36.tar.gz9. 配置yum源，安装cmakle及一些必备的包，要求2.6版本及以上

yum install -y cmake gcc gcc-c++ ncurses-devel bison zlib libxml openssl10. 编译并安装

cmake

-DCMAKE_INSTALL_PREFIX=/u01/my3306

-DINSTALL_DATADIR=/u01/my3306/data

-DDEFAULT_CHARSET=utf8

-DDEFAULT_COLLATION=utf8_general_ci

-DEXTRA_CHARSETS=all —

-DWITH_SSL=yes –安全套接字

-DWITH_EMBEDDED_SERVER=1

-DENABLED_LOCAL_INFILE=1

-DWITH_MYISAM_STORAGE_ENGINE=1

-DWITH_INNOBASE_STORAGE_ENGINE=1

-DWITH_ARCHIVE_STORAGE_ENGINE=1

-DWITH_BLACKHOLE_STORAGE_ENGINE=1

-DWITH_FEDERATED_STORAGE_ENGINE=1

-DWITH_PARTITION_STORAGE_ENGINE=1

-DMYSQL_UNIX_ADDR=/u01/my3306/run/mysql.sock

-DMYSQL_TCP_PORT=3306

-DENABLED_LOCAL_INFILE=1

-DSYSCONFDIR=/etc

-DWITH_READLINE=on

[root@mysql mysql-5.6.36]# cd mysql-5.6.36

[root@mysql mysql-5.6.36]# cmake -DCMAKE_INSTALL_PREFIX=/u01/my3306 -DINSTALL_DATADIR=/u01/my3306/data -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DWITH_SSL=yes -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_PARTIT开发云主机域名ION_STORAGE_ENGINE=1 -DMYSQL_UNIX_ADDR=/u01/my3306/run/mysql.sock -DMYSQL_TCP_PORT=3306 -DENABLED_LOCAL_INFILE=1 -DSYSCONFDIR=/etc -DWITH_READLINE=on

[root@mysql mysql-5.6.36]# make

[root@mysql mysql-5.6.36]# make install11. 配置mysql参数

[root@mysql my3306]# pwd

/u01/my3306

[root@mysql my3306]# cat my.cnf

[client]

port=3306

socket=/u01/my3306/mysql.sock

[mysql]

pid_file=/u01/my3306/run/mysqld.pid

[mysqld]

autocommit=1

general_log=off

explicit_defaults_for_timestamp=true

# system

basedir=/u01/my3306

datadir=/u01/my3306/data

max_allowed_packet=1g

max_connections=3000

max_user_connections=2800

open_files_limit=65535

pid_file=/u01/my3306/run/mysqld.pid

port=3306

server_id=101

skip_name_resolve=ON

socket=/u01/my3306/run/mysql.sock

tmpdir=/u01/my3306/tmp

#binlog

log_bin=/u01/my3306/log/binlog/binlog

binlog_cache_size=32768

binlog_format=row

expire_logs_days=7

log_slave_updates=ON

max_binlog_cache_size=2147483648

max_binlog_size=524288000

sync_binlog=100

#logging

log_error=/u01/my3306/log/error.log

slow_query_log_file=/u01/my3306/log/slow.log

log_queries_not_using_indexes=0

slow_query_log=1

log_slave_updates=ON

log_slow_admin_statements=1

long_query_time=1

#relay

relay_log=/u01/my3306/log/relaylog

relay_log_index=/u01/my3306/log/relay.index

relay_log_info_file=/u01/my3306/log/relay-log.info

#slave

slave_load_tmpdir=/u01/my3306/tmp

slave_skip_errors=OFF

#innodb

innodb_data_home_dir=/u01/my3306/log/iblog

innodb_log_group_home_dir=/u01/my3306/log/iblog

innodb_adaptive_flushing=ON

innodb_adaptive_hash_index=ON

innodb_autoinc_lock_mode=1

innodb_buffer_pool_instances=8

#default

innodb_change_buffering=inserts

innodb_checksums=ON

innodb_buffer_pool_size= 128M

innodb_data_file_path=ibdata1:32M;ibdata2:16M:autoextend

innodb_doublewrite=ON

innodb_file_format=Barracuda

innodb_file_per_table=ON

innodb_flush_log_at_trx_commit=1

innodb_flush_method=O_DIRECT

innodb_io_capacity=1000

innodb_lock_wait_timeout=10

innodb_log_buffer_size=67108864

innodb_log_file_size=1048576000

innodb_log_files_in_group=4

innodb_max_dirty_pages_pct=60

innodb_open_files=60000

innodb_purge_threads=1

innodb_read_io_threads=4

innodb_stats_on_metadata=OFF

innodb_support_xa=ON

innodb_use_native_aio=OFF

innodb_write_io_threads=10

[mysqld_safe]

[root@mysql my3306]# chown -R mysql:mysql /u01/my330612. 初始化mysql脚本

[root@mysql my3306]# ./scripts/mysql_install_db –defaults-file=/u01/my3306/my.cnf –datadir=/u01/my3306/data –user=mysql13. 启动mysql

[mysql@mysql bin]$ ./mysqld_safe –defaults-file=/u01/my3306/my.cnf –user=mysql &

[1] 17237

[mysql@mysql bin]$ 170612 06:37:02 mysqld_safe Logging to ‘/u01/my3306/log/error.log’.

170612 06:37:02 mysqld_safe Starting mysqld daemon with databases from /u01/my3306/data

[mysql@mysql bin]$ mysql

Welcome to the MySQL monitor. Commands end with ; or g.

Your MySQL connection id is 2

Server version: 5.6.36-log Source distribution

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the current input statement.

mysql>

mysql> show databases;

+——————–+

| Database |

+——————–+

| information_schema |

| mysql |

| performance_schema |

| test |

+——————–+

4 rows in set (0.10 sec)## 说明不同服务器需要改变 server_id ,同一台机器上需要改变 port

1. 关闭防火墙

[root@mysql ~]# service iptables status –查看防火墙状态

[root@mysql ~]# service iptables stop –关闭防火墙

[root@mysql ~]# chkconfig iptables off –永久关闭

[root@mysql ~]# vim /etc/sysconfig/selinux

SELINUX=disabled2. 配置sysctl.conf

生产环境下建议根据情况配置，虚拟机安装可以不设置3. 检查操作系统上是否已经安装了mysql，如果有进行卸载

[root@mysql yum.repos.d]# rpm -qa |grep mysql

[root@mysql yum.repos.d]# yum remove mysql4. 下载mysql源码包

https://dev.mysql.com/downloads/file/?id=4690125. 添加用户和组

[root@mysql u01]# userdel -r mysql –删除原先的mysql用户 -r会删掉附带的group

[root@mysql u01]# groupadd mysql

[root@mysql u01]# useradd -d /home/mysql -g mysql -m mysql

[root@mysql u01]# passwd mysql

Changing password for user mysql.

New password:

BAD PASSWORD: it is based on a dictionary word

Retype new password:

passwd: all authentication tokens updated successfully.

[root@mysql u01]# id mysql

uid=500(mysql) gid=500(mysql) groups=500(mysql)6. 配置mysql环境变量

[mysql@mysql ~]$ vim .bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin:/u01/my3306/bin

export PATH

[mysql@mysql ~]$ source .bash_profile7. 创建目录及授权

[root@mysql u01]# cd /u01

[root@mysql u01]# mkdir -p /u01/my3306/data

[root@mysql u01]# mkdir -p /u01/my3306/log/iblog

[root@mysql u01]# mkdir -p /u01/my3306/log/binlog

[root@mysql u01]# mkdir -p /u01/my3306/run

[root@mysql u01]# mkdir -p /u01/my3306/tmp

[root@mysql u01]# chown -R mysql:mysql /u01/my3306

[root@mysql u01]# chmod 755 /u01/my33068. 解压mysql

[root@mysql u01]# tar -xzvf mysql-5.6.36.tar.gz9. 配置yum源，安装cmakle及一些必备的包，要求2.6版本及以上

yum install -y cmake gcc gcc-c++ ncurses-devel bison zlib libxml openssl10. 编译并安装

cmake

-DCMAKE_INSTALL_PREFIX=/u01/my3306

-DINSTALL_DATADIR=/u01/my3306/data

-DDEF开发云主机域名AULT_CHARSET=utf8

-DDEFAULT_COLLATION=utf8_general_ci

-DEXTRA_CHARSETS=all —

-DWITH_SSL=yes –安全套接字

-DWITH_EMBEDDED_SERVER=1

-DENABLED_LOCAL_INFILE=1

-DWITH_MYISAM_STORAGE_ENGINE=1

-DWITH_INNOBASE_STORAGE_ENGINE=1

-DWITH_ARCHIVE_STORAGE_ENGINE=1

-DWITH_BLACKHOLE_STORAGE_ENGINE=1

-DWITH_FEDERATED_STORAGE_ENGINE=1

-DWITH_PARTITION_STORAGE_ENGINE=1

-DMYSQL_UNIX_ADDR=/u01/my3306/run/mysql.sock

-DMYSQL_TCP_PORT=3306

-DENABLED_LOCAL_INFILE=1

-DSYSCONFDIR=/etc

-DWITH_READLINE=on

[root@mysql mysql-5.6.36]# cd mysql-5.6.36

[root@mysql mysql-5.6.36]# cmake -DCMAKE_INSTALL_PREFIX=/u01/my3306 -DINSTALL_DATADIR=/u01/my3306/data -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DWITH_SSL=yes -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DMYSQL_UNIX_ADDR=/u01/my3306/run/mysql.sock -DMYSQL_TCP_PORT=3306 -DENABLED_LOCAL_INFILE=1 -DSYSCONFDIR=/etc -DWITH_READLINE=on

[root@mysql mysql-5.6.36]# make

[root@mysql mysql-5.6.36]# make install11. 配置mysql参数

[root@mysql my3306]# pwd

/u01/my3306

[root@mysql my3306]# cat my.cnf

[client]

port=3306

socket=/u01/my3306/mysql.sock

[mysql]

pid_file=/u01/my3306/run/mysqld.pid

[mysqld]

autocommit=1

general_log=off

explicit_defaults_for_timestamp=true

#logging

log_error=/u01/my3306/log/error.log

slow_query_log_file=/u01/my3306/log/slow.log
活动：慈云数据爆款香港服务器，CTG+CN2高速带宽、快速稳定、平均延迟10+ms 速度快，免备案，每月仅需19元！！点击查看
log_queries_not_using_indexes=0

slow_query_log=1

log_slave_updates=ON

log_slow_admin_statements=1

long_query_time=1

#relay

relay_log=/u01/my3306/log/relaylog

relay_log_index=/u01/my3306/log/relay.index

relay_log_info_file=/u01/my3306/log/relay-log.info

#slave

slave_load_tmpdir=/u01/my3306/tmp

slave_skip_errors=OFF

[mysql@mysql bin]$ mysql

Welcome to the MySQL monitor. Commands end with ; or g.

Your MySQL connection id is 2

Server version: 5.6.36-log Source distribution

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the current input statement.

mysql>

本文从转载，原作者保留一切权利，若侵权请联系删除。

《如何进行Mysql5.6或Centos6.5源码编译安装》来自互联网同行内容，若有侵权，请联系我们删除！