1 下载mysql安装包
wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm [5.7]
wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm [8.0]
2 安装mysql安装源
yum -y localinstall mysql57-community-release-el7-11.noarch.rpm
3 在线安装MySQL
yum -y install mysql-community-server
4 启动MySQL服务
命令:systemctl start mysqld
5 设置开机启动
命令:systemctl enable mysqld
systemctl daemon-reload
6 修改root登录密码
mysql安装完成之后,会在/var/log/mysqld.log文件中给root生成了一个临时的默认密码。
vim /var/log/mysqld.log
7 重置密码
修改密码, mysql不修改密码不能直接进行库表操作。
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Test2016@';
8 设置允许远程登录
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Test2016@' WITH GRANT OPTION
9 防火墙开放3306端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload
10 配置mysql默认编码为utf-8
修改/etc/my.cnf配置文件,在[mysqld]下添加编码配置
character_set_server=utf8
init_connect='SET NAMES utf8'
11 重启MySQL
systemctl restart mysqld
12 登录root用户查看编码
13 测试远程连接
Centos7 安装mysql
最新推荐文章于 2023-08-24 16:12:57 发布