安装mysql8 及常规操作

安装sql
wget http://repo.mysql.com/mysql80-community-release-el7-3.noarch.rpm
rpm -Uvh mysql80-community-release-el7-3.noarch.rpm
yum install mysql-community-server

启动MySQL
systemctl start mysqld.service

检查MySQL状态
systemctl status mysqld.service

默认root密码
cat /var/log/mysqld.log
grep “password” /var/log/mysqld.log

更改密码

alter user ‘root’@‘localhost’ identified by ‘cS20!022’;
flush privileges;

添加用户
CREATE USER admindb IDENTIFIED BY ‘cS20#023’;
FLUSH PRIVILEGES;

远程连接
grant all privileges on . to admindb@’%’ with grant option;

导入数据库
create database frbx;(创建数据库)
show databases;(就可看到所有已经存在的数据库，以及刚刚创建的数据库abc)
use frbx;(进入abc数据库下面)
show tables;(产看abc数据库下面的所有表,空的)
source /home/bx.sql（导入数据库表）
show tables;(查看abc数据库下面的所有表,就可以看到表了)

授权全部
grant all privileges on . to ‘admindb’@’%’ with grant option;

查询用户权限
show grants for ‘admindb’@’%’;