systemctl stop mysqld
//系統(tǒng)不同mysql服務(wù)名稱可能存在差別，若無法關(guān)閉可嘗試
systemctl stop mysql.service

rpm -qa | grep mysql

//普通刪除模式
rpm -e xxx(mysql_libs)
//強(qiáng)力刪除模式,如果上述命令刪除時(shí)，提示有依賴其他文件，則可以用該命令對(duì)其進(jìn)行強(qiáng)力刪除
rpm -e --nodeps xxx(mysql_libs)

//檢查如果存在mariadb
[root@localhost ~]# rpm -qa | grep mariadb
mariadb-libs-5.5.68-1.el7.x86_64
//進(jìn)行刪除
rpm -e --nodeps mariadb-libs

rm /var/lib/mysql
rm /etc/my.cnf

tar -xvf  mysql-8.0.13-linux-glibc2.12-x86_64.tar
//解壓后還是壓縮包，再次解壓
tar -xvf mysql-8.0.13-linux-glibc2.12-x86_64.tar.xz
//將解壓后的文件修改為mysql8.0
mv mysql-8.0.13-linux-glibc2.12-x86_64 mysql8.0

cd mysql8.0
mkdir data

groupadd mysql
useradd -g mysql mysql

chown -R mysql.mysql /usr/local/mysql8.0

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

vim /etc/my.cnf

[mysqld]
basedir=/usr/local/mysql8.0
datadir=/usr/local/mysql8.0/data
pid-file=/usr/local/mysql8.0/data/mysqld.pid
log-error=/usr/local/mysql8.0/data/mysql.err
socket=/tmp/mysql.sock
symbolic-links=0

//進(jìn)入mysql8.0目錄
cd ..
//添加服務(wù)
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/mysql8.0/bin/mysql /usr/bin

mysql -u root -p
//輸入初始化生成的初始密碼 

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

flush privileges;

mysql -u root -p
Enter password:輸入你的密碼
//修改mysql表
use mysql;
//修改允許遠(yuǎn)程連接
update user set host='%' where user='root';
 //刷新權(quán)限
flush privileges;

//mysql停止
systemctl stop mysql.service 或 systemctl stop mysqld
//mysql重啟
systemctl restart mysql.service 或 systemctl restart mysqld

wget https://dev.mysql.com/get/mysql-apt-config_0.8.15-1_all.deb

sudo dpkg -i mysql-apt-config_0.8.15-1_all.deb
在出現(xiàn)的界面中選擇MySQL 8.0，然后點(diǎn)擊OK。

sudo apt-get update

sudo apt-get install mysql-server

sudo mysql_secure_installation
跟隨提示設(shè)置root密碼，移除匿名用戶，禁止root遠(yuǎn)程登錄等。

sudo systemctl start mysql.service
確認(rèn)MySQL服務(wù)運(yùn)行狀態(tài)：
sudo systemctl status mysql.service

mysql -u root -p

wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

sudo rpm -Uvh mysql80-community-release-el7-3.noarch.rpm

sudo yum install mysql-community-server

sudo systemctl start mysqld

sudo grep 'temporary password' /var/log/mysqld.log

sudo mysql_secure_installation

sudo systemctl enable mysqld
sudo systemctl start mysqld

vim /etc/my.cnf

skip-grant-tables

service mysqld restart 或 systemctl restart mysql.service 或 system restart mysqld

mysql -u root -p

select host, user, authentication_string, plugin from user;

use mysql;
update user set authentication_string='' where user='root';
//修改完成后退出
exit

vim /etc/my.cnf

skip-grant-tables

service mysqld restart 或 systemctl restart mysql.service 或 system restart mysqld

mysql -u root -p

ALTER user 'root'@'localhost' IDENTIFIED BY 'Pwd1234#';