MySQL8安装

确认系统glibc版本

MySQL下载地址

MySQL下载

上传到服务器后tar xf解压，mv到/usr/local/

配置mysql操作权限

groupadd mysql
useradd -g mysql mysql
chown -R mysql mysql /usr/local/mysql

编辑配置文件

[mysql]
default-character-set=utf8mb4
[client]
port       = 3306
default-character-set=utf8mb4
[mysqld]
port       = 3306
user       = mysql
basedir=/usr/local/mysql
datadir=/data/mysqldata
socket=/tmp/mysql.sock
log-error=/usr/local/mysql/mysql.log
pid-file=/usr/local/mysql/mysql.pid
lower_case_table_names=1
autocommit =1
[client]
port       = 3306
socket     =/tmp/mysql.sock

default-character-set:默认字符串，lower_case_table_names：对大小写不敏感

初始化数据库

cd /usr/local/mysql
./bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysqldata --initialize

配置log文件后日志会输出到mysql.log，临时密码就在文件里

数据库启动

./support-files/mysql.server start

start status stop restart

初始化完仓库后，需要重设root密码

#ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'H_zhan#888';
alter user 'root'@'localhost' identified by 'H_zhan#888';
flush privileges;
#root远程登录
use mysql;
update user set user.Host='%'where user.User='root';
flush privileges;