第 3 步：Mysql5.7安装

Mysql5.7安装

一、部署环境

二、安装

1）软件包准备

软件包名称：mysql-5.7.30-1.el7.x86_64.rpm-bundle.tar

上传软件包至/home目录下

创建文件夹：

[root@hadoop-node1 home]# mkdir mysql-rpm

解压：

[root@hadoop-node1 home]# tar -axvf mysql-5.7.30-1.el7.x86_64.rpm-bundle.tar  -C  mysql-rpm
mysql-community-common-5.7.30-1.el7.x86_64.rpm
mysql-community-server-5.7.30-1.el7.x86_64.rpm
mysql-community-test-5.7.30-1.el7.x86_64.rpm
mysql-community-client-5.7.30-1.el7.x86_64.rpm
mysql-community-embedded-5.7.30-1.el7.x86_64.rpm
mysql-community-libs-5.7.30-1.el7.x86_64.rpm
mysql-community-devel-5.7.30-1.el7.x86_64.rpm
mysql-community-embedded-compat-5.7.30-1.el7.x86_64.rpm
mysql-community-embedded-devel-5.7.30-1.el7.x86_64.rpm
mysql-community-libs-compat-5.7.30-1.el7.x86_64.rpm

2）删除原有的mariadb

查询：

[root@hadoop-node1 home]#  rpm -qa|grep mariadb
mariadb-libs-5.5.65-1.el7.x86_64

删除：

[root@hadoop-node1 home]# rpm -e --nodeps mariadb-libs-5.5.65-1.el7.x86_64

安装：

目前只需要安装4个必须的rpm包，其他的包暂时无用

[root@hadoop-node1 home]# cd mysql-rpm
[root@hadoop-node1 mysql-rpm]# rpm -ivh mysql-community-common-5.7.30-1.el7.x86_64.rpm
[root@hadoop-node1 mysql-rpm]# rpm -ivh mysql-community-libs-5.7.30-1.el7.x86_64.rpm
[root@hadoop-node1 mysql-rpm]# rpm -ivh mysql-community-client-5.7.30-1.el7.x86_64.rpm
[root@hadoop-node1 mysql-rpm]# rpm -ivh mysql-community-server-5.7.30-1.el7.x86_64.rpm

3）设置配置文件

创建目录：

[root@hadoop-node1 home]# mkdir -p /home/data/mysql

修改配置文件：

修改命令：

[root@hadoop-node1 home]# vi /etc/my.cnf

修改内容：

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/home/data/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
character-set-server=utf8
#忽略大小写
lower_case_table_names=1

初始化：

• 设置权限：

[root@hadoop-node1 home]# chown mysql:mysql /home/data/mysql -R

• 初始化：

[root@hadoop-node1 home]# mysqld --initialize

• 设置启动项：

[root@hadoop-node1 home]# systemctl start mysqld
[root@hadoop-node1 home]# systemctl enable mysqld

4）修改密码

查看初始化密码：

[root@hadoop-node1 home]# cat /var/log/mysqld.log | grep password

登录：

[root@hadoop-node1 home]# mysql -u root -p
Enter password:

注：遇到错误 Access denied for user ‘root’@’localhost’ (using password: YES)，重启mysql解决

修改密码：

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'pqtel88886035';

开放远程访问：

mysql> create user 'root'@'%' identified with mysql_native_password by 'pqtel88886035';
mysql> grant all privileges on *.* to 'root'@'%' with grant option;
mysql> flush privileges;
mysql> exit

5）初始化数据库

/home/pqtel-bigdata/init目录下stk.sql文件。

• 创建数据库stk
• 使用第三方软件Navicat 执行sql文件进行数据库表的建立