准备
提示:查看centos7是否有默认数据库:
查看centos7中是否有MariaDB
rpm -qa | grep mariadb
[root@localhost mysql]# rpm -qa | grep mariadb
mariadb-libs-5.5.68-1.el7.x86_64
如果有MariaDB,需要将查询到的mairadb全部卸载
[root@localhost mysql]# rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64
一、下载
下载mysql8版本
此处选择mysql8.0.29版本
二、上传和安装
1.上传至linux服务器
上传至存放目录中(自定义),进行解压:
tar -xvf mysql-8.0.29-1.el7.x86_64.rpm-bundle.tar
解压出来共有12个rpm文件
mysql-community-client-8.0.29-1.el7.x86_64.rpm
mysql-community-client-plugins-8.0.29-1.el7.x86_64.rpm
mysql-community-common-8.0.29-1.el7.x86_64.rpm
mysql-community-debuginfo-8.0.29-1.el7.x86_64.rpm
mysql-community-devel-8.0.29-1.el7.x86_64.rpm
mysql-community-embedded-compat-8.0.29-1.el7.x86_64.rpm
mysql-community-icu-data-files-8.0.29-1.el7.x86_64.rpm
mysql-community-libs-8.0.29-1.el7.x86_64.rpm
mysql-community-libs-compat-8.0.29-1.el7.x86_64.rpm
mysql-community-server-8.0.29-1.el7.x86_64.rpm
mysql-community-server-debug-8.0.29-1.el7.x86_64.rpm
mysql-community-test-8.0.29-1.el7.x86_64.rpm
2.根据实际需要安装相应软件包
本次选择安装6个组件,依次安装顺序如下:
注意:为了避免安装依赖,安装命令后面可以增加–nodeps --force
rpm -ivh mysql-community-common-8.0.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.29-1.el7.x86_64.rpm
rom -ivh mysql-community-icu-data-files-8.0.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.29-1.el7.x86_64.rpm
3.初始化数据库
需要注意:如果要设置对数据库表大小写不敏感,需要在初始化之前设置。
(在my.cnf(默认在etc/my.cnf)中添加lower_case_table_names = 1)。
以下命令依次执行:
mysqld --initialize --console;//初始化数据库
chown mysql:mysql /var/lib/mysql -R; //将mysql的安装目录所有者,更改为mysql
systemctl start mysqld.service; //启动mysql服务
systemctl enable mysqld; //设置开机自行启动
4.连接数据库
- 查看初始密码:
[root@localhost mysql]# cat /var/log/mysqld.log | grep password
2022-05-15T08:31:13.659529Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: wsyX-2m;UgxA
[root@localhost mysql]#
- 输入初始密码进行连接
- 修改用户密码
必须先更改初始密码,否则进一步操作时,会提示必须先修改密码。
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '****';
5.设置mysql开机自启
1.查看MySQL服务的自启动状态
systemctl list-unit-files | grep ‘mysql’
2. 关闭MySQL开机自启动服务
systemctl disable mysqld
3. 开启MySQL开机自启动服务
systemctl enable mysqld