下载地址:https://pan.baidu.com/s/1gz97DWglvns7Cib_fDVWqA
提取码:15xp
1.在 /usr/local/下新建mysql文件夹,将 MySQL 安装包放进去
2.进入 /usr/local/mysql,解压安装包。
tar -xvf mysql-版本号.el7.x86_64.rpm-bundle.tar
3.安装 MySQL 之前要先删除 mariadb,检查是否有 mariadb
rpm -qa | grep mariadb
4.如果有先卸载 mariadb
rpm -e mariadb-libs-5.5.44-2.el7.centos.x86_64 --nodeps
5.开始安装 MySQL
rpm -ivh mysql-community-common-版本号.el7.x86_64.rpm --nodeps--force
rpm -ivh mysql-community-libs-版本号.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-client-版本号.el7.x86_64.rpm --nodeps--force
rpm -ivh mysql-community-server-版本号.el7.x86_64.rpm --nodeps--force
6.检查安装结果
rpm -qa | grep mysql
7.初始化 MySQL
mysqld --initialize
8.授权防火墙
chown mysql:mysql /var/lib/mysql -R;
systemctl start mysqld.service;
systemctl enable mysqld;
9.查看数据库默认密码
cat /var/log/mysqld.log | grep password//这时可以查看到mysql的默认密码,后面要拿来登录使用
10.登录MYSQL
mysql -uroot -p
11.登录成功,修改密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';//修改密码为123456
12.exit 退出,使用新密码登陆
mysql>exit//改完密码后退出
mysql -uroot -p//重新登录
13.配置默认编码为UTF-8
- 修改/etc/my.cnf配置文件,在[mysqld]下添加编码配置,如下图所示
character_set_server=utf8
init_connect=‘SET NAMES utf8’
show variables like "%char%";//查看编码
出现下图证明utf-8设置成功
14.开启远程访问。
create user 'root'@'%' identified with mysql_native_password by'123456';
grant all privileges on *.* to 'root'@'%' with grant option;
flush privileges;
15.开放 3306 端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
systemctl restart firewalld.service
firewall-cmd --reload