CentOS7 环境 MySQL5.7 安装

yum install libaio  # Yum-based systems
apt-get install libaio1 # APT-based systems

cd /usr/local
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz
tar -zxvf mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz
mv mysql-5.7.18-linux-glibc2.5-x86_64 mysql

    .
├── bin
├── COPYING
├── docs
├── include
├── lib
├── man
├── README
├── share
└── support-files

groupadd mysql  # 添加组
useradd -r -g mysql -s /bin/false mysql  # 添加系统用户mysql, 同时归属mysql用户组，禁用登录
cd /usr/local/mysql
mkdir mysql-files
chmod 750 mysql-files
chown -R mysql .
chgrp -R mysql .
bin/mysqld --initialize --user=mysql  # 初始化mysql
# 初始化完成后，生成临时密码

    2017-05-16T09:29:54.914039Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2017-05-16T09:29:56.230632Z 0 [Warning] InnoDB: New log files created, LSN=45790
    2017-05-16T09:29:56.458902Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
    2017-05-16T09:29:56.525449Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 396f6ef0-3a1a-11e7-ac12-00163e08ad97.
    2017-05-16T09:29:56.527918Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
    2017-05-16T09:29:56.528403Z 1 [Note] A temporary password is generated for root@localhost: tXH34JDf;EoE

mkdir data  # 创建数据目录
chown -R root .
chown -R mysql data mysql-files
bin/mysqld_safe --user=mysql & （还可以指定mysql的配置文件 --defaults-file=file_name，此选项要放在第一位）
cp support-files/mysql.server /etc/init.d/mysql.server

/etc/init.d/mysql.server start  # 启动mysql

[root@iZwz9h34kd1ead45xeg4o2Z bin]# ./mysql_secure_installation 

Securing the MySQL server deployment.

Enter password for user root: 
Error: Access denied for user 'root'@'localhost' (using password: YES)
[root@iZwz9h34kd1ead45xeg4o2Z bin]# ./mysql_secure_installation 

Securing the MySQL server deployment.

Enter password for user root: 

The existing password for the user account root has expired. Please set a new password.

New password: 

Re-enter new password: 
By default, a MySQL installation has an anonymous user,
allowing anyone to log into MySQL without having to have
a user account created for them. This is intended only for
testing, and to make the installation go a bit smoother.
You should remove them before moving into a production
environment.

Remove anonymous users? (Press y|Y for Yes, any other key for No) : y
Success.


Normally, root should only be allowed to connect from
'localhost'. This ensures that someone cannot guess at
the root password from the network.

Disallow root login remotely? (Press y|Y for Yes, any other key for No) : No

 ... skipping.
By default, MySQL comes with a database named 'test' that
anyone can access. This is also intended only for testing,
and should be removed before moving into a production
environment.


Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y
 - Dropping test database...
Success.

 - Removing privileges on test database...
Success.

Reloading the privilege tables will ensure that all changes
made so far will take effect immediately.

Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y
Success.

All done! 

## CREATE DATABASE ##
mysql> CREATE DATABASE webdb;

## CREATE USER ##
mysql> CREATE USER 'webdb_user'@'10.0.15.25' IDENTIFIED BY 'password123'; # 如果是允许所有ip远程连过来使用 ‘%’代替ip

## GRANT PERMISSIONS ##
mysql> GRANT ALL ON webdb.* TO 'webdb_user'@'10.0.15.25';

##  FLUSH PRIVILEGES, Tell the server to reload the grant tables  ##
mysql> FLUSH PRIVILEGES;

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
Query OK, 0 rows affected, 1 warning (0.01 sec)

mysql> FLUSH PRIVILEGES;

systemctl stop firewalld
systemctl mask firewalld
yum install iptables-services
systemctl enable iptables

vim /etc/sysconfig/iptables
# 添加一行
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT

service iptables restart
## OR ##
/etc/init.d/iptables restart

# 禁止firewall开机启动
systemctl disable firewalld
# 停止防火墙
systemctl stop firewalld
# 防火墙状态
systemctl status firewalld
# 设置防火墙开机启动
systemctl enable firewalld
# 启动防火墙
systemctl start firewalld

mysql> SET PASSWORD FOR 'root'@'%' = PASSWORD('new_password');

# ZIP压缩版
windows x32
http://mirror.bit.edu.cn/mysql/Downloads/MySQL-5.7/mysql-5.7.12-winx32.zip

windows x64
http://mirror.bit.edu.cn/mysql/Downloads/MySQL-5.7/mysql-5.7.12-winx64.zip

# 安装版
http://mirror.bit.edu.cn/mysql/Downloads/MySQLInstaller/mysql-installer-community-5.7.12.0.msi