centos离线安装mysql

一、解压安装包

tar -xvf  mysql

解压后产生这些文件

二、安装mysql组件

按照common–>libs–>libs-compat–>client–>server的顺序依次安装组件

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

三、配置mysql

3.1 初始化mysql数据库

/usr/sbin/mysqld --initialize-insecure --user=mysql

3.2 启动mysql服务

/usr/sbin/mysqld --user=mysql&

3.3 登录mysql

mysql -uroot

3.4重置mysql密码

alter user 'root'@'localhost' identified by '123456';

3.5 增加远程登录权限

select user,host from user;#查询用户信息
update user set host='%' where host='localhost';#设置远程登录权限
flush privileges;#刷新配置信息