下载mysql8

wget http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-8.0/mysql-8.0.18-linux-glibc2.12-x86_64.tar

配置

/etc/my.cnf

[mysqld]
# Only allow connections from localhost
bind-address = 127.0.0.1
collation-server = utf8mb4_unicode_ci
init-connect = 'SET NAMES utf8'

basedir = /opt/app/mysql
datadir = /opt/app/mysql/data
port = 3306
character_set_server=utf8mb4

# 免密码登录
#skip-grant-tables

# 默认是 caching_sha2_password
default_authentication_plugin=mysql_native_password

# 时间戳问题, 不然会报错
explicit_defaults_for_timestamp=true
log_timestamps = SYSTEM

# 导入导出数据指定文件夹, 不然会报错
secure-file-priv = /opt/app/mysql/log

default-time-zone = '+8:00'
#skip-name-resolve


# 日志
log-output=FILE
## hostname.log
log-error=/opt/app/mysql/log/error.log
slow-query-log-file=/opt/app/mysql/log/slow-query-log-file.log
general-log-file=/opt/app/mysql/log/mysqld.log



[mysql]
default-character-set=utf8
protocol=tcp
user=root

注意，目录要先创建完成，如： data，log，log/error.log

目录配置到环境变量PATH中

初始化data

mysqld  --initialize-insecure

启动命令

将support-files下的mysql.server放如PATH中

sudo ln -s /opt/app/mysql/support-files/mysql.server /usr/local/bin/mysqld

使用mysqld start启动数据库

注意点

1. 配置文件中将skip-name-resolve注释掉，否则本地连接不上。

2. 密码配置为default_authentication_plugin=mysql_native_password，默认的caching_sha2_password大多软件无法连接

手动创建用户

创建用户