centos7服务器安装 mysql

灰太狼 2024-02-05 18:21 10阅读 0赞

## centos7服务器安装 mysql ##

### 一、下载 ###

官网：https://dev.mysql.com/downloads/mysql/

![在这里插入图片描述][11cf951c3ad74f7e83946e3bb6474766.png_pic_center]

### 二、安装 ###

#### 1.查看有没有需要卸载的SQL包，一般系统的mariadb是自带的，需要卸载 ####

rpm -qa | grep mysql
    rpm -qa | grep mariadb

例如：安装过MySQL  
![在这里插入图片描述][d994a8eb34b64e7da410dc2662073458.png_pic_center]

使用如下命令卸载

rpm -e mysql-community-libs-8.1.0-1.el8.x86_64 --nodeps

#### 2.解压与rpm安装 ####

解压

tar xvf mysql-8.1.0-1.el7.x86_64.rpm-bundle.tar

安装

rpm -ivh mysql-community-common-8.1.0-1.el7.x86_64.rpm 
    rpm -ivh mysql-community-client-plugins-8.1.0-1.el7.x86_64.rpm 
    rpm -ivh mysql-community-libs-8.1.0-1.el7.x86_64.rpm 
    rpm -ivh mysql-community-client-8.1.0-1.el7.x86_64.rpm 
    rpm -ivh mysql-community-icu-data-files-8.1.0-1.el7.x86_64.rpm
    rpm -ivh mysql-community-server-8.1.0-1.el7.x86_64.rpm --nodeps

显示需要依赖的，直接用–nodeps参数

#### 3、登录配置 ####

启动

systemctl start mysqld
    systemctl enable mysqld

获取密码

cat /var/log/mysqld.log | grep password

![在这里插入图片描述][c940a974343148e5a415e6a276d32b91.png_pic_center]

mysql -u root -p

修改密码

alter user 'root'@'localhost' identified with mysql_native_password by 'Ljh@new2024';

刷新权限

flush privileges;

配置远程登录

use mysql;
    select host, user from user;
    update user set host = '%' where user = 'root';
    select host, user from user;
    flush privileges;

### 三、用Navicat验证 ###

![在这里插入图片描述][f363bdad7c7f405aaf63459d13c97933.png_pic_center]

[11cf951c3ad74f7e83946e3bb6474766.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/8e257db0792d4736aa4cc53b0780faf3.png
[d994a8eb34b64e7da410dc2662073458.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/640fa02238f94e518cbbe899603c8a59.png
[c940a974343148e5a415e6a276d32b91.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/bc4ab653d90d4f60bda53c0ccdbc60fc.png
[f363bdad7c7f405aaf63459d13c97933.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/205c83539c05441b90cadece8fd239fa.png