#下载地址
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';