Centos7虚拟机安装mysql8

2025-03-11 约 404 字预计阅读 1 分钟

https://bing.ee123.net/img/rand?artid=146181216

Centos7虚拟机安装mysql8

1 检查是否已经存在mysql，若存在卸载，避免安装时产生错误

rpm -qa | grep -i mysql

如果存在，请参考这篇文章

2. 删除mysql用户

userdel mysql

3. 重新创建mysql用户和组

groupadd -g 1000 mysql

useradd mysql -g mysql -p mysql

4. 上传mysql安装包到安装目录并解压

因为我用mobaxterm，直接在里面可以上传

[root@localhost mysql]# tar -xvf mysql-8.4.0-1.el7.x86_64.rpm-bundle.tar

5. 安装

[root@localhost mysql]# rpm -ivh mysql-community-server-8.4.0-1.el7.x86_64.rpm

执行上面的命令会报错，基本就是缺少依赖，那咱就挨个安装吧，反正下载的是bundle所有的以来都在里面，下面是安装顺序

6. 安装成功后查看MySQL服务状态

[root@localhost mysql]# systemctl status mysqld.service
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: inactive (dead)
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html

7. 启动mysql服务并再次查看服务状态


[root@localhost mysql]# systemctl start mysqld.service
[root@localhost mysql]# systemctl status mysqld.service
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since Tue 2025-03-11 16:26:51 CST; 21s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 1718 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 1787 (mysqld)
   Status: "Server is operational"
   CGroup: /system.slice/mysqld.service
           └─1787 /usr/sbin/mysqld

Mar 11 16:26:45 localhost.localdomain systemd[1]: Starting MySQL Server...
Mar 11 16:26:51 localhost.localdomain systemd[1]: Started MySQL Server.

8. 获取临时密码

[root@localhost mysql]# grep "password" /var/log/mysqld.log

9. 连接数据库修改密码

mysql -uroot -p

alter user ‘root’@’localhost’ identified by ‘your new password’;

如果没有生成默认密码或者生成的初始密码无法登录请参考