2.2.3、如何打开mysql的端口
2.2.4、在win7上,只要在‘入站规则’上建立一个3306端口即可。
控制面板=>管理工具=>高级安全的Windows防火墙=>入站规则
然后新建规则=>选择‘端口’=>在‘特定本地端口’上输入一个‘3306’=>选择‘允许连接’=>选择‘域’、‘专用’、‘公用’
=>给个名称,如:mysqlinput
2.2.5、在linux的Ubuntu上,对mysql的配置文件进行配置均可。
按F3(打开命令行)=>输入"sudo vi /etc/mysql/my.cnf"(用vim打开)=>
# 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
注释掉bind-address均可,即#bind-address = 127.0.0.1,表示允许通过远程端口3306访问。
=>重启mysql,即在命令行输入"sudo /etc/init.d/mysql restart"