本文主要是介绍【服务器运维】CentOS6 minimal 离线安装MySQL5.7，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
1.准备安装包（版本因人而异，所以下面的命令中版本省略，实际操作中用Tab自动补全就好了）
cloog-ppl-0.15.7-1.2.el6.x86_64.rpm
cpp-4.4.7-23.el6.x86_64.rpm
gcc-4.4.7-23.el6.x86_64.rpm
gcc-c++-4.4.7-23.el6.x86_64.rpm
glibc-2.12-1.212.el6.x86_64.rpm
glibc-common-2.12-1.212.el6.x86_64.rpm
glibc-devel-2.12-1.212.el6.x86_64.rpm
glibc-headers-2.12-1.212.el6.x86_64.rpm
kernel-2.6.32-754.el6.x86_64.rpm
kernel-headers-2.6.32-754.el6.x86_64.rpm
libaio-0.3.107-10.el6.x86_64.rpm
libaio-devel-0.3.107-10.el6.x86_64.rpm
libgcc-4.4.7-23.el6.x86_64.rpm
libgomp-4.4.7-23.el6.x86_64.rpm
libstdc++-4.4.7-23.el6.x86_64.rpm
libstdc++-devel-4.4.7-23.el6.x86_64.rpm
mpfr-2.4.1-6.el6.x86_64.rpm
mysql-5.7.24-1.el6.x86_64.rpm-bundle.tar
numactl-2.0.9-2.el6.x86_64.rpm
perl-5.10.1-144.el6.x86_64.rpm
perl-libs-5.10.1-144.el6.x86_64.rpm
perl-Module-Pluggable-3.90-144.el6.x86_64.rpm
perl-Pod-Escapes-1.04-144.el6.x86_64.rpm
perl-Pod-Simple-3.13-144.el6.x86_64.rpm
perl-version-0.77-144.el6.x86_64.rpm
ppl-0.10.2-11.el6.x86_64.rpm
tzdata-2018e-3.el6.noarch.rpm
2.查看并卸载已有的mysql和mariadb，避免版本冲突
rpm -qa | grep mysql
rpm -e mysql-lib-5.1.66-2.el6_3.i686 --nodeps
rpm -qa|grep mariadb
yum remove mariadb-libs.x86_64
–nodeps 排除依赖
3.安装gcc和gcc-c++
rpm -ivh mpfr
rpm -ivh cpp
rpm -ivh ppl
rpm -ivh cloog-ppl
rpm -Uvh tzdata
rpm -Uvh kernel-headers
rpm -Uvh glibc glibc-common gilbc-headers glibc-devel
rpm -Uvh libgomp
rpm -Uvh libgcc
rpm -ivh gcc
rpm -Uvh libstdc++ libstdc++devel
rpm -ivh gcc-c++
4.安装libiao、numactl、perl依赖包
rpm -Uvh libaio
rpm -Uvh numactl
rpm -ivh perl-* --nodeps
5.解压MySQL Bundle
tar -xvf mysql-.rpm-bundle.tar
6.安装MySQL
rpm -ivh
mysql-community-common
mysql-community-libs
mysql-community-server
mysql-community-client
7.查看初始密码
grep password /var/log/mysqld.log
或
grep 'temporary password' /var/log/mysqld.log
8.修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '密码';
9.允许root用户远程登录
use mysql;
update user set host='%' where user ='root';
flush privileges;
10.添加远程登录用户
grant all privileges on *.* to 'usr'@'%' identified by 'pwd' with grant option;
flush privileges;
11.其他
最后注意防火墙要设置端口，或者关闭防火墙，这样远程才能登录MySQL。
这篇关于【服务器运维】CentOS6 minimal 离线安装MySQL5.7的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
