下載MySql 8.0
下載 Mysql yum包
wget -i -c https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm
使用上面的命令就直接下載了安裝用的Yum Repository,大概25KB的樣子,然后就可以直接yum安裝了。
yum -y install mysql80-community-release-el7-3.noarch.rpm
安裝MySql服務(wù)
yum -y install mysql-community-server
設(shè)置MySql數(shù)據(jù)庫
啟動mysql
systemctl start mysqld.service
查看運(yùn)行狀態(tài)
systemctl status mysqld.service
獲取MySQL的臨時密碼
grep 'temporary password' /var/log/mysqld.log
登陸并修改密碼
mysql -uroot -p
修改密碼
ALTER USER 'root'@'localhost' IDENTIFIED BY '復(fù)雜密碼';
新密碼設(shè)置的時候如果設(shè)置的過于簡單會報錯:
授權(quán)遠(yuǎn)程登陸
創(chuàng)建遠(yuǎn)程登陸用戶
create user 'qf' @'%' identified by 'Qf@rq1225.com';
賦予權(quán)限
grant all privileges on *.* to 'qf' @'%';
卸載yum
yum -y remove mysql57-community-release-el7-10.noarch