系統(tǒng)環(huán)境：centos7.5，mysql版本：8.0.13，安裝方式：解壓安裝。
1.下載mysql8.0.13解壓包。點(diǎn)擊download獲取下載地址后在centos7用wget下載。
mysql官網(wǎng)下載界面
[root@litie143 ~]# wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.13-el7-x86_64.tar.gz
--2018-11-16 10:03:24-- https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.13-el7-x86_64.tar.gz
Resolving cdn.mysql.com (cdn.mysql.com)... 23.217.125.65
Connecting to cdn.mysql.com (cdn.mysql.com)|23.217.125.65|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 657877489 (627M) [application/x-tar-gz]
Saving to: `mysql-8.0.13-el7-x86_64.tar.gz`
92% [==============================================================================================================> ] 608,267,232 31.2KB/s eta 3m 8s
2.解壓下載的mysql包。
[root@litie143 ~]# ll
-rw-r--r--. 1 root root 657877489 Oct 7 16:18 mysql-8.0.13-el7-x86_64.tar.gz
[root@litie143 ~]# tar xvf mysql-8.0.13-el7-x86_64.tar.gz
[root@litie143 ~]# ll
drwxr-xr-x. 9 root root 172 Nov 16 11:04 mysql-8.0.13-el7-x86_64
-rw-r--r--. 1 root root 657877489 Oct 7 16:18 mysql-8.0.13-el7-x86_64.tar.gz
[root@litie143 ~]#
3.創(chuàng)建MySQL用戶組及用戶
[root@litie143 ~]# groupadd mysql
[root@litie143 ~]# useradd -r -g mysql -s /bin/false mysql
4.把解壓的mysql文件夾拷貝到/usr/local/mysql8。
/usr/local路徑通常存放自己安裝的程序，mysql文件夾名稱可以自己指定，我在這里使用mysql8。
[root@litie143 ~]# mv mysql-8.0.13-el7-x86_64 /usr/local/mysql8
[root@litie143 ~]# ll /usr/local/mysql8
total 448
drwxr-xr-x. 2 root root 4096 Nov 16 11:04 bin
drwxr-xr-x. 2 root root 86 Nov 16 11:04 docs
drwxr-xr-x. 3 root root 266 Nov 16 11:04 include
drwxr-xr-x. 6 root root 4096 Nov 16 11:04 lib
-rw-r--r--. 1 7161 31415 335809 Oct 7 16:44 LICENSE
-rw-r--r--. 1 7161 31415 101807 Oct 7 16:44 LICENSE.router
drwxr-xr-x. 4 root root 30 Nov 16 11:04 man
-rw-r--r--. 1 7161 31415 687 Oct 7 16:44 README
-rw-r--r--. 1 7161 31415 700 Oct 7 16:44 README.router
drwxr-xr-x. 28 root root 4096 Nov 16 11:04 share
drwxr-xr-x. 2 root root 90 Nov 16 11:04 support-files
[root@litie143 ~]#
5.在mysql8文件夾下創(chuàng)建mysql-files目錄,權(quán)限設(shè)置為750，并將整個mysql8目錄授權(quán)給mysql用戶組
[root@litie143 ~]# cd /usr/local/mysql8
[root@litie143 mysql8]# mkdir mysql-files
[root@litie143 mysql8]# cd ..
[root@litie143 local]# chown -R mysql:mysql mysql8
[root@litie143 local]# cd mysql8
[root@litie143 mysql8]# chmod 750 mysql-files
6.在/etc目錄下創(chuàng)建并編輯my.cnf 文件。并授權(quán)給mysql用戶組
[root@litie143 mysql8]# touch /etc/my.cnf
[root@litie143 mysql8]# chown mysql:mysql /etc/my.cnf
#我的 my.cnf 大致內(nèi)容如下
#
# FromDual configuration file template for MySQL, Galera Cluster, MariaDB and Percona Server
# Location: /etc/my.cnf or /etc/mysql/my.cnf
# Get most recent updated from here:
# http://www.fromdual.com/mysql-configuration-file-sample
#
[client]
port=3306
[mysqld_safe]
log-error=/var/log/mysql/mysql.log # 需要手動創(chuàng)建并給mysql用戶組授權(quán)
[mysqld]
basedir=/usr/local/mysql8
datadir=/usr/local/mysql8/data
tmpdir=/tmp
socket=/tmp/mysql.sock # 需要手動創(chuàng)建并給mysql用戶組授權(quán)
pid-file=/var/lib/mysql/mysql.pid # 需要手動創(chuàng)建并給mysql用戶組授權(quán)
- 初始化數(shù)據(jù)庫
[root@litie143 mysql8]# bin/mysqld --user=mysql --initialize
2018-11-16T07:17:29.381576Z 0 [System] [MY-013169] [Server] /usr/local/mysql8/bin/mysqld (mysqld 8.0.13) initializing of server in progress as process 1235
2018-11-16T07:17:31.735711Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: qs/c9Y%!Y!lb
2018-11-16T07:17:32.991008Z 0 [System] [MY-013170] [Server] /usr/local/mysql8/bin/mysqld (mysqld 8.0.13) initializing of server has completed
記住log中的密碼，比如我的是root@localhost: qs/c9Y%!Y!lb，
密碼就是：qs/c9Y%!Y!lb
如果不顯示這個log，到log文件中查找。
8.創(chuàng)建軟連接并設(shè)置開機(jī)啟動
[root@litie143 mysql8]#ln -s /usr/local/mysql8/bin/mysql /usr/bin/mysql
[root@litie143 mysql8]#cp /usr/local/mysql8/support-files/mysql.server /etc/init.d/mysqld
[root@litie143 mysql8]#/sbin/chkconfig mysqld on
9.啟動數(shù)據(jù)庫，登陸并修改密碼。密碼是log中提到那個。
[root@litie143 mysql8]#systemctl start mysql.service
#登陸
[root@litie143 ~]# mysql -u root -p
Enter password:
#修改密碼
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
#修改密碼也可以用mysql_native_password
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
#添加遠(yuǎn)程訪問用戶，用戶名root，也可以自己命名。%表示所有ip可以訪問
mysql> CREATE USER 'root'@'%' IDENTIFIED BY '123456';
#給'root'@'%' 用戶所有mysql權(quán)限
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
#刷新權(quán)限
mysql> FLUSH PRIVILEGES;
- 防火墻開啟3306端口,并重啟防火墻
[root@litie143 ~]# firewall-cmd --zone=public --add-port=3306/tcp --permanent
[root@litie143 ~]# firewall-cmd --reload
