CentOS_6.7上使用二进制安装MySQL

1. 添加用户和组

groupadd mysqluseradd -r -g mysql -s /bin/false mysql

2.创建目录

mkdir -p /mysql/servermkdir -p /mysql/{my3306,my3307}/log/{binlog,iblog}mkdir -p /mysql/{my3306,my3307}/datamkdir -p /mysql/{my3306,my3307}/tmpchown -R mysql:mysql /mysqlchown root:root /mysql/chown -R root:root /mysql/serverchmod 777 /mysql

3.下载MySQL二进制包

cd /tmpwget https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.35-linux-glibc2.5-x86_64.tar.gztar xvf mysql-5.6.35-linux-glibc2.5-x86_64.tar.gzcd  mysql-5.6.35-linux-glibc2.5-x86_64cp -R *  /mysql/server

4.配置环境变量和启动文件（可选）

在~/.bash_profle里面添加

MYSQL_HOME=/mysql/serverPATH=$PATH:$MYSQL_HOME/binexport PATH

在~下新增三个shell文件并给他们+x可执行权限

start_mysql_3306.sh

cd $MYSQL_HOME./bin/mysqld_safe --defaults-file=/mysql/my3306.cnf --user=mysql &

stop_mysql_3306.sh

cd $MYSQL_HOME./bin/mysqladmin -S /mysql/my3306/mysql.sock shutdown

login_mysql_3306.sh

cd $MYSQL_HOME./bin/mysql -S /mysql/my3306/mysql.sock

cd ~

chmod +x *.sh

5.配置启动参数文件

在/mysql下新建my3306.cnf

cd /mysql

vi my3306.cnf

[client]port=3306socket=/mysql/my3306/mysql.sock[mysql]pid_file=/mysql/my3306/mysql.pid[mysqld]autocommit=1general_log=onexplicit_defaults_for_timestamp=true# systembasedir=/mysql/serverdatadir=/mysql/my3306/datamax_allowed_packet=1gmax_connections=3000max_user_connections=2800open_files_limit=65535pid_file=/mysql/my3306/mysql.pidport=3306server_id=101skip_name_resolve=ONsocket=/mysql/my3306/mysql.socktmpdir=/mysql/my3306/tmp#binloglog_bin=/mysql/my3306/log/binlog/log-binbinlog_cache_size=32768binlog_format=rowexpire_logs_days=7log_slave_updates=ONmax_binlog_cache_size=2147483648max_binlog_size=524288000sync_binlog=100#logginglog_error=/mysql/my3306/log/error.logslow_query_log_file=/mysql/my3306/log/slow.loglog_queries_not_using_indexes=0slow_query_log=1log_slave_updates=ONlog_slow_admin_statements=1long_query_time=1#relayrelay_log=/mysql/my3306/log/relaylogrelay_log_index=/mysql/my3306/log/relay.indexrelay_log_info_file=/mysql/my3306/log/relay-log.info#slaveslave_load_tmpdir=/mysql/my3306/tmpslave_skip_errors=OFF#innodbinnodb_data_home_dir=/mysql/my3306/log/ibloginnodb_log_group_home_dir=/mysql/my3306/log/ibloginnodb_adaptive_flushing=ONinnodb_adaptive_hash_index=ONinnodb_autoinc_lock_mode=1innodb_buffer_pool_instances=8#defaultinnodb_change_buffering=insertsinnodb_checksums=ONinnodb_buffer_pool_size= 128Minnodb_data_file_path=ibdata1:32M;ibdata2:16M:autoextendinnodb_doublewrite=ONinnodb_file_format=Barracudainnodb_file_per_table=ONinnodb_flush_log_at_trx_commit=1innodb_flush_method=O_DIRECTinnodb_io_capacity=1000innodb_lock_wait_timeout=10innodb_log_buffer_size=67108864innodb_log_file_size=1048576000innodb_log_files_in_group=4innodb_max_dirty_pages_pct=60innodb_open_files=60000innodb_purge_threads=1innodb_read_io_threads=4innodb_stats_on_metadata=OFFinnodb_support_xa=ONinnodb_use_native_aio=OFFinnodb_write_io_threads=10[mysqld_safe]datadir=/mysql/my3306/data

设置cnf文件属主为mysql

chown mysql:mysql /mysql/my3306.cnf

6. 初始化MySQL脚本

进入到mysql主程序目录，执行脚本

 cd /mysql/server/

./scripts/mysql_install_db --defaults-file=/mysql/my3306.cnf --user=mysql

7. 启动MySQL

执行命令或者用第4步中新建的脚本start_mysql_3306.sh来启动

 cd /mysql/server/

./bin/mysqld_safe --defaults-file=/mysql/my3306.cnf --user=mysql &

8. 登录MySQL 

执行命令或者用第4步中新建的脚本login_mysql_3306.sh来启动

mysql -S /mysql/my3306/mysql.sock