MySQL console: Ctrl+C driving me nuts

interfaceMySQLmysql-console

There is something in the MySQL console that drives me nuts. When I hit ctrl+c to cancel the current command being typed, the terminal exits.

In every terminal I know (*nix terminals, Python, PostgreSQL), ctrl+c cancels the current command and ctrl+d exits the terminal.

This issue has been reported at 2003, and bumped several times since.

Is there a way to:

Change this behaviour, or
Convince the MySQL dev team that this is really annoying?

Best Answer

To change the behaviour, download the source for the mysql CLI and modify the SIGINT handler to behave as you see fit, then recompile & install.

Related Solutions

Mysql – Read thesql config (the.cnf) using thesql console

Depending on how your access was implemented, you may be able to look at my.cnf with the \! command.

mysql> pager less
mysql> \! cat /etc/mysql/my.cnf
....
mysql> nopager

If you want to know what variables are actually running on the server, look at SHOW GLOBAL VARIABLES

mysql> SHOW GLOBAL VARIABLES;

Mysql – Make MySQL server terminate when shell exits or on ctrl-c

You could try --gdb. That will make it respond to SIGINT, though I'm not sure if that has potential to corrupt the database. --one-thread may also be of some help.

Best Answer

Related Solutions

Mysql – Read thesql config (the.cnf) using thesql console

Mysql – Make MySQL server terminate when shell exits or on ctrl-c

Related Question