-
配置yum源
1.下载mysql源安装包wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
##如果报错-bash: wget: command not found的话 安装wget
yum -y install wget
2.安装mysql源
yum localinstall mysql57-community-release-el7-8.noarch.rpm
3.检查mysql源是否安装成功
yum repolist enabled | grep "mysql.*-community.*"
安装成功结果
[root@iZ8vbe3n0yb60d2flayh2kZ local]# yum repolist enabled | grep "mysql.*-community.*" mysql-connectors-community/x86_64 MySQL Connectors Community 118 mysql-tools-community/x86_64 MySQL Tools Community 95 mysql57-community/x86_64 MySQL 5.7 Community Server 364
-
安装mysql
yum install mysql-community-server
在这过程中会询问的都按y然后回车允许
-
启动MySQL服务
1.启动mysql服务
systemctl start mysqld
2.查看mysql状态
systemctl status mysqld
3.设置MySQL开机启动
systemctl enable mysqld systemctl daemon-reload
-
修改root默认密码
1.找到root默认密码grep 'temporary password' /var/log/mysqld.log
2.进入mysql控制台mysql -uroot -p
3.修改密码
用该密码登录到服务端后,必须马上修改密码,不然会报错误
最新mysql要求密码必须包含大小写字母和字符,长度大于等于8个字符mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Root123!';
修改mysql参数设置任意密码
首先,修改validate_password_policy参数的值mysql> set global validate_password_policy=0;
再修改密码的长度
mysql> set global validate_password_length=1;
再次修改密码
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
4.授权远程登录
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
5.立即生效
mysql> flush privileges;
6.退出
mysql> exit
-
防火墙设置
查看状态:firewall-cmd --state 开启:systemctl start firewalld 开放端口:firewall-cmd --permanent --zone=public --add-port=3306/tcp 重新载入防火墙规则:firewall-cmd --reload 检查是否生效:firewall-cmd --zone=public --query-port=3306/tcp
-
登录云服务控制台配置安全组规则
为了防止被恶意攻击,建议修改所有端口
Centos7.3服务器mysql安装与配置
最新推荐文章于 2024-07-02 11:32:11 发布