① 設(shè)置MySQL中root用戶的權(quán)限：
[root@nginx-dev etc]# mysql -uroot -pRoot@123
mysql> use mysql;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Root@123' WITH GRANT OPTION;
mysql> select host,user,authentication_string from user;
+-------------+----------------------+-------------------------------------------+
| host | user | authentication_string |
+-------------+----------------------+-------------------------------------------+
| localhost | root | *E32A671056805EBAD613F4090727279564EED370 |
| localhost | mysql.session | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| localhost | mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| % | root | *E32A671056805EBAD613F4090727279564EED370 |
| % | myuser | *FABE5482D5AADF36D028AC443D117BE1180B9725 |
+-------------+----------------------+-------------------------------------------+
mysql> flush privileges;
mysql> quit
[root@nginx-dev etc]# service mysqld restart
第一個(gè)root用戶只能從本地主機(jī)連接，而第二個(gè)root用戶可以從任何主機(jī)連接。
② 檢查防火墻有沒(méi)有屏蔽掉3306端口
[root@nginx-dev etc]# systemctl start firewalld
[root@nginx-dev etc]# sudo firewall-cmd --permanent --zone=public --add-port=13306/tcp
Warning: ALREADY_ENABLED: 13306:tcp
success
[root@nginx-dev etc]# sudo firewall-cmd --permanent --zone=public --add-port=3306/tcp
Warning: ALREADY_ENABLED: 3306:tcp
success
[root@nginx-dev etc]# sudo firewall-cmd --zone=public --list-ports
13306/tcp 3306/tcp
[root@nginx-dev etc]# netstat -apn | grep 3306
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 4379/mysqld
tcp 0 0 192.168.1.9:3306 192.168.1.10:65037 ESTABLISHED 4379/mysqld
tcp 0 0 192.168.1.9:3306 192.168.1.10:65041 ESTABLISHED 4379/mysqld
③ 修改配置文件/etc/my.cnf，綁定IP設(shè)置為0.0.0.0，即接收任意地址的主機(jī)的連接，端口綁定3306。文章來(lái)源：http://www.zghlxwxcb.cn/news/detail-674442.html
文章來(lái)源地址http://www.zghlxwxcb.cn/news/detail-674442.html
到了這里，關(guān)于解決無(wú)法遠(yuǎn)程連接MySQL服務(wù)的問(wèn)題的文章就介紹完了。如果您還想了解更多內(nèi)容，請(qǐng)?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
