文件放置至 /home 路径

1、解压到/usr/local/目录下

[root@centos7.5  /]# cd home

[root@centos7.5  home]# ls

mysql-8.0.15-linux-glibc2.12-x86_64.tar.xz

[root@centos7.5  home]#  tar xf mysql-8.0.15-linux-glibc2.12-x86_64.tar.xz -C /usr/local/

2、目录/usr/lcoal/下创建链接

[root@centos7.5  /]# cd usr/local/

[root@centos7.5  local]#  ln -sn mysql-8.0.15-linux-glibc2.12-x86_64 mysql

3、创建mysql用户和所属组

[root@centos7.5  ~]# groupadd mysql

[root@centos7.5  ~]# useradd -r -g mysql mysql

4、设置/usr/local/mysql目录下所有文件为root主，mysql组

[root@centos7.5  /]# cd usr/local/mysql/

[root@centos7.5  mysql]# chown -R root.mysql ./*

5、创建目录存放mysql数据

[root@centos7.5  mysql]# mkdir -pv /data/mysql

6、修改/data/mysql/目录的属主属组为mysql

[root@centos7.5  mysql]# chown -R mysql.mysql /data/mysql/

7、编辑环境变量

[root@centos7.5  mysql]# vim /etc/profile.d/mysql.sh

i 进入编辑模式

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

esc按键 :wq 保存并退出

8、重新加载mysql.sh文件

[root@centos7.5  mysql]# . /etc/profile.d/mysql.sh

9、初始化mysql 

[root@centos7.5  mysql]# ./bin/mysqld --initialize --user=mysql --datadir=/data/mysql --basedir=/usr/local/mysql

***记下生成的密码 ，若不生成密码，设置空密码：--initialize后加-insecure

10、创建etc目录，将/etc/my.cnf复制到/usr/local/mysql/etc目录下

[root@centos7.5  mysql]# mkdir etc

[root@centos7.5  mysql]# cp /etc/my.cnf etc/

11、编辑/usr/local/mysql/etc.cnf

[root@centos7.5  mysql]# cd etc/

[root@centos7.5  etc]# vim my.cnf 

[mysqld]

datadir=/data/mysql

socket=/tmp/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

# Settings user and group are ignored when systemd is used.

# If you need to run mysqld under a different user or group,

# customize your systemd unit file for mariadb according to the

# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld_safe]

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

pid-file=/var/run/mysql/mysql.pid

#

# include all files from the config directory

#

!includedir /usr/local/mysql/etc/my.cnf.d

esc按键 :wq 保存并退出

12、根据my.cnf文件路径配置，创建mysql目录下对应的目录和文件

[root@centos7.5  etc]# mkdir my.cnf.d

13、创建logs目录

[root@centos7.5  mysql]# mkdir logs

14、设置目录所属主，所属组

[root@centos7.5  mysql]# chown -R root.mysql logs

15、创建错误日志文件

[root@centos7.5  logs]# touch error.log

16、设置错误日志所属主和所属组

[root@centos7.5  logs]# chown -R mysql.mysql error.log

17、将目录/usr/local/mysql/support-files/mysql.server复制到目录/etc/init.d/mysqld

[root@centos7.5  support-files]#  cp mysql.server /etc/init.d/mysqld

18、启动脚本

[root@centos7.5  etc]# service mysqld start

Starting MySQL.

19、登录（/usr/local或/data目录下）设置密码

[root@centos7.5  local]# mysql -uroot -p

Enter password: 

Welcome to the MySQL monitor.  Commands end with ; or g.

Your MySQL connection id is 23

Server version: 8.0.15 MySQL Community Server - GPL

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

mysql> set password='123456

Query OK, 0 rows affected (0.01 sec)

mysql> quit;

--------------------OK！ヾ(o◕∀◕)ﾉヾ 已安装成功！--------------------

如果使用navicat连接数据库出现异常

[ERROR 1130: Host 'xxx.xxx.xxx.xxx' is not allowed to connect to thisMySQL server ]

更新user表权限可能会帮到你哦~

mysql> select host,user,plugin from user where user = 'root';

+-----------+------+-----------------------+

| host      | user | plugin                |

+-----------+------+-----------------------+

| localhost | root | caching_sha2_password |

+-----------+------+-----------------------+

1 row in set (0.00 sec)

mysql> update user set host = '%' where user = 'root';

Query OK, 1 row affected (0.01 sec)

Rows matched: 1  Changed: 1  Warnings: 0

mysql>  flush privileges;

mysql> select host,user,plugin from user where user = 'root';

+------+------+-----------------------+

| host | user | plugin                |

+------+------+-----------------------+

| %    | root | caching_sha2_password |

+------+------+-----------------------+

1 row in set (0.00 sec)

--------------------OK！ヾ(o◕∀◕)ﾉヾ 已配置成功！--------------------

---------------------

作者：冰城岩帝

来源：CSDN

原文：https://blog.csdn.net/qq_34151719/article/details/89675188

版权声明：本文为博主原创文章，转载请附上博文链接！