安裝環(huán)境:CentOS7 64位 哮针,安裝MySQL5.7
1十厢、配置YUM源
在MySQL官網中下載YUM源rpm安裝包:https://dev.mysql.com/downloads/repo/yum/
wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
安裝mysql源
yum localinstall mysql57-community-release-el7-8.noarch.rpm
檢查mysql源是否安裝成功
yum repolist enabled | grep "mysql.*-community.*"
image.png
2捂齐、安裝MySQL
yum install mysql-community-server
3奠宜、啟動MySQL服務
systemctl start mysqld
4瞻想、開機啟動
systemctl enable mysqld
systemctl daemon-reload
5蘑险、修改root本地登錄密碼
mysql安裝完成之后佃迄,在/var/log/mysqld.log文件中給root生成了一個默認密碼。通過下面的方式找到root默認密碼呵俏,然后登錄mysql進行修改:
set password for 'root'@'localhost'=password('password!');
image.png
6柴信、允許遠程連接
create user '用戶名'@'%' identified by '密碼';
grant all privileges on 數據庫.* to '用戶名'@'%' with grant option;
flush privileges;