服務(wù)器買來都快一年了盗尸,其實荒廢了挺久,之前安裝的東西比較亂帽撑,像什么idea授權(quán)服務(wù)器啥的泼各,啥都有。
所以最近給他重置掉了亏拉,所以必須的一些東西得按回去扣蜻,也就是我為啥要再安一次數(shù)據(jù)庫的原因。
因為啥都沒有及塘,所以報了wget: command not found 的錯誤莽使,解決辦法執(zhí)行下面語句
yum -y install wget
參考一下別人的方法
前面不夠看下這個,其實看我的就好了 :)
使用wget 直接下載
wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm
rpm -Uvh mysql57-community-release-el7-8.noarch.rpm
yum -y install mysql-server
安裝完成了 :)
不過還要啟動笙僚,修改鏈接密碼啊 :(
//啟動
service mysqld start
->Redirecting to /bin/systemctl start mysqld.service
//查看是否啟動
service mysqld status
->Redirecting to /bin/systemctl status mysqld.service
//設(shè)置開機(jī)啟動
systemctl enable mysqld
systemctl daemon-reload
//查看臨時密碼
grep 'temporary password' /var/log/mysqld.log
->2019-09-28T15:14:27.838942Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: (v.i0AxslWz/
//登錄再輸入上面密碼
mysql -uroot -p
進(jìn)去了然后->ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
修改密碼安全規(guī)則
【MySQL 8.0】修改密碼策略吮旅,是修改這2個變量
mysql> set global validate_password.policy=0;
mysql> set global validate_password.length=1;
set global validate_password_policy=0;
set global validate_password_length=1;
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
//我經(jīng)歷了權(quán)限設(shè)置失敗,所以我又重裝了
1 刪除Mysql
yum remove mysql mysql-server mysql-libs mysql-server;
find / -name mysql 將找到的相關(guān)東西delete掉(rm -rf /var/lib/mysql);
rpm -qa|grep mysql(查詢出來的東東yum remove掉)
rm /etc/my.cnf
查看是否還有mysql軟件:
rpm -qa|grep mysql
如果存在的話庇勃,繼續(xù)刪除即可檬嘀。
rpm方式安裝的mysql
GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
flush privileges;
end.2019年9月29日01:02:27