Linux上安装MySQL 8.0

tar -xvf mysql-8.0.13-linux-glibc2.12-x86_64.tar

mv mysql-8.0.13-linux-glibc2.12-x86_64/* /usr/local/mysql/

cd /usr/local/mysql
groupadd mysql
useradd -r -g mysql mysql
mkdir data
mkdir logs
chown -R mysql:mysql /usr/local/mysql
bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

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

chown -R mysql:mysql /usr/local/mysql

启动：service mysql.server start
停止：service mysql.server stop
状态：service mysql.server status
重启：service mysql.server restart
刷新：service mysql.server reload

ln -s /usr/local/mysql/bin/mysql /usr/bin
#未设置密码时，通过/etc/my.cnf文件增加skip-grant-tables，可跳过密码登录，修改后重启，设置密码后记得去掉
service mysql.server restart

mysql -u root -p 
use mysql
update user set host = '%' where user = 'root'; #开启远程连接
ALTER USER 'root' IDENTIFIED BY '123456'; #或者'root'@'%'
FLUSH PRIVILEGES;

yum install  libaio-devel.x86_64