Linux离线安装MySQL5.7.24
Linux离线安装MySQL5.7.24
目录
一、下载安装包
安装依赖
yum -y install perl autoconf gcc gcc-c++ make cmake lrzsz net-tools libaio官方地址：https://downloads.mysql.com/archives/community/
mysql-5.7.24-1.el7.x86_64.rpm-bundle.tar：https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.24-1.el7.x86_64.rpm-bundle.tar
二、卸载mariadb
1、查看mariadb数据库是否安装
rpm -qa | grep mariadb
which mysql
whereis mysql
2、卸载mariadb
rpm -e mariadb-server --nodeps
rpm -e mariadb-* --nodeps
rpm -e mariadb-devel --nodeps
rpm -e mariadb-libs --nodeps3、重新查看
rpm -qa | grep mariadb4、查看mysql是否有安装过
rpm -qa | grep -i mysql5、查看mysql相关文件
把所有相关的文件全部删除
find / -name mysql三、安装MySQL
1、解压缩包
tar xvf mysql-5.7.24-1.el7.x86_64.rpm-bundle.tar
2、安装依赖包和服务（按顺序安装）
rpm -Uvh mysql-community-common-5.7.24-1.el7.x86_64.rpm
rpm -Uvh mysql-community-libs-5.7.24-1.el7.x86_64.rpm
rpm -Uvh mysql-community-devel-5.7.24-1.el7.x86_64.rpm
rpm -Uvh mysql-community-libs-compat-5.7.24-1.el7.x86_64.rpm
rpm -Uvh mysql-community-client-5.7.24-1.el7.x86_64.rpm
rpm -Uvh mysql-community-server-5.7.24-1.el7.x86_64.rpm
3、查看版本和运行状态
mysql --versionservice mysqld status
四、配置MySQL
1、查看磁盘挂载空间
df -h可以看到，/home目录挂载的磁盘容量有2.7T，所以将MySQL的数据存储路径修改到 /home目录下
2、配置MySQL存储目录
cp /etc/my.cnf /etc/my.cnf.template
vim /etc/my.cnf3、home目录下创建数据目录，使用软链接链接到默认目录
mkdir -p /home/var/lib/mysql
ln -s /home/var/lib/mysql /var/lib/mysql
ll /var/lib/mysql
五、初始化数据库
1、启动MySQL
service mysqld start 2、查看状态
service mysqld status
3、查看临时密码
grep password /var/log/mysqld.log
4、初始化数据库
sudo /usr/bin/mysql_secure_installation提示输入密码输入回车键，显示 Disallow root login remotely? [Y/n] 输入n键，其它输入 Y键
如果提示：... Failed! Error: Your password does not satisfy the current policy requirements
将刚刚查询的临时密码输入，作为正式密码
Estimated strength of the password: 25 Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y New password: Re-enter new password: Remove anonymous users? (Press y|Y for Yes, any other key for No) : y Success. Disallow root login remotely? (Press y|Y for Yes, any other key for No) : n Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y All done!
六、修改密码策略
1、查看密码策略
show variables like '%validate_password_policy%';
show variables like '%validate_password_length%';2、修改密码策略
set global validate_password_policy=0;
set global validate_password_length=1;3、修改密码为root
set password=password('root');SET PASSWORD FOR 'root'@'localhost' = PASSWORD('root');4、 给root用户赋所有权限
grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option;
flush privileges;七、允许防火墙通行
firewall-cmd --add-port=3306/tcp --permanent
firewall-cmd --reload
firewall-cmd --list-ports八、设置开机自启
systemctl enable mysqldchkconfig --add mysqld九、MySQL卸载
rpm -e mysql-community-server
rpm -e mysql-community-client
rpm -e mysql-community-devel
rpm -e mysql-community-libs-compat --nodeps
rpm -e mysql-community-libs --nodeps
rpm -e mysql-community-commonrpm -qa | grep -i mysqlrm -rf /var/lib/mysql/*
rm -rf /var/log/mysql*
rm -rf /var/run/mysqld/*十、yum在线安装
wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
yum -y localinstall mysql57-community-release-el7-11.noarch.rpm
yum -y install mysql-community-server
mysql --version
systemctl start mysqld