Centos7虚拟机安装mysql8
1 检查是否已经存在mysql,若存在卸载,避免安装时产生错误
rpm -qa | grep -i mysql
如果存在,请参考这篇文章
Centos7 虚拟机删除mariadb-CSDN博客
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';
如果没有生成默认密码或者生成的初始密码无法登录请参考
mysql8安装后没有自动生成登录密码-CSDN博客