Linux上MySQL的安装

本文为Linux环境下MySQL的安装步骤、环境为Centos7
安装软件所需的网盘链接：链接:https://pan.baidu.com/s/1sDUuGd-7El070CF8T6n3TQ 密码:enur
1:清除并以RPM包的形势安装MySQL
yum remove mysql-libs
rpm -ivh mysql-community-common-5.7.19-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.19-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.19-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.19-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.19-1.el7.x86_64.rpm（可选）

2:清除并以RPM包的形势安装MySQL
2.1:启动MySQL
service mysqld start 或者 systemctl start mysqld.service
2.2:查看root用户的密码
cat /var/log/mysqld.log | grep password
2.3:登录后修改密码
alter user ‘root’@‘localhost’ identified by ‘First_MySQL_1’;

3:MySQL基本信息的配置
3.1:创建一个新的数据库
create database fruitstore;
3.2:创建一个新的用户
create user ‘owner’@’%’ identified by ‘First_MySQL_1’;
3.3:授予用户相应权限
grant all on hive.* TO ‘owner’@’%’;
grant all on hive.* TO ‘owner’@‘localhost’ identified by ‘First_MySQL_1’;