Linux使用yum安装MySql

安装说明

Mysql 版本：8.0.30
系统版本：Red Hat 8.5.0-4
rpm包地址：https://repo.mysql.com//mysql80-community-release-el6.rpm

下载安装

1、如果系统没有安装wget工具，要先安装wget工具；

yum install wget

2、安装mysql

#创建mysql文件夹，用来存放rpm文件
mkdir -p /var/mysql
#下载rpm文件
cd /var/mysql
wget https://repo.mysql.com//mysql80-community-release-el6.rpm

下载完之后查看当前目录

3、通过rpm包安装mysql

yum -y install mysql80-community-release-el6.rpm

4、安装mysql server

yum -y install mysql-community-server
#如果提示Unable to find a match: mysql-community-server，先安装mysql module
yum module disable mysql
#再执行yum -y install mysql-community-server

5、检查是否安装成功

rpm -qa |grep mysql

表示安装成功

启动MySql

#启动mysql服务
systemctl start mysqld.service
#查看mysql状态
systemctl status mysqld.service

active(running)表示启动成功

修改MySql配置

# 1、查看初始密码，并生成log文件在指定目录下 2#tvENd;s/k5
grep 'temporary password' /var/log/mysqld.log

# 2、修改初始密码，这里要用到上面的初始密码，初始密码是上面获取的root的初始密码2#tvENd;s/k5
mysql -u root -p
# 录入上面的初始密码登录；
# mysql对密码的强度要求较高，最少8位以上，包含数字，字母，特殊符号；也可以去修改密码的安全策略配置；
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Bou&R$x8zx^sOpYH';

# 3、root账号只允许本地登录，为了安全起见，我们创建一个用来远程登录的外部账号sqldb,密码MrZa#Vkqv6a%QsAC89
use mysql;
CREATE USER 'sqldb'@'localhost' IDENTIFIED BY 'MrZa#Vkqv6a%QsAC89'; 
# 授权
GRANT ALL PRIVILEGES ON *.* TO  'sqldb'@'%' identified by "MrZa#Vkqv6a%QsAC89" WITH GRANT OPTION; 
# 刷新授权
FLUSH PRIVILEGES;

使用MySql

# 1、创建测试库
mysql -u root -p
# 创建测试库test，并设置字符集和排序规则
CREATE DATABASE test DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; 
# 查看数据库
show databases;

# 2、创建普通用户sqltest
CREATE USER 'sqltest'@'%' IDENTIFIED BY 'Za#Vkqv6a%QsAC10';
# 授权
GRANT select,insert,update,delete,create on test.* to 'sqltest'@'%' ; 
# 刷新权限 
FLUSH PRIVILEGES; 
# 查看用户 
select user,host from user; 
# 查看test用户权限 
show GRANTS for 'sqltest'@'%'; 

相关服务启动

# 启动
systemctl start mysqld.service 
# 查看状态
systemctl status mysqld.service 
# 关闭
systemctl stop mysqld.service 
# 重启
systemctl restart mysqld.service 
# 设置开机启动
systemctl enable mysqld.service 
# 关闭防火墙
systemctl stop firewalld.service