blocks|key|1463713|text|假设您具有MySQL的本机Windows构建，则DOS+(命令提示符)窗口和bash之间存在终端仿真不兼容问题。没有显示mysql的提示符。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1463714|要确认这一点，请键入命令并返回-它可能会起作用，但命令的提示符和回显(您正在键入的内容)正在丢失。|1463715|在CYGWIN系统属性或bash中可能有解决方法，但我从来没有花时间来解决这个问题。|1463716|entityMap^0|O|3|12|4|1O|5|0|0|1|6|C|4|0^^$0|@$1|2|3|4|5|6|7|L|8|@$9|M|A|N|B|C]|$9|O|A|P|B|C]|$9|Q|A|R|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|S|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|T|8|@$9|U|A|V|B|C]|$9|W|A|X|B|C]]|D|@]|E|$]]|$1|J|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]]|K|$]]

Assuming that you have a native Windows build of MySQL, there is a terminal emulation incompatibility between <code>DOS</code> (command prompt) windows and <code>bash</code>. The prompt for <code>mysql</code> isn't showing up.

To confirm this, type a command and return - it will probably work, but the prompt and the echo of the command (what you're typing) is getting lost.

There may be a workaround in either the <code>CYGWIN</code> sytem properties or in <code>bash</code>, but I've never taken the time to work this one out.

blocks|key|1463740|text|我在这里发布了一个解决方案/解决方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1463741|enter+key+sometimes+not+recognized+in+windows+apps+under+cygwin|offset|length|1463742|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/202405/enter-key-sometimes-not-recognized-in-windows-apps-under-cygwin#334802^0|0|0|1R|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

I posted a solution/workaround here:

<a href="https://stackoverflow.com/questions/202405/enter-key-sometimes-not-recognized-in-windows-apps-under-cygwin#334802">enter key sometimes not recognized in windows apps under cygwin</a>

blocks|key|1679019|text|我已经为此创建了一个令我满意的半修复方案。我在cmd.exe中运行cygwin.bat，然后输入mysql+-一切运行正常。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1679020|我当时就意识到这个问题很棘手。|1679021|简单的解决方案？下载Console2，在设置下，您可以将其指向cygwin+shell。重启Console2，运行mysql，出现输出。|offset|length|1679022|无论如何，这是有利的，因为Console2具有比Mintty更健壮的接口/定制。我真的很喜欢透明度和颜色映射选项。|1679023|entityMap|0|LINK|mutability|MUTABLE|url|http://sourceforge.net/projects/console/^0|0|0|A|8|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@$F|U|G|V|1|W]]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]]]

I have created a semi-fix for this that satisfies me.
I ran cygwin.bat in cmd.exe, then typing mysql in- everything worked fine.

I realized right there that the problem was mintty.

Easy solution? Download <a href="http://sourceforge.net/projects/console/" rel="nofollow">Console2</a>, and under settings you can point
it to the cygwin shell. Restart Console2, run mysql and the output
appears.

This is advantageous anyways, because Console2 has a more robust interface/customization than Mintty. I really like the transparency and color mapping options.

blocks|key|1463866|text|重新安装cygwin，在重新安装的过程中，在包中搜索mysql，安装mysql客户端，然后就可以正常工作了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1463867|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Reinstall cygwin and during reinstallation search for mysql in packages, install the mysql client and then it would work fine.

blocks|key|1463918|text|今天发现了这个问题2018-03-18正在寻找一些答案|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1463919|ERROR+2002+(HY000):+Can't+connect+to+local+MySQL+server+through+socket+'/var/run/mysql.sock'+(2+"No+such+file+or+directory")|code-block|syntax|javascript|1463920|文件/etc/my.conf引用/etc/my.cnf.d中的配置文件我将此文件添加到/etc/my.cnf.d/client.cnf|offset|length|style|CODE|1463921|[client]
host=127.0.0.1
protocol=tcp|1463922|之后，我可以使用mysql+-u+root+-p从cygwin终端访问本地windows+MySQL实例|1463923|entityMap^0|0|0|2|C|G|D|17|O|0|0|8|G|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@$I|V|J|W|K|L]|$I|X|J|Y|K|L]|$I|Z|J|10|K|L]]|9|@]|A|$]]|$1|M|3|N|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|12|8|@$I|13|J|14|K|L]]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|R|$]]

Found this question today 2018-03-18 looking for some answers to 

<pre><code>ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql.sock' (2 "No such file or directory")
</code></pre>

The file <code>/etc/my.conf</code> references config files in <code>/etc/my.cnf.d</code>
I added this to <code>/etc/my.cnf.d/client.cnf</code>:

<pre><code>[client]
host=127.0.0.1
protocol=tcp
</code></pre>

After that I was able to access the local windows MySQL instance from a cygwin terminal using <code>mysql -u root -p</code>

I can successfully connect to MySQL from a DOS prompt, but when I try to connect from cygwin, it just hangs.

<pre><code>$/cygdrive/c/Program\ Files/MySQL/MySQL\ Server\ 5.1/bin/mysql -u root -p
</code></pre>

What's wrong?

connecting to mysql from cygwin

Windows

MySQL

我可以从DOS提示符成功连接到MySQL，但当我尝试从cygwin连接时，它就挂起了。$/cygdrive/c/Program\ Files/MySQL/MySQL\ Server\ 5.1/bin/mysql -u root -p怎么了？

问从cygwin连接到mysql
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从cygwin连接到mysqlEN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从cygwin连接到mysql
EN