2、MySQL5.6 安装

最新推荐文章于 2022-09-30 20:03:32 发布

「已注销」

最新推荐文章于 2022-09-30 20:03:32 发布

阅读量211

点赞数 1

分类专栏： CentOS 软件安装文章标签： CentOS MySQL

本文链接：https://blog.csdn.net/LiYaCai/article/details/103483381

版权

CentOS 软件安装专栏收录该内容

7 篇文章 0 订阅

订阅专栏

1、卸载已安装的 MySQL 数据库

rpm -qa | grep mysql | xargs rpm -e --nodeps
rpm -qa | grep mariadb | xargs rpm -e --nodeps

2、下载安装包文件

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

3、安装mysql-community-release-el7-5.noarch.rpm包

rpm -ivh mysql-community-release-el7-5.noarch.rpm
#删除文件
rm -rf mysql-community-release-el7-5.noarch.rpm

4、安装MySQL

yum -y install mysql-server

5、启动 MySQL 服务

#设置 mysql 开机启动
systemctl enable mysqld.service
#启动 mysql
systemctl start mysqld.service

6、设置密码和远程主机登录

mysql -uroot -e "SET PASSWORD FOR 'root'@'%' = PASSWORD('admin');"
mysql -uroot -padmin -e "GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'admin';"
mysql -uroot -padmin -e "FLUSH PRIVILEGES;"

Shell 脚本

#!/bin/bash
rpm -qa | grep mysql | xargs rpm -e --nodeps
rpm -qa | grep mariadb | xargs rpm -e --nodeps
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
rpm -ivh mysql-community-release-el7-5.noarch.rpm
rm -rf mysql-community-release-el7-5.noarch.rpm
yum -y install mysql-server
if [ $(rpm -qa | grep mysql |wc -l) -ne 0 ];
then
	systemctl enable mysqld.service
	systemctl start mysqld.service
	mysql -uroot -e "SET PASSWORD FOR 'root'@'%' = PASSWORD('admin');"
	mysql -uroot -padmin -e "GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'admin';"
	mysql -uroot -padmin -e "FLUSH PRIVILEGES;"
	echo "安装成功"
else
	echo "安装失败!"
fi