一、下載mysql8.0安裝包
官網(wǎng)下載地址：https://dev.mysql.com/downloads/mysql/
二艘刚、安裝mysql
1时肿、將已經(jīng)下載好的mysql上傳到 /usr/local/software ，解壓：
[root@localhost software]# tar -xvf mysql-8.0.23-linux-glibc2.12-x86_64.tar.xz
2苛萎、創(chuàng)建mysql系統(tǒng)用戶組和系統(tǒng)用戶
groupadd mysql useradd -r -g mysql mysql
解決方法：
#groupadd mysql
#useradd -r -g mysql mysq
查看用戶組：#groups mysql
3诊县、創(chuàng)建數(shù)據(jù)目錄
在此位置下：/usr/local/software/mysql-8.0.23-linux-glibc2.12-x86_64
mkdir datatmp chmod 777 ./data./tmp
新建修改相關(guān)的配置文件
cd support-files touch? my-default.cnf vim? my-default.cnf? ? #如果命令未成功讲弄，可以在support-files文件夾下直接創(chuàng)建
然后將如下內(nèi)容些人文件：
[mysqld]
basedir = /usr/local/software/mysql-8.0.23-linux-glibc2.12-x86_64
datadir = /usr/local/software/mysql-8.0.23-linux-glibc2.12-x86_64/data
port = 3306
socket = /usr/local/software/mysql-8.0.23-linux-glibc2.12-x86_64/tmp/mysql.sock
lower_case_table_names=1? ? ? ? ? ? ? ? #其中l(wèi)ower_case_table_names=1 表示忽略大小寫敏感
[client]
default-character-set=utf8
socket= /usr/local/software/mysql-8.0.23-linux-glibc2.12-x86_64/tmp/mysql.sock
[mysql]
default-character-set=utf8
socket= /usr/local/software/mysql-8.0.23-linux-glibc2.12-x86_64/tmp/mysql.sock
4、修改當(dāng)前目錄為mysql用戶
chown -R mysql:mysql ./
初始化Mysql配置表： 切換至目錄：/usr/local/software/mysql-8.0.23-linux-glibc2.12-x86_64
bin/mysqld --initialize --user=/usr/local/software/mysql-8.0.23-linux-glibc2.12-x86_64 --datadir=/usr/local/software/mysql-8.0.23-linux-glibc2.12-x86_64/data?
最后面顯示Mysql的密碼：Oj;kRMt5UIlo
2021-03-05T00:52:28.722816Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: Oj;kRMt5UIlo
如果執(zhí)行失敗依痊，需要刪除data 和tmp文件下所有內(nèi)容避除，檢查配置后重新執(zhí)行初始化。
5胸嘁、設(shè)置開機啟動服務(wù)
[root@localhost ~]# cd /usr/local/software/mysql-8.0.23-linux-glibc2.12-x86_64/support-files/? ? #進(jìn)入support-files文件夾
cpmysql.server /etc/init.d/mysql
chmod+x /etc/init.d/mysql
chkconfig--add mysql
chkconfig--list mysql (檢查是否啟動成功)
6瓶摆、手動啟動服務(wù)
vim /etc/profile (配置環(huán)境變量)
export PATH=$PATH:/usr/local/tools/mysql-8.0.21/bin:/usr/local/tools/mysql-8.0.21/lib
service mysql start? (start,stop,restart命令)
source /etc/profile
啟動報錯：mysql: error while loading shared libraries: libtinfo.so.5: cannot open share
[root@localhost ~]# mysql -uroot -p
mysql: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory
解決方法：
sudo ln -s /usr/lib64/libtinfo.so.6.1 /usr/lib64/libtinfo.so.5
7、登錄mysql重置密碼
mysql -uroot -pOj;kRMt5UIlo? ? #密碼是步驟4中生成的
alter user'root'@'localhost'identifiedby'root';? ? ? #重置密碼為root
flush privileges;
8性宏、設(shè)置遠(yuǎn)程連接
注：前提是防火墻關(guān)閉或端口放行
mysql->use mysql;
mysql->update user set host = '%' where user ='root';
mysql->flush privileges;
mysql->select 'host' from user where user='root';
9群井、
