centos服务器yum方式安装mysql

登录mysql官网下载rpm包

mysql官网下载地址

找到对应的mysql版本和操作系统信息

我们可以下载第一个包，包含了所有的mysql相关的rpm包

wget  https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.37-1.el7.x86_64.rpm-bundle.tar

解压文件

tar -xf mysql-5.7.37-1.el7.x86_64.rpm-bundle.tar

yum安装解压出来所有的文件

先安装依赖包：

yum install -y net-tools perl libaio openssl gcc pcre-devel zlib-devel openssl vim openssl-devel

安装依赖：

rpm -ivh mysql-community-common-5.7.29-1.el6.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.29-1.el6.x86_64.rpm
rpm -ivh mysql-community-client-5.7.29-1.el6.x86_64.rpm
rpm -ivh mysql-community-server-5.7.29-1.el6.x86_64.rpm

启动mysql

service mysqld start

查看初始密码

grep 'temporary password' /var/log/mysqld.log

[root@Server-bcb191bf-370e-4942-afca-9b8df55bfe6d ~]# grep 'temporary password' /var/log/mysqld.log
2022-03-31T08:10:37.449385Z 1 [Note] A temporary password is generated for root@localhost: wNgQu11BZ9.K

mysql -uroot -p 进入mysql

修改初始密码：

set password for root@localhost = password('XXXXX');

创建新用户：

create user test01@'%' identified by '123456';

分配权限

grant all privileges on test01.* to test01@'%';

退出