centOS下安装MySQL8_CentOS下安装Mysql 8.0步骤详解

叁歲伎倆 2022-10-24 13:17 178阅读 0赞

本次安装Mysql的CentOS版本是7.7

![9cf26808d64ed15748b68f22aa5f36dc.png][]

1.下载Mysql

首先去Mysql官网下载安装包，网址https://dev.mysql.com/downloads/mysql/

推荐大家下载Linux通用版本的，便于管理安装位置，也方便一台服务器安装多个版本的mysql，下载后将Mysql安装包上传至服务器/usr/local/目录下

![1ee9ea08c0e0838e95b63b7009bdaeda.png][]

2.创建Mysql用户和组

groupadd mysql \#创建mysql组

useradd -r -d /home/mysql -g mysql mysql \#创建mysql用户 并指定组和默认路径

chown -R mysql:mysql /home/mysql \#将Mysql默认路径的用户和组改成mysql

![b9eb94f267ccfcc0615c0584715d558c.png][]

3.解压Mysql

tar -xvf mysql-8.0.11-linux-glibc2.12-x86\_64.tar.gz \#解压安装包

ln -s mysql-8.0.11-linux-glibc2.12-x86\_64 mysql \#文件夹添加软链接为mysql

chown -R mysql:mysql /usr/local/mysql

![258087b7a9d1a87e6d870c1600c1d519.png][]

4.为Mysql安装配置环境

使用root用户编辑/etc/profile，将下面的内容添加到最下面,并执行source /etc/profile使配置生效

export PATH=$PATH:/usr/local/mysql/bin

![02c85aead0bbc61af148234100f53124.png][]

关闭防火墙，防火墙状态为inactive时表示关闭成功

service firewalld stop

![d47bfe9add9d51a2bda6c364d3241a9d.png][]

关闭SELinux，编辑/etc/selinux/config，将selinux=enforce改为disable即可

![3d142e5069b509ac53c524a5d3c6ed75.png][]

5.创建Mysql数据目录

mkdir /usr/local/mysql/data \#创建数据目录

chown mysql:mysql /usr/local/mysql/data \#将数据目录的用户和组改成mysql

chmod 750 /usr/local/mysql/data \#更改数据目录权限

![f1a3f51106d009fb42c122644d904337.png][]

6.配置my.cnf文件

新建my.cnf配置文件，并添加以下内容

\[mysqld\]

port=3306

basedir=/usr/local/mysql

datadir=/usr/local/mysql/data

log-error=/usr/local/mysql/data/error.log

socket=/tmp/mysql.sock

pid-file=/usr/local/mysql/data/mysql.pid

character-set-server = utf8

lower\_case\_table\_names=1

innodb\_log\_file\_size=1G

default-storage-engine=INNODB

default\_authentication\_plugin=mysql\_native\_password

\[client\]

port=3306

default-character-set=utf8

![95b2840c538274e0aa5cdc9efd9e0f47.png][]

7.初始化Mysql

执行下面的命令初始化mysql，结束后查看/data/error.log，显示(mysqld 8.0.11) initializing of server has completed就代表Mysql初始化成功了

bin/mysqld --initialize --user mysql

![619f94a63b2c43bb04bea067f5a9d6ec.png][]

8.启动Mysql

执行support-files/mysql.server start启动mysql，启动成功后可查看到mysql的进程

![b847ac76924119d82c4372fcab011038.png][]

9.登录Mysql

通过查看/data/error.log获取Mysql的初始化密码，并登录mysql

mysql -u root -p

![f3f825f31c14dde5e2599551053aaf3e.png][]

![cd78cf1ca3f03a83285172f9e38091e1.png][]

10.修改root用户密码

通过下面的语句可以修改root用户的密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root\_123';

为远程登录创建用户,并赋权

CREATE USER 'root'@'%' IDENTIFIED BY 'root\_123';

GRANT ALL ON \*.\* TO 'root'@'%';

FLUSH PRIVILEGES;

这样就可以通过navicat等工具进行远程连接了

![a2fc4a90578bac432d86fc71d4e580b2.png][]

11.配置mysql开机自启

首先将mysql.server 复制到/etc/init.d下面

cp support-files/mysql.server /etc/init.d/mysqld

通过chkconfig将mysql服务添加到开机启动的列表里面就可以了

chkconfig --add mysqld

![81a0b20042ed278f491e96f27b1eaec0.png][]

以上就是CentOS 7.7下安装Mysql 8.0的全部过程了，欢迎大家参考和提问

[9cf26808d64ed15748b68f22aa5f36dc.png]: /images/20221024/720c53b1adc2449585d26cd163590ab8.png
[1ee9ea08c0e0838e95b63b7009bdaeda.png]: /images/20221024/f1bd8bf859a944c097cb03f021adf024.png
[b9eb94f267ccfcc0615c0584715d558c.png]: /images/20221024/fce6383e81b14791a64859fe99aafbac.png
[258087b7a9d1a87e6d870c1600c1d519.png]: /images/20221024/57f9904c159e4d9c93533181c0ac67be.png
[02c85aead0bbc61af148234100f53124.png]: /images/20221024/0aa264036ea04f0ea2da015b2c477044.png
[d47bfe9add9d51a2bda6c364d3241a9d.png]: /images/20221024/716692c4fe344d1d96396fe03c178174.png
[3d142e5069b509ac53c524a5d3c6ed75.png]: /images/20221024/9135b01b22344ed3b01d882a7b4e3c88.png
[f1a3f51106d009fb42c122644d904337.png]: /images/20221024/07e38c3842f94fd58bf0f04d86a6b200.png
[95b2840c538274e0aa5cdc9efd9e0f47.png]: /images/20221024/5cd254934dba42aba7af6399d4ef6b06.png
[619f94a63b2c43bb04bea067f5a9d6ec.png]: /images/20221024/8f93d5a055b44bb8b02e2e10e4b0af40.png
[b847ac76924119d82c4372fcab011038.png]: /images/20221024/c4632586dcd34718bd360495409acb5c.png
[f3f825f31c14dde5e2599551053aaf3e.png]: /images/20221024/f27e521eab92453a9cfbb107ab6c718b.png
[cd78cf1ca3f03a83285172f9e38091e1.png]: /images/20221024/1446e7421a104eb1911ba51af3fdf1f0.png
[a2fc4a90578bac432d86fc71d4e580b2.png]: /images/20221024/e1394c386831428c94597597c8c6b1f8.png
[81a0b20042ed278f491e96f27b1eaec0.png]: /images/20221024/3f0d95ba8c2349e69d58df24e5198915.png