mysql-community-server安装

cxy_6

已于 2025-02-12 10:52:06 修改

阅读量338

点赞数 4

文章标签： mysql adb 数据库

于 2025-02-10 22:00:37 首次发布

本文链接：https://blog.csdn.net/weixin_53662874/article/details/145559064

版权

centos7安装mysql-community-server

1、yum方式安装

rpm -Uvh  http://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm && yum -y install mysql-community-server

如果有报错则

rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

yum install mysql-community-server

2、开启服务并设置开机自启

systemctl start mysqld && systemctl enable mysqld && systemctl status mysqld

3、iptables放通服务端口

iptables -I INPUT -p tcp --dport 3306 -j ACCEPT && iptables-save

4、查看mysql的初始登录密码

grep 'temporary password' /var/log/mysqld.log | awk -F ' ' '{print $11}'

5、登录mysql更改密码（安全策略）和任何主机登录

PASSWORD1=`grep 'temporary password' /var/log/mysqld.log | awk -F ' ' '{print $11}'`

mysql -u root -p$PASSWORD1 

set global validate_password_policy=0; //更改密码策略

set global validate_password_length=1; //更改密码长度

alter user 'root'@'localhost' identified by 'root';  //更改密码

update mysql.user set host = '%' where user='root';  //更改仅localhost主机登录

flush privileges;  

select host from mysql.user where user='root';  //查看更改

-------------------------------------------------------------------------------------------------------------

vi mysql_install.sh

#!/bin/bash

rpm -Uvh http://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm > /dev/null && rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022 > /dev/null && yum -y install mysql-community-server > /dev/null && systemctl start mysqld && systemctl enable mysqld && systemctl status mysqld && iptables -I INPUT -p tcp --dport 3306 -j ACCEPT && iptables-save > /dev/null && echo "password :" && grep 'temporary password' /var/log/mysqld.log | awk -F ' ' '{print $11}'

sh mysql_install.sh

然后执行上面第5步骤