服務器信息:
服務器:阿里云
系統(tǒng):CentOS7.3
MySQL:5.7.18
安裝過程
更新yum源: ?yum update
下載MySQL源安裝包: ??
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.*"
安裝MySQL: ?yum install mysql-community-server
啟動MySQL: ?systemctl start mysqld
查看MySQL狀態(tài): ?systemctl status mysqld
設置開機啟動MySQL:
systemctl enable mysqld ?
systemctl daemon-reload
查找并修改MySQL默認密碼:
?grep 'temporary password' /var/log/mysqld.log ?
?mysql -uroot -p ??
?alter userroot@localhost identified by '你的新密碼';
遠程連接測試
添加遠程賬戶:
GRANT ALL PRIVILEGES ON *.* TO '用戶'@'%' IDENTIFIED BY '密碼' WITH GRANT OPTION;
立即生效:flush privileges;
退出MySQL:exit
注意問題
1、本文使用root權限鸽嫂,普通用戶需給sudo權限据某,到配置文件/etc/sudoers里配置
2、安裝過程中出現(xiàn)選擇的都按y然后回車允許
3筷狼、遠程連接測試時候,注意在阿里云管理控制臺的安全組里配置規(guī)則,授權3306端口允許訪問