cd /usr/local/mysql8/bin
./mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql8 --datadir=/data/mysql8_data/mysql --user=mysql --initialize
10、启动mysql(结尾加"&"为后台启动)
./mysqld_safe --defaults-file=/etc/my.cnf &
11、查看启动log中生成mysql密码
cat /data/mysql8_data/mysql/mysql.log
2022-03-22T11:05:18.173249Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: %lgAeFSY&9NC
12、修改新密码
#首次改密推荐使用本地密码插件with mysql_native_password
ALTER USER 'root'@'localhost' IDENTIFIED with mysql_native_password BY '12345678';
#刷新权限
flush privileges;
13、创建远程访问授权
use mysql;
select user,host,plugin,authentication_string from user;
CREATE user 'root'@'%'; #创建用户任意远程访问
alter user 'root'@'%' identified with mysql_native_password by '12345678'; #修改密码
grant all privileges on *.* to "root"@"%"; #给用户授权
flush privileges; #刷新权限