Bug #58917 Mysql shell console doesn't work in cygwin
Submitted: 14 Dec 2010 11:56 Modified: 14 Dec 2010 20:45
Reporter: Lukasz Frankowski Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:5.1.46, all OS:Any
Assigned to: CPU Architecture:Any

[14 Dec 2010 11:56] Lukasz Frankowski
Description:
Under cygwin in tty terminal mysql console doesn't work. 

How to repeat:
Enter cygwin shell and try to connect to mysql server using command line client. There's no output from mysql console.

Suggested fix:
The problem and desired solution is described here: http://lists.mysql.com/win32/6625.
[14 Dec 2010 13:10] MySQL Verification Team
Which version are you using?:

miguel@tikal ~
$ cd c:/dbs

miguel@tikal /cygdrive/c/dbs
$ cd 5.1/bin

miguel@tikal /cygdrive/c/dbs/5.1/bin
$ ./mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.54-Win X64-debug Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>
[14 Dec 2010 17:25] Lukasz Frankowski
I have currently: Ver 14.14 Distrib 5.1.46, for Win32 (ia32). I have checked out and I have system variable for CYGWIN="ntsec tty". I'm connecting to this machine using cygwin's ssh server from linux. This is Windows 7 32. I cannot easily manipulate with vars there because this is customer's production env.

Can it be a version problem?
[14 Dec 2010 20:45] Sveta Smirnova
Thank you for the report.

This is old known behavior of remote Cygwin environments and as Cygwin is not supported I have to set report to "Unsupported". If you logout from client you will see output of your queries:

$ ./bin/mysql -uroot -S /tmp/mysql_ssmirnova.sock mysql
select 1;
select user from user;
\q
1
1
user
root

root
$

Local environments are not affected.