MySQL安装-----个人笔记

前提：卸载mariadb库

yum remove -y mariadb-libs.x86_64 

1.解压从MySQL下载来的tar包

tar xvf mysql-5.7.29-1.el7.x86_64.rpm-bundle.tar 

2.解压文件的作用

mysql-community-libs-compat-5.7.29-1.el7.x86_64.rpm —————>MySQL之前版本的共享兼容库

mysql-community-test-5.7.29-1.el7.x86_64.rpm —————>MySQL服务端的测试组件

mysql-community-devel-5.7.29-1.el7.x86_64.rpm —————>MySQL数据库客户端应用程序的开发头文件和库

mysql-community-common-5.7.29-1.el7.x86_64.rpm —————>服务端和客户端的公共文件

mysql-community-libs-5.7.29-1.el7.x86_64.rpm —————>客户端共享库

mysql-community-client-5.7.29-1.el7.x86_64.rpm —————>客户端及相关工具

mysql-community-server-5.7.29-1.el7.x86_64.rpm —————>服务端及相关工具

3.安装需要的rpm

rpm -ivh mysql-community-common-5.7.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.29-1.el7.x86_64.rpm

其实使用最后一个命令的时候它会爆一个警告：

忽略警告即可（原因：这是由于yum安装了旧版本的GPG keys造成的）：

rpm -ivh --nodeps mysql-community-server-5.7.29-1.el7.x86_64.rpm

 启动mysql服务并查看状态:

systemctl start mysqld

systemctl status mysqld

如下图所示就成功了：

查看MySQL临时密码：

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

 登入MySQL后修改密码策略:

set global validate_password_policy=0; 
set global validate_password_length=4; 

允许本地连接:

alter user 'root'@'localhost' identified by '您的密码'; 

允许远程连接(必须加上要不然连不上hive):

create user 'root'@'%' identified by '您的密码'; 

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '您的密码' WITH GRANT OPTION;