基础环境centos7.5，mysql版本8.0.20，通过tar包安装，安装路径/usr/local

参考https://www.cnblogs.com/kc19941205/p/14721580.html

 

 

首先将mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz安装包上传到一个临时目录然后解压，注意压缩包是.tar.xz格式的，需要先解压、再解包

[root@CentOS7-1 tools]# xz -d mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz 
[root@CentOS7-1 tools]# tar xf mysql-8.0.20-linux-glibc2.12-x86_64.tar -C /usr/local/

 

创建mysql用户

[root@CentOS7-1 tools]# useradd mysql
[root@CentOS7-1 tools]# passwd mysql
……密码相关提示操作……

 

重命名解压后的安装包目录，并修改目录的属主属组，

[root@CentOS7-1 tools]# cd /usr/local/
[root@CentOS7-1 local]# mv mysql-8.0.20-linux-glibc2.12-x86_64/ mysql
[root@CentOS7-1 local]# chown -R mysql.mysql mysql/

 

切换到mysql用户，在安装包下创建数据文件路径data

[mysql@CentOS7-1 local]$ cd mysql
[mysql@CentOS7-1 mysql]$ mkdir data

 

到bin目录下初始化数据库

[mysql@CentOS7-1 mysql]$ cd bin 
[mysql@CentOS7-1 bin]$ ./mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --initialize
2021-12-07T16:29:25.936536Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 1024 (requested 8161)
2021-12-07T16:29:25.936549Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 431 (requested 4000)
2021-12-07T16:29:25.937104Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-12-07T16:29:25.937260Z 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.20) initializing of server in progress as process 111611
2021-12-07T16:29:25.954467Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T16:29:27.128120Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T16:29:28.520117Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: I<-VCdcL2kZb

 

切换到root用户，编辑配置文件/etc/my.cnf