centos7rpm安装mysql8

#下载地址
https://dev.mysql.com/downloads/

#centos 7默认是mariadb数据库，再去安装mysql之前要先下载mariadb

rpm -qa | grep mariadb

rpm -e --nodeps mariadb-libs-8.0.15-2.el7_0.x86_64

 

#rpm安装
sudo rpm -ivh mysql-community-common-8.0.15-1.el7.x86_64.rpm

sudo rpm -ivh mysql-community-libs-8.0.15-1.el7.x86_64.rpm

sudo rpm -ivh mysql-community-client-8.0.15-1.el7.x86_64.rpm

sudo rpm -ivh mysql-community-server-8.0.15-1.el7.x86_64.rpm

#启动服务
sudo systemctl start mysqld

#停止服务
sudo systemctl stop mysqld

#查看初试密码
sudo grep 'temporary password' /var/log/mysqld.log

#登录
sudo mysql -uroot -p

#修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'a123456';

#查看密码规则
SHOW VARIABLES LIKE 'validate_password%';

#修改密码规则
set global validate_password.policy=0;
set global validate_password.length=1;

#授权 root 用户的所有权限并设置远程访问
CREATE USER 'root'@'%' IDENTIFIED BY 'a123456';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'a123456';

#设置为远程登录
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';

#刷新权限
flush privileges;

SHOW GRANTS FOR root;

#’root’@’%’没有grant的权限
update mysql.user set Grant_priv='Y',Super_priv='Y' where user = 'root' and host = '%';
flush privileges;

#重启mysql
sudo systemctl restart mysqld

#/etc/my.cnf 配置
sudo vi /etc/my.cnf

# 设置3306端口
port=3306
# 允许最大连接数
max_connections=1000
# 允许连接失败的次数。
max_connect_errors=10
#导入最大文件
max_allowed_packet = 1024M
# 服务端使用的字符集默认为UTF8
character-set-server=utf8mb4
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
# 默认使用“mysql_native_password”插件认证 ZviO+idYq9O7
#mysql_native_password
default_authentication_plugin=mysql_native_password
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
log-bin-trust-function-creators=1

#表名大小写不敏感，需要停止mysqld服务，删除 /var/lib/mysql目录，重新启动初始化，初试密码在：/var/log/mysqld.log

lower_case_table_names=1

#密码规则,初始化后，设置，在重新启动mysqld
validate_password.policy=0
validate_password.length=1

 

[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8mb4

[client]
# 设置mysql客户端连接服务端时默认使用的端口
port=3306
default-character-set=utf8mb4

[mysqldump]
user=root
password=a123456

 

#导入sql脚本--

sudo mysql -uroot -p

source /home/abc/a.sql

 

-- 创建数据库
CREATE DATABASE test_db;

-- 创建用户
CREATE USER 'test_admin'@'%' IDENTIFIED BY 'a123456';

-- 授权用户
GRANT ALL PRIVILEGES ON test_db.* TO 'test_admin'@'%';

-- 刷新用户权限
FLUSH PRIVILEGES;

SHOW GRANTS FOR test_admin;

ALTER USER 'test_admin'@'%' IDENTIFIED WITH mysql_native_password BY 'a123456789';