下载mysql
下载地址:https://dev.mysql.com/downloads/mysql/
进去后点击查看其它版本
选择操作系统版本,认准“RPM Bundle”,点击“Download”下载。
附上一键安装脚本:
vim mysql_install.sh
#!/bin/bash
#关闭firewalld和selinux
systemctl stop firewalld
systemctl disable firewalld
if [ "$(getenforce)" != "Disabled" ] ;then
sed -i 's/=enforcing/=disabled/g' /etc/selinux/config
setenforce 0
fi
#安装mysqld
install_mysqld() {
MYSQL_DIR="/data/mysql_data/mysql"
VER='5.7.34'
######################################################
#删除冲突包
rpm -qa | egrep -i "(mariadb|mysql|postfix)" | xargs -i rpm -ev --nodeps {}
mkdir -p ./mysql_rpm
tar -xf mysql-$VER-1.el7.x86_64.rpm-bundle.tar -C ./mysql_rpm
#添加mysql用户
useradd -r mysql &>/dev/null
#开始安装mysql
yum -y install perl-JSON perl-Data-Dumper.x86_64 net-tools libaio
[ -f /etc/my.cnf ] && \cp /etc/my.cnf{,.bak} && rm -rf /etc/my.cnf
rpm -ivh mysql_rpm/mysql-community-common-$VER-1.el7.x86_64.rpm
rpm -ivh mysql_rpm/mysql-community-libs-$VER-1.el7.x86_64.rpm
rpm -ivh mysql_rpm/mysql-community-client-$VER-1.el7.x86_64.rpm
rpm -ivh mysql_rpm/mysql-community-server-$VER-1.el7.x86_64.rpm
rpm -ivh mysql_rpm/mysql-community-devel-$VER-1.el7.x86_64.rpm
rpm -ivh mysql_rpm/mysql-community-libs-compat-$VER-1.el7.x86_64.rpm
#修改数据库根目录,并且创建该目录
rm -rf ${MYSQL_DIR} &>/dev/null
sed -i "/^datadir/s:/var/lib/mysql:${MYSQL_DIR}:" /etc/my.cnf
sed -i "/^socket/s:/var/lib/:/data/mysql_data/:" /etc/my.cnf
echo "
[client]
default-character-set=utf8
socket=${MYSQL_DIR}/mysql.sock
[mysql]
default-character-set=utf8
socket=${MYSQL_DIR}/mysql.sock
" >> /etc/my.cnf
[ ! -d ${MYSQL_DIR} ] && mkdir -p ${MYSQL_DIR}
[ -d ${MYSQL_DIR} ] && chown -R mysql.mysql ${MYSQL_DIR}
#启动mysql,并且修改密码为root
mysqld --initialize --user=mysql
systemctl restart mysqld
systemctl enable mysqld
TMP_PASS=`grep "temp.* password" /var/log/mysqld.log | tail -1 | sed -r 's/([0-9].*:)\s(.*)/\2/'`
mysql -uroot -p${TMP_PASS} -e "alter user root@localhost identified by 'root'" --connect-expired-password &>/dev/null
[ $? -eq 0 ] && echo -e "\033[32;1m mysql安装完成 \033[0m"
rm -rf ./mysql_rpm
}
if [ ! -f /usr/lib/systemd/system/mysqld.service ] ; then
install_mysqld
else
echo "mysql服务已经安装,无需继续安装"
fi
上传从官网下载的mysql包到服务器,跟mysql_install.sh脚本目录同级。
执行安装脚本:
sh mysql_install.sh
安装完root密码为:root
默认配置文件为:/etc/my.cnf
mysql数据目录为:/data/mysql_data/mysql
登录mysql数据库
mysql -uroot -proot
安装完毕!
启停mysql
#启动mysql
systemctl start mysqld
#停止mysql
systemctl stop mysqld
#重启mysql
systemctl restart mysqld
#把mysql加入开机自启
systemctl enable mysqld