centos7安装mysql

参考地址：https://blog.youkuaiyun.com/qq_36582604/article/details/80526287

下载并安装MySQL官方的 Yum Repository
 下载地址
https://dev.mysql.com/downloads/repo/yum/
文件链接
https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

安装命令
[root@localhost ~]# wget -i -c https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

[root@localhost ~]# yum -y install mysql80-community-release-el7-3.noarch.rpm

[root@localhost ~]# yum -y install mysql-community-server

启动服务
[root@localhost ~]# systemctl start  mysqld.service

查看MySQL运行状态
[root@localhost ~]# systemctl status mysqld.service

 Active: active (running) since 三 2019-05-22 07:53:59 CST; 18min ago
表示正在运行

找出此时root用户的密码
[root@localhost ~]# grep "password" /var/log/mysqld.log
2019-05-21T23:53:47.535096Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: KKfDMlojP9<w
KKfDMlojP9<w为初始密码

进入数据库：
[root@localhost ~]# mysql -uroot -p

修改密码策略
mysql>  set global validate_password.policy=0;
Query OK, 0 rows affected (0.00 sec)
修改密码
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Gnss.wek';
Query OK, 0 rows affected (0.04 sec)

出现错误以及解决办法
修改密码
Your password does not satisfy the current policy requirements
密码策略问题异常

解决办法
mysql>set global validate_password_policy=LOW; 
mysql>SHOW VARIABLES LIKE 'validate_password%'; 
关于 mysql 密码策略相关参数；

1）validate_password_length  固定密码的总长度；

2）validate_password_dictionary_file 指定密码验证的文件路径；

3）validate_password_mixed_case_count  整个密码中至少要包含大/小写字母的总个数；

4）validate_password_number_count  整个密码中至少要包含阿拉伯数字的个数；

5）validate_password_policy 指定密码的强度验证等级，默认为 MEDIUM；

关于 validate_password_policy 的取值：
0/LOW：只验证长度；
1/MEDIUM：验证长度、数字、大小写、特殊字符；
2/STRONG：验证长度、数字、大小写、特殊字符、字典文件；

6）validate_password_special_char_count 整个密码中至少要包含特殊字符的个数；

3 开启mysql的远程访问

#创建账户
create user 'root'@'192.168.1.200' identified by  'ZZwek@123';

#赋予权限，with grant option这个选项表示该用户可以将自己拥有的权限授权给别人
grant all privileges on *.* to 'root'@'192.168.1.200' with grant option;

#改密码&授权超用户，flush privileges 命令本质上的作用是将当前user和privilige表中的用户信息/权限设置从mysql库(MySQL数据库的内置库)中提取到内存里
flush privileges;

create user 'root'@'%' identified by  ''XXXXXXX'';
grant all privileges on *.* to 'root'@'%' with grant option;

ALTER USER 'root'@'%' IDENTIFIED BY 'ZZwek@123' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'XXXXXXX';
FLUSH PRIVILEGES;
alter user 'root'@'localhost' identified by ''XXXXXXX'';

 

4 为firewalld添加开放端口

添加mysql端口3306和Tomcat端口8080

[root@localhost ~]# firewall-cmd --zone=public --add-port=3306/tcp --permanent

[root@localhost ~]# firewall-cmd --zone=public --add-port=8080/tcp --permanent

然后再重新载入

[root@localhost ~]# firewall-cmd --reload
--------------------- 

 

查看mysql
mysql> status
--------------
mysql  Ver 8.0.16 for Linux on x86_64 (MySQL Community Server - GPL)

Connection id:        8
Current database:    
Current user:        root@localhost
SSL:            Not in use
Current pager:        stdout
Using outfile:        ''
Using delimiter:    ;
Server version:        8.0.16
Protocol version:    10
Connection:        Localhost via UNIX socket
Server characterset:    utf8mb4(字体）
Db     characterset:    utf8mb4
Client characterset:    utf8mb4
Conn.  characterset:    utf8mb4
UNIX socket:        /var/lib/mysql/mysql.sock
Uptime:            56 min 6 sec

Threads: 2  Questions: 21  Slow queries: 0  Opens: 144  Flush tables: 3  Open tables: 45  Queries per second avg: 0.006
--------------

修改字体
mysql>exit
# vi /etc/my.cnf/
新增四行代码：
[client]
default-character-set=utf8

[mysqld]
character-set-server=utf8
collation-server=utf_general_ci

修改后重启
# service mysqld restart
登录
# mysql -uroot -p
mysql>status
mysql> status
--------------
mysql  Ver 8.0.16 for Linux on x86_64 (MySQL Community Server - GPL)

Connection id:        8
Current database:    
Current user:        root@localhost
SSL:            Not in use
Current pager:        stdout
Using outfile:        ''
Using delimiter:    ;
Server version:        8.0.16 MySQL Community Server - GPL
Protocol version:    10
Connection:        Localhost via UNIX socket
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
UNIX socket:        /var/lib/mysql/mysql.sock
Uptime:            30 sec

Threads: 2  Questions: 6  Slow queries: 0  Opens: 131  Flush tables: 3  Open tables: 35  Queries per second avg: 0.200
--------------

退出
mysql>exit