Linux 搭建mysql数据库详细步骤

软件共享位置

可以去网盘下载
链接：https://pan.baidu.com/s/1DnP4ox6Ad2ur4MDiATn74Q?pwd=my7s
提取码：my7s官网下载位置
https://dev.mysql.com/downloads/mysql/

上传软件包到服务器上

解压软件包（中途报错可能是没有安装解压工具）
tar -xvf mysql-8.0.28-1.el7.x86_64.rpm-bundle.tar


安装解压好的rpm软件包
3.1
[root@dcc mysql]# rpm -ivh mysql-community-common-8.0.28-1.el7.x86_64.rpm --nodeps --force
警告：mysql-community-common-8.0.28-1.el7.x86_64.rpm: 头V4 RSA/SHA256 Signature, 密钥 ID 3a79bd29: NOKEY
准备中… ################################# [100%]
正在升级/安装…
1:mysql-community-common-8.0.28-1.e################################# [100%]
3.2.
[root@dcc mysql]# rpm -ivh mysql-community-libs-8.0.28-1.el7.x86_64.rpm --nodeps --force
警告：mysql-community-libs-8.0.28-1.el7.x86_64.rpm: 头V4 RSA/SHA256 Signature, 密钥 ID 3a79bd29: NOKEY
准备中… ################################# [100%]
正在升级/安装…
1:mysql-community-libs-8.0.28-1.el7################################# [100%]
3.3
[root@dcc mysql]# rpm -ivh mysql-community-client-8.0.28-1.el7.x86_64.rpm --nodeps --force
警告：mysql-community-client-8.0.28-1.el7.x86_64.rpm: 头V4 RSA/SHA256 Signature, 密钥 ID 3a79bd29: NOKEY
准备中… ################################# [100%]
正在升级/安装…
1:mysql-community-client-8.0.28-1.e################### ( 57%)
3.4
[root@dcc mysql]# rpm -ivh mysql-community-server-8.0.28-1.el7.x86_64.rpm --nodeps --force
警告：mysql-community-server-8.0.28-1.el7.x86_64.rpm: 头V4 RSA/SHA256 Signature, 密钥 ID 3a79bd29: NOKEY
准备中… ################################# [100%]
正在升级/安装…
1:mysql-community-server-8.0.28-1.e# ( 4%)


检查是否安装好mysql软件
rpm -qa | grep mysql


创建mysql用户
chown mysql:mysql /var/lib/mysql -R


开启mysqld服务设置开启自启动，查看mysqld运行状态。
systemctl start mysqld.service
systemctl enable mysqld
systemctl status mysqld


查看mysqld服务初始化密码
cat /var/log/mysqld.log | grep password


登录mysql并修改初始化密码
[root@dcc ~]# mysql -uroot -p
Enter password: 输入初始化密码


进入数据库命令行下修改密码
mysql> alter user root@localhost identified by ‘713Lwl…’;
mysql> flush privileges;

查看服务端口运行状态
[root@dcc ~]# netstat -tunlp | grep mysql
tcp6 0 0 :::3306 :: LISTEN 11063/mysqld
tcp6 0 0 :::33060 :: LISTEN 11063/mysqld


通过以下命令，关闭 firewall(防火墙）
systemctl stop firewalld.service;
systemctl disable firewalld.service;
systemctl mask firewalld.service;