Centos7之安装MySQL

一、安装前准备

1.下载并安装MySQL Yum Repository

wget https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm

rpm -ihv mysql80-community-release-el7-3.noarch.rpm

二、安装MySQL8.0

安装的MySQL Commuity Server,安装快慢是网络情况而定。

安装：sudo yum install -y mysql-community-server

启动Mysqld服务：sudo service mysqld start

查看Mysqld服务：sudo service mysqld status

查看临时密码：sudo grep 'temporary password' /var/log/mysqld.log

如果没有临时密码，生成一个临时密码：mysqld --initialize --user=mysql --console

三、修改MySQL8.0的临时密码

密码需要符合以下要求，除非修改密码规则。

mysql> SHOW VARIABLES LIKE 'validate_password%';

+----------------------------------------------------+----------+

| Variable_name | Value |

+----------------------------------------------------+----------+

| validate_password.check_user_name | ON |

| validate_password.dictionary_file | |

| validate_password.length | 8 |

| validate_password.mixed_case_count | 1 |

| validate_password.number_count | 1 |

| validate_password.policy | MEDIUM |

| validate_password.special_char_count | 1 |

+----------------------------------------------------+----------+

7 rows in set (0.01 sec)

修改MySQL 8.0密码验证规则：

         mysql> set global validate_password.policy=0;

  　   mysql> set global validate_password.length=1;

修改密码：alter USER 'root'@'localhost' IDENTIFIED BY 'PAN1997.com'

四、配置MySQL8.0

远程连接：https://blog.csdn.net/pannubi/article/details/104861672

创建一个用于远程连接的用户：create user 'nubipan'@'%' identified by "PAN1997.com"；

查看用户的权限 show grants for 'nubipan'@'%'；

+----------------------------------------------------------+

| Grants for nubipan@% |

+----------------------------------------------------------+

| GRANT USAGE ON *.* TO `nubipan`@`%` |

+----------------------------------------------------------+

1 row in set (0.00 sec)

 

#可根据自身情况对用户进行赋予权限

mysql> grant all privileges on * to 'nubipan'@'%';

Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.01 sec)

 

远程连接已经配置完成，此时需要将3306端口开放。

#iptables为CentOS6的防火墙使用方式，CentOS7使用的是firewall。

#iptables

sudo iptables -A input -p --dport 3306 -j ACCEPT

sudo systemctl restart iptables.service

 

#firewall 方式

firewall-cmd --zone=public --add-port=3306/tcp --permanent

重启防火墙

firewall-cmd --reload