树莓派(rasperberry pi 2)上装mysql远程无法访问

Myth丶恋晨 2022-08-18 13:17 137阅读 0赞

树莓派(rasperberry pi 2)上装mysql远程无法访问，有需要的朋友可以参考下。

最近在折腾树莓派，想在上面安装mysql数据库。于是网上扒文章，照着几步就把mysql给装上去了：

sudo apt-get update
    sudo apt-get upgrade
    sudo apt-get install mysql-server

中间会要你输一次[服务器][Link 1]密码，就是root账号的。再确认一次后就装好了。

然后就是用mysql -uroot -p\*\*\*\*\*\* 登陆，验证一下，建库建表，毫无问题。人然后就是那一套grant all \*\*\* 配置远程访问权限。问题就在我想远程访问的时候死活连不上。中间一度怀疑是[防火墙][Link 2]的问题，于是直接清了防火墙规则

iptables -F

无效，于是怒删防火墙，任然无效。

于是组合[关键字][Link 3]（树莓派 mysql)求百度问谷歌。未果。操刀自己来吧。检查mysql的配置文件 /etc/mysql/my.cnf 发现如下配置

# Instead of skip-networking the default is now to listen only on
    # localhost which is more compatible and is not less secure.
    bind-address            = 127.0.0.1

到这里就什么都清楚了，大概意思是树莓派的mysql装完了之后默认只监听本地端口，要想[远程访问][Link 4]的话就只要把127.0.0.1改成0.0.0.0就ok了。改完重启mysql，访问正常。

[Link 1]: http://cpro.baidu.com/cpro/ui/uijs.php?adclass=0&app_id=0&c=news&cf=1001&ch=0&di=128&fv=16&is_app=0&jk=b6027272804a7a5b&k=%B7%FE%CE%F1%C6%F7&k0=%B7%FE%CE%F1%C6%F7&kdi0=0&luki=3&mcpm=0&n=10&p=baidu&q=48098089_cpr&rb=0&rs=1&seller_id=1&sid=5b7a4a80727202b6&ssp2=1&stid=9&t=tpclicked3_hc&td=2051930&tu=u2051930&u=http%3A%2F%2Fwww%2Eaichengxu%2Ecom%2Fview%2F13590&urlid=0
[Link 2]: http://cpro.baidu.com/cpro/ui/uijs.php?adclass=0&app_id=0&c=news&cf=1001&ch=0&di=128&fv=16&is_app=0&jk=b6027272804a7a5b&k=%B7%C0%BB%F0%C7%BD&k0=%B7%C0%BB%F0%C7%BD&kdi0=0&luki=4&mcpm=0&n=10&p=baidu&q=48098089_cpr&rb=0&rs=1&seller_id=1&sid=5b7a4a80727202b6&ssp2=1&stid=9&t=tpclicked3_hc&td=2051930&tu=u2051930&u=http%3A%2F%2Fwww%2Eaichengxu%2Ecom%2Fview%2F13590&urlid=0
[Link 3]: http://cpro.baidu.com/cpro/ui/uijs.php?adclass=0&app_id=0&c=news&cf=1001&ch=0&di=128&fv=16&is_app=0&jk=b6027272804a7a5b&k=%B9%D8%BC%FC%D7%D6&k0=%B9%D8%BC%FC%D7%D6&kdi0=0&luki=1&mcpm=0&n=10&p=baidu&q=48098089_cpr&rb=0&rs=1&seller_id=1&sid=5b7a4a80727202b6&ssp2=1&stid=9&t=tpclicked3_hc&td=2051930&tu=u2051930&u=http%3A%2F%2Fwww%2Eaichengxu%2Ecom%2Fview%2F13590&urlid=0
[Link 4]: http://cpro.baidu.com/cpro/ui/uijs.php?adclass=0&app_id=0&c=news&cf=1001&ch=0&di=128&fv=16&is_app=0&jk=b6027272804a7a5b&k=%D4%B6%B3%CC%B7%C3%CE%CA&k0=%D4%B6%B3%CC%B7%C3%CE%CA&kdi0=0&luki=5&mcpm=0&n=10&p=baidu&q=48098089_cpr&rb=0&rs=1&seller_id=1&sid=5b7a4a80727202b6&ssp2=1&stid=9&t=tpclicked3_hc&td=2051930&tu=u2051930&u=http%3A%2F%2Fwww%2Eaichengxu%2Ecom%2Fview%2F13590&urlid=0