下载地址:
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