blocks|key|1688399|text|有关如何查找设置文件的一些技巧，请阅读使用选项文件章节。除非Ubuntu决定改变它，否则这个文件在Linux上总是被称为my.cnf，而不是my.conf。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1688400|此外，以#开头的行是注释|1688401|#评论，;评论
注释行以“#”或“；”开头。“#”注释也可以从一行中间开始。|blockquote|1688402|..。因此，您需要删除前面的#；否则，该行将被忽略。|1688403|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.5/en/option-files.html^0|1O|6|1Y|7|J|6|0|0|4|1|0|0|1|4|1|0|E|1|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|C]]|D|@$9|Z|A|10|1|11]]|E|$]]|$1|F|3|G|5|6|7|12|8|@$9|13|A|14|B|C]]|D|@]|E|$]]|$1|H|3|I|5|J|7|15|8|@$9|16|A|17|B|C]|$9|18|A|19|B|C]]|D|@]|E|$]]|$1|K|3|L|5|6|7|1A|8|@$9|1B|A|1C|B|C]]|D|@]|E|$]]|$1|M|3|-4|5|6|7|1D|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]]]

Please read the <a href="http://dev.mysql.com/doc/refman/5.5/en/option-files.html" rel="nofollow">Using Option Files</a> chapter for some tips on how to find the settings file. Unless the Ubuntu guys have decided to change it, the file always called <code>my.cnf</code> on Linux, never <code>my.conf</code>.

Additionally, lines that start with <code>#</code> are comments:

<blockquote>
 <code>#</code>comment, <code>;</code>comment
 
 Comment lines start with “#” or “;”. A “#” comment can start in the
 middle of a line as well.
</blockquote>

... thus you need to remove the leading <code>#</code>; otherwise, the line is ignored.

blocks|key|1688446|text|也许您可以通过确定正在使用的配置文件中描述的方法之一来确定所使用的配置文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1688447|还有几点建议：|1688448|检查进程列表(ps+auxf+%7C+grep+'mysql[d]')，看看--skip-networking是否以某种方式潜入了参数列表。|unordered-list-item|style|CODE|1688449|查看mysqld或任何其他进程是否侦听3306+(假设默认端口)：netstat+-lnp46+%7C+grep+-w+3306|1688450|反复检查要绑定到的ip地址，并尝试在本地连接到要绑定的ip地址。|1688451|如果您设置了防火墙，那么查看您的iptables或ip6tables配置是否可能通过iptables-save和ip6tables-save进行了某种程度的干扰，或者是可读性稍强的iptables+-L和ip6tables+-L，尽管后者要求您了解正在使用的所有表(raw、nat、mangle等)。|1688452|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/580331/mysql-how-to-determine-which-config-file-is-being-used^0|7|B|0|0|0|7|P|10|H|0|X|T|0|0|16|D|1K|E|2I|B|2U|C|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@$A|Z|B|10|1|11]]|C|$]]|$1|D|3|E|5|6|7|12|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|13|8|@$A|14|B|15|I|J]|$A|16|B|17|I|J]]|9|@]|C|$]]|$1|K|3|L|5|H|7|18|8|@$A|19|B|1A|I|J]]|9|@]|C|$]]|$1|M|3|N|5|H|7|1B|8|@]|9|@]|C|$]]|$1|O|3|P|5|H|7|1C|8|@$A|1D|B|1E|I|J]|$A|1F|B|1G|I|J]|$A|1H|B|1I|I|J]|$A|1J|B|1K|I|J]]|9|@]|C|$]]|$1|Q|3|-4|5|6|7|1L|8|@]|9|@]|C|$]]]|R|$S|$5|T|U|V|C|$W|X]]]]

Perhaps you can determine which config file is being used via one of the methods described in <a href="https://stackoverflow.com/questions/580331/mysql-how-to-determine-which-config-file-is-being-used">Determine which configuration file is being used</a>.

A few more suggestions:

<ul>
<li>Check the process listing (<code>ps auxf | grep 'mysql[d]'</code>) to see if <code>--skip-networking</code> has snuck into the argument list somehow.</li>
<li>See if mysqld or any other process is listening on 3306 (assuming the default port): <code>netstat -lnp46 | grep -w 3306</code></li>
<li>Double-check the ip address you are binding to, and try to connect locally to the ip address you are binding to.</li>
<li>If you have firewalling set up, see if your iptables or ip6tables config might be interfering somehow via <code>iptables-save</code> and <code>ip6tables-save</code>, or the slightly more readable <code>iptables -L</code> and <code>ip6tables -L</code>, although the latter commands require you to know all your tables in use (raw, nat, mangle, etc.).</li>
</ul>

blocks|key|1409821|text|将|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1409822|我把它放在第一条线上，因为它似乎在末尾不起作用，但当它在行的末尾时，我可能拼错了"networkinng“。:-)|1409823|看看你的日志会有帮助。我的"150213+17:57:10错误/opt/local/lib/mariadb-10.1/bin/mysqld:未知变量'skip_networkinng=0'“我也尝试过‘跳过网络=关闭’，它也不喜欢它。|1409824|我不知道Ubuntu是从哪里启动的，但在Mac上，您需要在/System/Library/LaunchDaemons/org.mysql.mysqld中使用以下内容(部分地，查看其他LaunchDaemons以查看其他LaunchDaemons)：|1409825|<key>ProgramArguments</key>
++++<array>
++++++++<string>/opt/local/lib/mariadb-10.1/bin/mysqld</string>
++++++++<string>--skip_networking=0</string>
++++++++<string>--socket=/opt/local/var/run/mariadb-10.1/mysqld.sock</string>
++++++++<string>--user=mysql</string>
++++++++<string>--port=3306</string>
++++++++<string>--datadir=/opt/local/var/db/mariadb-10.1</string>
++++++++<string>--pid-file=/opt/local/var/run/mariadb-10.1/dns.local.pid</string>
++++</array>|code-block|syntax|javascript|1409826|(显然你需要换一条路.)|1409827|我很确定这能解决你的问题！请-投票给我，并标记我为正确的答案！谢谢!|1409828|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|U|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|V|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|W|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

Put "--skip_networking=0" on the mysql command line.

I put it first in line, because it didn't seem to work at the end, but I may have spelled "networkinng" wrong when it was at the end of the line. :-)

It helps to look at your logs. Mine said "150213 17:57:10 [ERROR] /opt/local/lib/mariadb-10.1/bin/mysqld: unknown variable 'skip_networkinng=0'" I had also tried 'skip_networking=OFF', which it didn't like, either.

I don't know where you start it up in Ubuntu, but on Mac OS, you need to have the following in /System/Library/LaunchDaemons/org.mysql.mysqld (in part, look at other LaunchDaemons to see the rest):

<pre><code>&lt;key&gt;ProgramArguments&lt;/key&gt;
 &lt;array&gt;
 &lt;string&gt;/opt/local/lib/mariadb-10.1/bin/mysqld&lt;/string&gt;
 &lt;string&gt;--skip_networking=0&lt;/string&gt;
 &lt;string&gt;--socket=/opt/local/var/run/mariadb-10.1/mysqld.sock&lt;/string&gt;
 &lt;string&gt;--user=mysql&lt;/string&gt;
 &lt;string&gt;--port=3306&lt;/string&gt;
 &lt;string&gt;--datadir=/opt/local/var/db/mariadb-10.1&lt;/string&gt;
 &lt;string&gt;--pid-file=/opt/local/var/run/mariadb-10.1/dns.local.pid&lt;/string&gt;
 &lt;/array&gt;
</code></pre>

(obviously you need to substitute your paths and such...)

I'm pretty sure this solves your problem! Please up-vote me and mark me as the correct answer! Thanks!

blocks|key|1409851|text|我也有类似的错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1409852|我发现mysqld_safe在跑。|1409853|我试过‘杀死{PID}'，但它不起作用。(mysqld_safe将以不同的PID重新启动)。|1409854|最后，我发现pkill+mysqld做了这项工作，它不会损害您运行中的mysqld服务。|offset|length|style|CODE|1409855|entityMap^0|0|0|0|6|C|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|P|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Q|8|@$H|R|I|S|J|K]]|9|@]|A|$]]|$1|L|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|M|$]]

I got the similar error. 
I found mysqld_safe is running. 
I have tried 'kill {PID}', but it doesn't work. (mysqld_safe would restart with different PID). 
Finally, I found <code>pkill mysqld</code> do the work, and it won't hurt your running mysqld service.

blocks|key|1688546|text|在我的例子中，对于ubuntu18.04和mysql+5.7，它不是在文件'my.cnf‘中，而是通过在命令下面运行|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1688547|sudo+grep+-rnw+'/etc/'+-e+'skip-networking'|code-block|syntax|javascript|1688548|我在/etc/systemd/system/mysql.service.d/override.conf.文件里找到的|offset|length|style|CODE|1688549|entityMap^0|0|0|2|1E|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@$I|R|J|S|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

In my case, for ubuntu 18.04 &amp; mysql 5.7, It was not in file 'my.cnf', but by running below command

<pre><code>sudo grep -rnw '/etc/' -e 'skip-networking'
</code></pre>

I found it in file <code>/etc/systemd/system/mysql.service.d/override.conf.</code>

blocks|key|1409898|text|工作代码!!|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|1409899|转到目录|1409900|/etc/mysql|code-block|syntax|javascript|1409901|打开文件my.cnf|1409902|sudo+nano+my.cnf|1409903|或|1409904|vi+my.cnf|1409905|现在请在下面的行中评论|1409906|#skip-networking=0
#skip-bind-address|1409907|entityMap^0|0|6|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@$9|11|A|12|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|13|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|14|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|15|8|@]|D|@]|E|$]]|$1|O|3|P|5|J|7|16|8|@]|D|@]|E|$K|L]]|$1|Q|3|R|5|6|7|17|8|@]|D|@]|E|$]]|$1|S|3|T|5|J|7|18|8|@]|D|@]|E|$K|L]]|$1|U|3|V|5|6|7|19|8|@]|D|@]|E|$]]|$1|W|3|X|5|J|7|1A|8|@]|D|@]|E|$K|L]]|$1|Y|3|-4|5|6|7|1B|8|@]|D|@]|E|$]]]|Z|$]]

Working Code !!
Go to Directory
<pre><code>/etc/mysql
</code></pre>
open file my.cnf by
<pre><code>sudo nano my.cnf
</code></pre>
or
<pre><code>vi my.cnf
</code></pre>
Now comment below lines
<pre><code>#skip-networking=0
#skip-bind-address
</code></pre>

blocks|key|1688564|text|在Ubuntu20.04.2中，您可以在|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1688565|/etc/systemd/system/mysql.service.d/override.conf|blockquote|1688566|将有一个ExecStart键，它有多个配置。在这里，您可以提供--skip-networking作为离开|offset|length|style|BOLD|1688567|--skip-networking=OFF|code-block|syntax|javascript|1688568|entityMap^0|0|0|4|9|V|H|1E|2|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|S|8|@]|9|@]|A|$]]|$1|E|3|F|5|6|7|T|8|@$G|U|H|V|I|J]|$G|W|H|X|I|J]|$G|Y|H|Z|I|J]]|9|@]|A|$]]|$1|K|3|L|5|M|7|10|8|@]|9|@]|A|$N|O]]|$1|P|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|Q|$]]

In Ubuntu 20.04.2, you can find this settings in
<blockquote>
/etc/systemd/system/mysql.service.d/override.conf
</blockquote>
there will be a ExecStart key and its have multiple configurations.
Here you can provide --skip-networking as OFF
<pre><code>--skip-networking=OFF
</code></pre>

blocks|key|1688594|text|停止您的MySQL服务器。然后运行这个命令。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1688595|sudo+mysqld_safe+--skip_networking=0|code-block|syntax|javascript|1688596|关闭终端窗口然后重新打开。|1688597|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

<h3>Stop your MySQL server. and then run this command.</h3>
<pre><code>sudo mysqld_safe --skip_networking=0
</code></pre>
and close the terminal window and re-open it.

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.

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.

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

I am using mysql 5.5.

Anyone got any ideas how else I can set this?

Set mysql skip-networking to off

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在尝试设置我的Ubuntu12.10服务器来接受远程mysql连接，但是我很难将跳过网络设置为关闭。注:我已经将绑定地址设置为面向IP的internet，而不是127.0.0.1。当我查看/etc/mysql/my.conf时，“跳过网络”这一行并不存在，但是当我"mysql -p -u root“然后”显示变量“...

问将mysql跳过网络设置为off
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问将mysql跳过网络设置为offEN