linux安装mysql8.0.16_mysql安装配置教程

 wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.21-linux-glibc2.12-x86_64.tar.xz

tar xvJf mysql-8.0.21-linux-glibc2.12-x86_64.tar.xz

mv mysql-8.0.21-linux-glibc2.12-x86_64 mysql-8.0

mkdir data 

groupadd mysql

useradd -g mysql mysql

chown -R mysql.mysql /usr/local/mysql-8.0

cd bin

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

vi /etc/my.cnf

basedir=/usr/local/mysql-8.0/
datadir=/usr/local/mysql-8.0/data/
socket=/tmp/mysql.sock
character-set-server=UTF8MB4

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

chmod +x /etc/init.d/mysql

chkconfig --add mysql

service mysql start

service mysql status

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

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';

flush privileges;

use mysql;

update user set host='%' where user='root';

flush privileges;