Guest User

Untitled

a guest
Jan 19th, 2018
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. # 0x01 检查防火墙是否放行3306
  2. # 0x02 查看3306监听情况
  3. `$ netstat -an | grep 3306`
  4. ```tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN```
  5. 这样的就是3306端口只是在IP 127.0.0.1上监听,所以拒绝了其他IP的访问。
  6.  
  7. ## 解决办法
  8. `vim /etc/mysql/my.cnf`
  9.  
  10. `bind-address = 127.0.0.1` -> `# bind-address = 127.0.0.1`
  11. ## 正常结果
  12. ```
  13. $ netstat -an | grep 3306
  14. tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN
  15. ```
  16. # 0x04 检查mysql账户是否拥有外网访问权限
Add Comment
Please, Sign In to add comment