linux安装MySQL8.0

下载地址：
https://dev.mysql.com/downloads/mysql/
选择

1.解压mysql-8.0.12-linux-glibc2.12-x86_64.tar.xz

xz -d mysql-8.0.12-linux-glibc2.12-x86_64.tar.xz 

生成mysql-8.0.12-linux-glibc2.12-x86_64.tar

tar -xvf mysql-8.0.12-linux-glibc2.12-x86_64.tar

2.重命名解压后生成的mysql-8.0.12-linux-glibc2.12-x86_64

mv mysql-8.0.12-linux-glibc2.12-x86_64 mysql8.0.12

3.创建mysql的data目录

mkdir /home/mysql/data 

4.初始化数据库

cd /home/mysql/software/mysql8.0.12/bin
	./mysqld --user=mysql --basedir=/home/mysql/software/mysql8.0.12 --datadir=/home/mysql/data  --initialize

初始化后会生成临时的一个数据库密码，记录下来 root@localhost: TfM%zKi&p46
2020-05-14T03:47:30.602779Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: TfM%zKi&p46
5.在/etc/创建my.cnf 配置文件

touch my.cnf

内容为：[mysqld]下的basedir和datadir修改为自己的对应的目录
basedir为数据库安装路径，datadir为数据库数据路径，log-error和pid-file为日志和pid路径

[mysql]
default-character-set=utf8
socket=/var/lib/mysql/mysql.sock
 
[mysqld]
skip-name-resolve
port=3306
socket=/var/lib/mysql/mysql.sock
 
basedir=/home/mysql/app/mysql8.0.20
datadir=/home/mysql/data
 
max_connections=200
character-set-server=utf8
default-storage-engine=INNODB
max_allowed_packet=16M
 
[mysqld_safe]
log-error=/home/mysql/log/mysql.log
pid-file