I am tired of not having the up-arrow repeat-command function in windows and am trying to find a way to get it. Iīve read if I run mysqlc.exe, instead of mysql.exe, I will get it, but the problem is that there is no mysqlc.exe in my \bin directory. And not even the cygwinb19.dll library, wich I read must be copied to the \windows\system directory in order mysqlc.exe could run. (like if I had it!)
Please let me know if you guys found any solution for this.
It's quite simple, really. Create a Windows command prompt window as a shortcut to c:\mysql\bin. At the command prompt you can start using the mysql command line commands. You can right click on the shortcut and set all kinds of other options for the command window. In the "Options" tab itself you will find the "Command history" options.
I've found the *easy* way to do this is to copy the already existing shortcut on the
Start Menu > All Programs > Accessories > Command Prompt
to your desired location, be it your desktop, Quick Launch Toolbar ... whatever. Then modify that Shortcut by right-clicking it and choosing Properties from the pop-up context menu. In the Shorcut tab you'll notice the Target looks like (or much like) the example given earlier. The "Start in:" textbox is where you will change the path to the path in which your MySQL binary exists. I happened to installed mine in the root: c:\mysql\bin
Next tab over then is your Options tab and that is where you can modify the information I referred to. I also modified my Colors so I can quickly recognize the MySQL shell that I have open (I changed the default icon to the MySQL icon as well, so I can tell it apart from my usual Command Prompt).