安装

groupadd mysql
useradd -r -g mysql -d /usr/local/mysql -s /bin/false mysql

wget https://mirrors.cloud.tencent.com/mysql/downloads/MySQL-8.0/mysql-boost-8.0.21.tar.gz
tar zxvf mysql-8.0.21.tar.gz -C /usr/local

ln -s /usr/local/mysql-8.0.21 /usr/local/mysql
mkdir -p /usr/local/mysql/data
chown -R mysql:mysql /usr/local/mysql
chmod 750 /usr/local/mysql/data

/usr/local/mysql/bin/mysqld --defaults-file=/usr/local/mysql/my.cnf --initialize
/usr/local/mysql/bin/mysql_ssl_rsa_setup

启动

# mysqld_safe
/usr/local/mysql/bin/mysqld_safe --defaults-file=/usr/local/mysql/my.cnf &

# 自动启动
chmod +x /etc/rc.local
/bin/sh -c 'cd /usr/local/mysql; ./bin/mysqld_safe --defaults-file=./my.cnf &'

# 
su mysql -c '/usr/local/mysql/bin/mysqld_safe --defaults-file=/usr/local/mysql/my.cnf &'

# Next command is optional
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql.server

配置

# --initialize
grep -o 'password .*' /var/log/mysqld.log |awk '{print $6}'
mysql -uroot -p

# --initialize-insecure
mysql -u root --skip-password

# 修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

# MySQL-5.7 添加用户
#update mysql.user set host='%' where user='root';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'MyNewPass4!' WITH GRANT OPTION;
flush privileges;

# MySQL-8.0 添加用户
CREATE USER 'root'@'%' IDENTIFIED BY 'MyNewPass4!';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;