mysql-5.7二进制安装

1.解压安装包：

tar -zxvf mysql-5.7.23-linux-glibc2.12-x86_64.tar.gz

创建mysql目录：

mkdir -p /data/mysqlcd /data/mysql/

binlog存储目录：

mkdir binlog

mysql数据目录：

mkdir data

mysql日志目录：

mkdir log

限制mysql导入导出目录：

mkdir tmp

授权mysql用户：

chown -R mysql:mysql /data/mysql/

移动目录到自定义的位置，这里存放位置为/usr/local下：

mv mysql-5.7.23-linux-glibc2.12-x86_64 /usr/local/mysqlcd /usr/local/

程序目录授权：

chown -R mysql:mysql /usr/local/mysql/

备份自带的配置文件：

cp my.cnf my.cnf.back

编辑新的配置文件：

vi my.cnf

将以下内容替换源文件的内容

[mysqld]#bind-address 0.0.0.0back_log = 2000basedir = /usr/local/mysqlcharacter-set-server = utf8mb4datadir = /data/mysql/dataevent_scheduler = ONinnodb_autoinc_lock_mode = 1innodb_buffer_pool_size = 16Ginnodb_data_file_path = ibdata1:500M:autoextendinnodb_data_home_dir = /data/mysql/datainnodb_file_per_table = 1innodb_flush_log_at_trx_commit = 2innodb_flush_method = O_DIRECTinnodb_io_capacity = 2000innodb_log_buffer_size = 8388608innodb_log_files_in_group = 3innodb_log_group_home_dir = /data/mysql/datainnodb_max_dirty_pages_pct = 50innodb_open_files = 1024innodb_read_io_threads = 8innodb_thread_concurrency = 20innodb_write_io_threads = 8innodb_lock_wait_timeout = 10innodb_buffer_pool_load_at_startup = 1innodb_buffer_pool_dump_at_shutdown = 1key_buffer_size = 3221225472innodb_log_file_size = 1Glocal_infile = 1slave-skip-errors = 1062 1032binlog-format = rowlog-bin = /data/mysql/binlog/mysql-bin.logexpire_logs_days = 7log_bin_trust_function_creators = 1log_output = FILElong_query_time = 1log-error = /data/mysql/log/error.logmax_allowed_packet = 134217728max_connect_errors = 1000000max_connections = 2000myisam_sort_buffer_size = 33554432#myisam_recover = 1join_buffer_size = 8388608tmp_table_size = 33554432net_buffer_length = 8192performance_schema = 1performance_schema_max_table_instances = 200pid-file = /data/mysql/mysqld.pidport = 3306query_cache_size = 0query_cache_type = 0read_buffer_size = 20971520read_rnd_buffer_size = 16Mmax_heap_table_size = 33554432bulk_insert_buffer_size = 134217728#relay-log = /data2/mysql/log/mysql-relay.logsecure-file-priv = /data/mysql/tmpserver-id = 324532432skip-slave-startskip_name_resolveslave-load-tmpdir = /data/mysql/tmpslow-query-log-file = /data/mysql/log/mysql-slow.logslow_query_log = 1socket = /tmp/mysql.socksort_buffer_size = 2097152table_open_cache = 128thread_cache_size = 50tmpdir = /data/mysql/tmpuser = mysql#wait_timeout = 2880000transaction_isolation=read-committedlong_query_time=1sync_binlog=0innodb_flush_log_at_trx_commit=0[mysqld_safe]log-error = /data/mysql/log/error.logpid-file = /data/mysql/mysqld.pid

保存退出

cd /usr/local/mysql/

初始化数据库：

./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/data/mysql/data/cd /data/mysql/log/

查看日志，初始化会生成初始密码：

tail -f error.log

拷贝启动脚本到系统启动目录：

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

加入开机启动服务：

chkconfig --add mysql

设置开机启动：

chkconfig mysql on

拷贝命令到系统路径下，便于全局调用：

cp /usr/local/mysql/bin/* /usr/local/sbin//etc/init.d/mysql start ##启动数据库

登录到数据库内修改root用户的初始化密码：

mysql -u root -p --->输入mysql数据库root用户的密码SET PASSWORD = PASSWORD('新密码'); ##修改root用户的密码。（alter user user() identified by '新密码';）

到这里整个初始化过程就完成了。