阿里云安装方法：https://yq.aliyun.com/articles/285398

普通安装方法：

参考：http://www.cnblogs.com/chenmh/p/5413881.html

1 创建mysql用户和组

groupadd mysql

useradd -r -g mysql mysql

2 在usr/local目录下

使用wget下载mysql tar包

wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz

3 解压tar -zxvf mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz

4 重命名解压后的文件夹mv mysql-5.7.19-linux-glibc2.12-x86_64 mysql

5 进入mysql目录，执行 chown -R mysql:mysql ./  改变用户和组为mysql

6 进入bin目录 执行./mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data 安装mysql

此时会产生初始临时密码，需记住

7 修改/etc/my.cnf文件

[client]

port = 3306

socket = /tmp/mysql.sock

[mysqld]

server_id=10

port = 3306

user = mysql

character-set-server = utf8mb4

default_storage_engine = innodb

log_timestamps = SYSTEM

socket = /tmp/mysql.sock

basedir = /usr/local/mysql

datadir = /usr/local/mysql/data

pid-file = /usr/local/mysql/data/mysql.pid

max_connections = 1000

max_connect_errors = 1000

table_open_cache = 1024

max_allowed_packet = 128M

open_files_limit = 65535

#####====================================[innodb]==============================

innodb_buffer_pool_size = 1024M

innodb_file_per_table = 1

innodb_write_io_threads = 4

innodb_read_io_threads = 4

innodb_purge_threads = 2

innodb_flush_log_at_trx_commit = 1

innodb_log_file_size = 512M

innodb_log_files_in_group = 2

innodb_log_buffer_size = 16M

innodb_max_dirty_pages_pct = 80

innodb_lock_wait_timeout = 30

innodb_data_file_path=ibdata1:10M:autoextend

#####====================================[log]==============================

log_error = /usr/local/mysql/log/mysql-error.log

slow_query_log = 1

long_query_time = 1

slow_query_log_file = /usr/local/mysql/log/mysql-slow.log

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

8 配置启动文件

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

chkconfig --add mysql

9 创建软连接

ln -s /usr/local/mysql/bin/mysql /usr/bin

ln -s /usr/local/mysql/bin/mysqladmin /usr/bin

10 修改密码

update mysql.user set authentication_string=password('cui.910722') where user='root' ;

11开放远程连接权限

GRANT   ALL   PRIVILEGES   ON   *.*   TO   'root'@'%'   WITH   GRANT   OPTION //赋予任何主机访问数据的权限

flush privileges;