RedHat7.1离线安装MySQL5.7.22

1、查看系统是否存在默认数据库Mariadb。存在 转2

shell> rpm –qa | grep mariadb;

 2、卸载数据库

shell> Rpm –e –nodeps mariadb-libs-version;

1. 下载安装包

1. 安装安装包

shell> rpm -ivh mysql-community-server-version-distribution-arch.rpm

必须安装的包：mysql-community-server, mysql-community-client, mysql-community-libs,mysql-community-common, mysql-community-libs-compat

安装顺序：common —— libs —— libs-compat —— Client —— Service

1. 是否安装成功检测

shell> rpm –qa | grep mysql;

1. 启动服务

shell> service mysqld start;

查看初始密码

shell> sudo grep 'temporary password' /var/log/mysqld.log

修改密码

shell> mysql -uroot –p

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

1. 开启防火墙

开启端口

firewall-cmd --zone=public --add-port=80/tcp –permanent

重启防火墙

firewall-cmd –reload

8、1130错误

错误：ERROR 1130: Host '192.168.1.3' is not allowed to connect to thisMySQL serve

错误1130：主机192.168.1.3”不允许连接到thismysql服务

原因：被连接的数据不允许使用 192.168.1.3访问，只允许是用 localhost;

解决方案

总体运行语句:

mysql -u root -p

mysql>use mysql;

mysql>select 'host' from user where user='root';

mysql>update user set host = '%' where user ='root';

mysql>flush privileges;

mysql>select 'host'   from user where user='root';

 

运行完毕后再次连接测试，若还不行重启mysql服务，或是直接重启电脑