install mysql 5.7 on centos 7

自從mysql被移除後,要從centos7上面安裝mysql方法,變成了要去官網

1.安裝官方rpm

sudo rpm -Uvh https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm

2.安裝mysql

sudo yum install mysql-community-server

3.拿密碼

通常google出來的文件會告訴你要去執行mysql_secure_installation,但人生就是多了but…

mysql_secure_installation

Error: Access denied for user ‘root’@’localhost’ (using password: NO)

對,在５．７版他預設了一組臨時密碼,但是….他不會顯示給你看

在centos７也沒有mysqld_safe這個指令,所以要看到剛安裝好的預設密碼

要去mysqld.log看

sudo grep ‘temporary password’ /var/log/mysqld.log

就可以看到密碼了

[Note] A temporary password is generated for root@localhost: ,:qd5Gkl/yj2

登入後按照以下指令修改

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';


＃官網有寫,記得看完喔
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html

TechBlog