安装mysql

1.下载

下载yum源：
wget 'https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm'

安装yum源
rpm -Uvh mysql57-community-release-el7-11.noarch.rpm

查看有哪些版本的mysql:
yum repolist all | grep mysql

2.安装

我默认使用安装mysql5.7 这里如果带宽小的话，会很慢，而且试验结果是阿里云比腾讯云快。
yum install -y mysql-community-server

启动mysql

systemctl start mysqld
查看状态
systemctl status mysqld

查看一下初始密码

grep "password" /var/log/mysqld.log

登录

mysql -uroot -p

修改：密码强度检查等级策略，0/LOW、1/MEDIUM、2/STRONG

mysql> set global validate_password_policy=0;

修改密码

mysql> set password for 'root'@'localhost' = password('root123'); 

3.其他配置

开启mysql的root用户远程连接服务(%号即远程连接，IDENTIFIED BY后面跟的密码)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root123' WITH GRANT OPTION;

刷新

mysql> flush privileges;

开启mysql端口服务

/sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT 

service network restart

4,给某个用户开启权限

mysql> CREATE USER 'mcbn'@'localhost' IDENTIFIED BY '########';

mysql> GRANT ALL PRIVILEGES ON oamcbn.* TO 'mcbn'@'localhost';

开启远程权限

mysql> GRANT ALL PRIVILEGES ON oamcbn.* TO 'mcbn'@'%' IDENTIFIED BY '#########' WITH GRANT OPTION;

mysql> FLUSH PRIVILEGES;

 
给某个用户设置
mysql> GRANT INSERT,SELECT,UPDATE,DELETE  ON `zhenai`.* TO 'zhenai'@'%' IDENTIFIED BY 'ZZmvVkcuAfj9FwPC' WITH GRANT OPTION;
收回

mysql> REVOKE INSERT,SELECT,UPDATE,DELETE ON `zhenai`.* FROM 'zhenai'@'%';


给某个IP设置

mysql> GRANT INSERT,SELECT,UPDATE,DELETE  ON `zhenai`.* TO 'zhenai'@'182.92.216.184' IDENTIFIED BY 'ZZmvVkcuAfj9FwPC' WITH GRANT OPTION;

	收回用户权限
	
# 语法格式 REVOKE privileges ON database.table FROM 'username'@'host'; # eg. 收回 local_user 的写入和更新权限 REVOKE insert,update ON *.* FROM 'local_user'@'%';

	删除用户

# 语法格式 DROP USER 'username'@'host'; # eg. 删除本地用户 local_user DROP USER 'local_user'@'localhost';

5,高版本的数据库引发的插入数据，类似日期默认值'0000-00-00'的格式的错误

mysql> select @@sql_mode;

mysql> set @@sql_mode=(select replace(@@sql_mode,'NO_ZERO_IN_DATE,NO_ZERO_DATE',''));

mysql> select @@global.sql_mode;

mysql> set @@global.sql_mode=(select replace(@@global.sql_mode,'NO_ZERO_IN_DATE,NO_ZERO_DATE',''));

mysql 8;
USE mysql;

CREATE USER zhongtui IDENTIFIED BY 'password';
alter user 'zhongtui'@'%' identified by 'password';

GRANT ALL PRIVILEGES ON zhongtui_app.* TO 'zhongtui';

FLUSH PRIVILEGES;