Mysql源的安装

一、MySQLyum源

1. 配置yum源

下载MySQL源安装包：

curl -O https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm

安装MySQL源：

yum localinstall mysql57-community-release-el7-11.noarch.rpm

检查MySQL源是否安装成功：

yum repolist enabled | grep "mysql.*-community.*"

显示如下就表示安装成功：

mysql-connectors-community/x86_64 MySQL Connectors Community                  51mysql-tools-community/x86_64      MySQL Tools Community                       63mysql57-community/x86_64          MySQL 5.7 Community Server                 267

 

2. 安装MySQL

yum install mysql-community-server

 

3. 启动MySQL服务

systemctl start mysqld

 

4. 查看MySQL状态

systemctl status mysqld

 

5. 设置MySQL开机启动

systemctl enable mysqld# 对于新创建的unit文件或修改了的unit文件，要通知systemd重载此配置文件systemctl daemon-reload

 

6. 修改root本地登录密码

查找root默认密码：

grep 'temporary password' /var/log/mysqld.log

显示：

2018-07-05T12:25:29.669624Z 1 [Note] A temporary password is generated for root@localhost: EevE.Mb=/2lw

修改root本地登录密码：

mysql -u root -p

Enter password:

mysql> alter user 'root'@'localhost' identified by 'MyPass68@';

Query OK, 0 rows affected (0.00 sec)

给root帐号开启远程访问权限：

# 这里主要为集群节点开发远程访问权限mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.10.26.%' IDENTIFIED BY 'MyPasmysql> UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';mysql> FLUSH PRIVILEGES;

 

二、创建数据库与帐号

 

1. 为Hive创建帐号与数据库（metastore）

mysql> CREATE DATABASE metastore DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;Query OK, 1 row affected (0.00 sec)

mysql> GRANT ALL ON metastore.* TO 'hive'@'%' IDENTIFIED BY 'MyPass99@';Query OK, 0 rows affected (0.00 sec)

 

2. 为Druid创建帐号与数据库（druid）

mysql> CREATE DATABASE druid DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;Query OK, 1 row affected (0.00 sec)

mysql> GRANT ALL ON druid.* TO 'druid'@'%' IDENTIFIED BY 'MyPass99@';Query OK, 0 rows affected (0.00 sec)

 

3. 为Oozie创建帐号与数据库（oozie）

mysql> CREATE DATABASE oozie DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;Query OK, 1 row affected (0.00 sec)

mysql> GRANT ALL ON oozie.* TO 'oozie'@'%' IDENTIFIED BY 'MyPass99@';Query OK, 0 rows affected (0.00 sec)

 

4. 确认创建的所有数据库

mysql> SHOW DATABASES;

 

5. 确认授予用户的权限

mysql> SHOW GRANTS FOR 'hive'@'%';mysql> SHOW GRANTS FOR 'druid'@'%';mysql> SHOW GRANTS FOR 'oozie'@'%';