centos7 mysql 小破天_CentOS7安装MySQL8.0小计

之前讲配置文件和权限的时候有很多MySQL8的知识，有同志说安装不太一样，希望发个文，我这边简单演示一下

1.环境安装

下载MySQL提供的CentOS7的yum源

CentOS命令：curl https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm > centos7.mysql.rpm下载yum源(curl是系统自带的)

安装yum源：yum install centos7.mysql.rpm -y

安装MySQL8.0 yum install mysql-community-server -y

启动mysql systemctl start mysqld

设置开机启动mysql systemctl enable mysqld

2.初始化配置

查看初始密码 cat /var/log/mysqld.log | grep "password"

安全初始化 mysql_secure_installation

3.权限设置

用root账号登录 mysql -uroot -p

创建用户dnt create user dnt@'%' identified by '含大小写字母+数字的密码';

查看当前有哪些用户 select user,authentication_string,host from mysql.user;

给用户dnt分配数据库dotnetcrazy的所有权限 grant all on dotnetcrazy.* to dnt;

刷新权限 flush privileges;

显示新用户有哪些权限 show grants for dnt;

4.配置相关

root权限去修改 /etc/my.cnf

在[mysqld]选项下新增：bind-address=0.0.0.0

开放3306端口的远程访问权限：firewall-cmd --zone=public --add-port=3306/tcp --permanent

刷新防火墙规则 firewall-cmd --reload

重启MySQL：systemctl restart mysqld

测试

Shell附录

1.安装附录

# 下载yum源(curl是系统自带的)

# curl https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm > centos7.mysql.rpm

[root@localhost dnt] curl https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm > centos7.mysql.rpm

% Total % Received % Xferd Average Speed Time Time Time Current

Dload Upload Total Spent Left Speed

100 26024 100 26024 0 0 38150 0 --:--:-- --:--:-- --:--:-- 38158

[root@localhost dnt]# ls

centos7.mysql.rpm

# 安装MySQL的yum源

# yum install centos7.mysql.rpm -y

[root@localhost dnt] yum install centos7.mysql.rpm -y

已加载插件：fastestmirror

正在检查 centos7.mysql.rpm: mysql80-community-release-el7-3.noarch

centos7.mysql.rpm 将被安装

正在解决依赖关系

--> 正在检查事务

---> 软件包 mysql80-community-release.noarch.0.el7-3 将被 安装

--> 解决依赖关系完成

依赖关系解决

================================================================================================&