mysql client (win32), command line history

I run mysql Ver 11.16 Distrib 3.23.49, on windows xp pro. Both client and server are installed on the same pc, though I have tried this with remote connections as well.

mysql is installed in c:\srtpath\mysql and both client and server as well as winmysqladmin and myodbc work flawelessly.

... expect that I can't get the mysql client to retain the command line history between sessions.

To be precise, it will remember, if the client is called from an existing command prompt window, and for as long as this window remains open. But this is the only exception. In any other occasion, exiting mysql means that the history is reset.

I have tried setting the MYSQL_HISTFILE variable to point to a text file in two ways:

First in 'system properties', 'advanced', 'environment variables'.

Then, also, by creating a batch file (mysql.bat) executing this two lines:
------------
set MYSQL_HISTFILE=c:/srtpath/mysql/history.txt
mysql
------------
and then calling mysql.bat instead of mysql.exe

Neither of these made any difference.

In fact, I got the impression that none of the environment variables listed in:
URL
is working. Which makes me think that I must be missing something...

Any ideas?

Many thanks for reading!

Hmmm. I'd say the best thing to do would be to send a quick email to the MySQL AB team mentioning that... it may be an unknown bug.