Help on M-x sql-mysql

[Munawar Cheema]

I was wondering if anyone on the list knows why some output from MySQL does
not show in the SQL buffer.
For example the prompt won't show at all. And after a command like 
Show tables;
I'll see ouput of the form
+---------------------+
|Tables*****          |
+---------------------+
| table1              |
| table2              |
+---------------------+

But it will not show the status at the end of the output line such as
2 rows in set (0.00 sec)

This happens to all commands such as select etc.
I have tried all kind of combinations of the sql-mysql-options
Variable. Currently it is:

(setq sql-mysql-options '("-t" "-f" "-n" "-u=root" "-B" "-i" "-q")

I have googled for this problem and seen no solution to the problem
So was hoping someone on the list could help.
It would be nice to be able to see the prompt and all the output from MySQL.

Regards
Munawar Cheema