1窗悯、安裝 Mysql
wget https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm
yum -y install mysql80-community-release-el7-1.noarch.rpm
yum -y install mysql-community-server
mysql -V
返回結(jié)果如下区匣,表示安裝成功
mysql Ver 8.0.18 for Linux on x86_64 (MySQL Community Server - GPL)
2、配置 Mysql
systemctl start mysqld // 啟動(dòng) mysql 服務(wù)
systemctl enable mysqld // 設(shè)置 mysql 服務(wù)開(kāi)機(jī)啟動(dòng)
3、獲取 root 用戶的初始密碼亏钩。
grep 'temporary password' /var/log/mysqld.log
4莲绰、安全性配置
mysql_secure_installation
5、遠(yuǎn)程訪問(wèn) 創(chuàng)建遠(yuǎn)程登錄MySQL的賬號(hào)
mysql -uroot -p
mysql> update user set host = '%' where user = 'root'; // 設(shè)置所有的ip都可以連接
flush privileges // 使配置生效
service mysqld restart // 退出 mysql 后重啟