轉(zhuǎn)自 ubuntu連接阿里云mysql數(shù)據(jù)庫
1恕稠、開啟MySQL服務(wù)
#service mysqld start
2谊却、登錄
#mysql -uroot -p
3、開啟遠程連接
首先略就，要去阿里云控制臺開放3306端口
1吗跋、查看已打開的端口：#netstat -anp
2桌粉、 查看想開的端口是否已開：#firewall-cmd --query-port=3306/tcp 若提示FirewallD is not running 表示防火墻未開啟，需要開啟防火墻
3祭钉、開啟防火墻：#systemctl start firewalld；關(guān)閉防火墻：#systemctl stop firewalld
若提示Failed to start firewalld.service: Unit is masked己沛，要先#systemctl unmask firewalld.service慌核，然后#systemctl start firewalld.service
4、開啟永久端口號：#firewall-cmd --add-port=3306/tcp --permanent
5申尼、重新載入配置：#firewall-cmd --reload
6垮卓、修改iptables，有些版本需要安裝iptables-services：#yum install iptables-services师幕，然后進目錄修改內(nèi)容：#vi /etc/sysconfig/iptables
然后粟按，進入mysql創(chuàng)建新用戶
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;
mysql> UPDATE user SET password=PASSWORD('123456')WHERE user='root';
mysql> FLUSH PRIVILEGES;
mysql> quit;
4、本地登錄阿里云mysql數(shù)據(jù)庫
#mysql -h 你的公網(wǎng)ip -p 3306 -uroot -p
