Linux安装MySQL

将mysql-8.0.29-linux-glibc2.12-x86_64.tar.xz安装包上传至服务器/usr/local/目录

tar -xzvf mysql-8.0.29-linux-glibc2.12-x86_64.tar.xz

mv mysql-8.0.29-linux-glibc2.12-x86_64.tar.xz mysql

cd mysql

mkdir data

cd /usr/local/mysql/bin

./mysqld --user=root --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data/ --initialize

cd /usr/local/mysql

cp -a ./support-files/mysql.server /etc/init.d/mysql

chmod +x /etc/init.d/mysql

chkconfig --add mysql

ln -s /usr/local/mysql/bin/mysql /usr/bin

启动MySQL：

service mysql start

service mysql status

mysql mysql -uroot -p 输入上面的临时密码

修改root密码
执行命令 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
执行 flush privileges; 使密码生效

修改远程连接
update user set host=‘%’ where user=‘root’;
flush privileges;
exit;

firewall-cmd --add-port=3306/tcp --permanent
firewall-cmd --reload

引用文件：
https://www.cnblogs.com/kire-cat/p/16361559.html
https://www.javazxz.com/thread-11184-1-1.html