install mysql:

mysql Official address ：https://dev.mysql.com/downloads/mysql/

Installation steps ：

1. Get into /usr/local/ Catalog , And create... In this directory mysql Catalog

cd /usr/local

2. download Mirror image

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

3. decompression ：

tar -zxvf mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz

If it is .xz Format can be used tar -Jxvf mysql-8.0.19-linux-glibc2.12-x86_64.tar.xz)

4. Rename

mv ./mysql-8.0.11-linux-glibc2.12-x86_64.tar mysql8

#  This directory structure 
cd /usr/local/mysql/mysql8
#  establish data Catalog 
mkdir ./data

5. Create user group , And authorize the operation

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

6. stay /usr/local/mysql/mysql8 Under the table of contents , Get a temporary password

./bin/mysqld --user=mysql --basedir=/usr/local/mysql/mysql8/ --datadir=/usr/local/mysql/mysql8/data/ --initialize ;

If you make a mistake , Do the following , Install dependent plug-ins

yum install libaio*    

7. modify Mysql To configure :

vim /etc/my.cnf

#  Edit content 
basedir=/usr/local/mysql/mysql8
socket=/tmp/mysql.sock
datadir=/usr/local/mysql/mysql8/data
character-set-server=utf8

8. add to Mysql To system services

#  Conduct mysql8 Under the table of contents 
cd /usr/local/mysql/mysql8
#  perform ：
cp -a ./support-files/mysql.server /etc/init.d/mysql

cd /etc/init.d/
chmod +x /etc/init.d/mysql
chkconfig --add mysql
chkconfig --list mysql

9. Configure environment variables ：

vim /etc/profile

#  Edit content 
MYSQL_HOME=/usr/local/mysql/mysql8
PATH=$PATH:$MYSQL_HOME/bin
export PATH MYSQL_HOME

#  After saving the file , Perform refresh operation 
source /etc/profile

10. start-up Mysql service :

#  start-up 
service mysql start;
#  Check the status 
service mysql status;
#  To configure 
ln -s /usr/local/mysql/mysql8/bin/mysql /usr/bin

11. Log in ：

mysql -uroot -p  Input password 

12. Change the temporary password ：

#  stay MySQL perform 
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY ' New password ';

Configure remote connection ：

1. Turn off firewall ：

#  Check the status ：
systemctl status firewalld
#  Turn on ： 
systemctl start firewalld
#  close ： 
systemctl stop firewalld

2. Set up mysql Set up a remote connection ：

#  stay MySQL Execute... Under the window 
use mysql;

select host, user, authentication_string, plugin from user;

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

FLUSH PRIVILEGES;