集群搭建系列（五）CentOS下 RPM 安装mysql 5.7.13

如果下载不到资源可以从 CSDN 下载 https://download.csdn.net/download/cs261244787/13721743

1、查看已有 mysql

rpm -qa | grep mysql

2、卸载已存在的

#yum -y remove 查询名字
检查并删除老版本mysql的开发头文件和库
命令：#rm -fr /usr/lib/mysql
　　　#rm -fr /usr/include/mysql
注意：卸载后/var/lib/mysql中的数据及/etc/my.cnf不会删除，如果确定没用后就手工删除
#rm -f /etc/my.cnf
#rm -fr /var/lib/mysql
#rm -fr /usr/share/mysql

3、安装依赖包

　yum -y install make gcc-c++ cmake bison-devel ncurses-devel libaio libaio-devel

4、 rpm 安装包下载、解压

wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.13-1.el6.x86_64.rpm-bundle.tar

 tar xvf mysql-5.7.13-1.el6.x86_64.rpm-bundle.tar

5 安装

--nodeps就是安装时不检查依赖关系，比如你这个rpm需要A，但是你没装A，这样你的包就装不上，用了--nodeps你就能装上了。
--force就是强制安装，比如你装过这个rpm的版本1，如果你想装这个rpm的版本2，就需要用--force强制安装
rpm -ivh mysql-community-common-5.7.13-1.el6.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-libs-5.7.13-1.el6.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-devel-5.7.13-1.el6.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-client-5.7.13-1.el6.x86_64.rpm
rpm -ivh mysql-community-server-5.7.13-1.el6.x86_64.rpm  --nodeps --force
server 如果报错 yum install numactl -y

6 配置 mysql 的初始化文件/etc/my.cnf （免密启动用）

cd /etc/
vim my.cnf
.在my.cnf的[mysqld]代码下方添加skip-grant-tables （免密启动用）
　[mysqld]
　skip-grant-tables

7.启动mysql

service mysqld start

8.验证mysql是否启动

[root@biz-141 etc]#  service mysqld start
Starting mysqld (via systemctl):  
                                                           [  OK  ]
[root@biz-141 etc]# netstat -apln | grep mysql
tcp6       0      0 :::3306                 :::*                    LISTEN      24133/mysqld        
unix  2      [ ACC ]     STREAM     LISTENING     2998257  24133/mysqld         /var/lib/mysql/mysql.sock

9.首次登录（第6步[mysqld]代码下方添加skip-grant-tables，目的是为了首次登录时不用输入密码）

mysql

10.显示以上，安装完成，远程 Windows 使用。如果测试使用至此可以结束。 作为大数据使用还有很多事要做。继续

这时，在 linux 下使用 root 账户连接 mysq l可以密码为空。
如telnet 3306端口不通，连接不上mysql，请关闭 linux 服务器防火墙。

11.安装后续工作，设置root密码

mysql> use mysql;
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> update user set authentication_string = password('Qweasd123'),host='%' where user = 'root';
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql>  flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql>  exit;
Bye

重启服务

[root@biz-141 etc]# service mysqld restart;
Restarting mysqld (via systemctl):                         [  OK  ]
[root@biz-141 etc]# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.13 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

这时，在windows下使用 Navicat 以 root 账户连接 mysql 需要使用密码“111111”。
至此，完成rpm包安装mysql

老夫写代码没有框架 复制粘贴、直接梭哈。干脚本！

create database metastore default character set utf8;
CREATE USER 'hive'@'%' IDENTIFIED BY 'Mhxzkhl123456';
GRANT ALL PRIVILEGES ON metastore.* TO 'hive'@'%';
FLUSH PRIVILEGES;

create database hue default character set utf8;
CREATE USER 'hue'@'%' IDENTIFIED BY 'Mhxzkhl123456';
GRANT ALL PRIVILEGES ON hue.* TO 'hue'@'%';
FLUSH PRIVILEGES;

create database ranger default character set utf8;
CREATE USER 'ranger'@'%' IDENTIFIED BY 'Mhxzkhl123456';
GRANT ALL PRIVILEGES ON ranger.* TO 'ranger'@'%';
FLUSH PRIVILEGES;

create database azkaban default character set utf8;
CREATE USER 'azkaban'@'%' IDENTIFIED BY 'Mhxzkhl123456';
GRANT ALL PRIVILEGES ON azkaban.* TO 'azkaban'@'%';
FLUSH PRIVILEGES;

create database scm default character set utf8; 
CREATE USER 'scm'@'%' IDENTIFIED BY 'Mhxzkhl123456';
GRANT ALL PRIVILEGES ON scm.* TO 'scm'@'%';  
FLUSH PRIVILEGES; 

create database amon default character set utf8;
CREATE USER 'amon'@'%' IDENTIFIED BY 'Mhxzkhl123456';
GRANT ALL PRIVILEGES ON amon.* TO 'amon'@'%';
FLUSH PRIVILEGES;

create database rman default character set utf8;
CREATE USER 'rman'@'%' IDENTIFIED BY 'Mhxzkhl123456';
GRANT ALL PRIVILEGES ON rman.* TO 'rman'@'%';
FLUSH PRIVILEGES;


create database navms default character set utf8;
CREATE USER 'navms'@'%' IDENTIFIED BY 'Mhxzkhl123456';
GRANT ALL PRIVILEGES ON navms.* TO 'navms'@'%';
FLUSH PRIVILEGES;

create database nav default character set utf8;
CREATE USER 'nav'@'%' IDENTIFIED BY 'Mhxzkhl123456';
GRANT ALL PRIVILEGES ON nav.* TO 'nav'@'%';
FLUSH PRIVILEGES;

create database kafka default character set utf8;
CREATE USER 'kafka'@'%' IDENTIFIED BY 'Mhxzkhl123456';
GRANT ALL PRIVILEGES ON kafka.* TO 'kafka'@'%';
FLUSH PRIVILEGES;

用 Hive 账号测一下

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| amon               |
| azkaban            |
| hue                |
| kafka              |
| metastore          |
| mysql              |
| nav                |
| navms              |
| performance_schema |
| ranger             |
| rman               |
| scm                |
| sys                |
+--------------------+
14 rows in set (0.01 sec)

mysql> quit
Bye
[root@biz-141 etc]# mysql -u hive -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 15
Server version: 5.7.13 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| metastore          |
+--------------------+
2 rows in set (0.00 sec)

mysql> quit