将mysql skip-networking设置为off [英] Set mysql skip-networking to off

问题描述

我正在尝试将我的Ubuntu 12.10服务器设置为接受远程mysql连接，但是我很难将跳过网络设置为关闭.注意，我已经将绑定地址设置为面向Internet的IP，而不是127.0.0.1.

I'm trying to setup my Ubuntu 12.10 server to accept remote mysql connections, however I am having difficulties setting skip-networking to off. Note I have already set the bind-address to the internet facing IP, instead of 127.0.0.1.

当我查看/etc/mysql/my.conf时，"skip-networking"行不存在，但是当我依次"mysql -p -u root"和"SHOW VARIABLES;"时，该行不存在. 跳过网络"为"ON".我已将其添加为#skip-networking"并也重新启动了mysql服务.

When I look in /etc/mysql/my.conf, the line "skip-networking" doesn't exist, however when I "mysql -p -u root" and then "SHOW VARIABLES;" "skip-networking" is "ON". I have added it as "#skip-networking" and restarted mysql service too.

我一直在查看我的主文件夹和/etc/中是否有任何杂散的my.conf文件，但是没有运气.

I have looked to see if there are any stray my.conf files around in my home folder and /etc/ to no luck.

我正在使用mysql 5.5.

I am using mysql 5.5.

任何人都知道我该如何设置?

Anyone got any ideas how else I can set this?

推荐答案

请阅读使用选项文件一章，以获取有关如何查找设置文件的一些提示.除非Ubuntu家伙决定更改它，否则该文件在Linux上始终称为my.cnf，从不称为my.conf.

Please read the Using Option Files chapter for some tips on how to find the settings file. Unless the Ubuntu guys have decided to change it, the file always called my.cnf on Linux, never my.conf.

此外，以#开头的行是注释:

#评论，;评论

注释行以#"或;"开头. #"注释可以在 也在行的中间.

Comment lines start with "#" or ";". A "#" comment can start in the middle of a line as well.

...因此您需要删除开头的#;否则，该行将被忽略.

... thus you need to remove the leading #; otherwise, the line is ignored.

这篇关于将mysql skip-networking设置为off的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！