将mysql skip

编程入门 行业动态 更新时间:2024-10-24 15:21:54
本文介绍了将mysql skip-networking设置为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上始终称为myf,从不称为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 myf 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

本文发布于:2023-10-22 08:28:43,感谢您对本站的认可!
本文链接:https://www.elefans.com/category/jswz/34/1516984.html
版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系,我们将在24小时内删除。
本文标签:mysql   skip

发布评论

评论列表 (有 0 条评论)
草根站长

>www.elefans.com

编程频道|电子爱好者 - 技术资讯及电子产品介绍!