安装MySQL

1、配置yum仓库

// 下载mysql的源文件
wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
// 把mysql源添加到本地
yum localinstall mysql57-community-release-el7-11.noarch.rpm -y
// 查看是否添加成功
repolist enabled | grep "mysql.*-community.*"

2、安装Mysql

// 安装musql服务
yum install -y mysql-community-server
// 启动服务
service mysqld start
// 查看服务状态
service mysqld status

3、Mysql相关配置

// 获取超级用户root的密码
grep ‘temporary password‘ /var/log/mysqld.log
?
// 登录mysql
mysql -uroot -p
?
// 修改密码限制
set global validate_password_policy=0; 
set global validate_password_mixed_case_count=0; 
set global validate_password_number_count=0;  
set global validate_password_special_char_count=0;  
set global validate_password_length=3;
SHOW VARIABLES LIKE ‘validate_password%‘;
?
// 修改root密码
ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘root‘;
?
// 修改其他服务器可登录
use mysql;
update user set host =‘%‘ where user =‘root‘;

4、其他信息

// 一些基础操作
CREATE USER ‘username‘@‘%‘ IDENTIFIED BY ‘password‘;
update user set host = ‘%‘ where user = ‘root‘;
?
grant all privileges on *.* to ‘hive‘@‘%‘ identified by ‘hive‘;
grant all privileges on *.* to ‘root‘@‘%‘ identified by ‘root‘ WITH GRANT OPTION;
?
flush privileges;
?
/etc/my.cnf mysql的主配置文件 
/var/lib/mysql mysql数据库文件存放位置 
/var/log mysql日志输出存放目录

安装MySQL

原文：https://www.cnblogs.com/wangzhaofei1226/p/10395012.html