How to disable HTML output in mysql console? I've used several mysql instances on many servers, but this one had a suprise for me tonight when I tried to use its console for the first time :

me@MYSERVER:~$ mysql -H my_base (....)
(...) 
Server version: 5.5.37-0ubuntu0.12.10.1 (Ubuntu)
(...)

mysql&gt; show tables;
&lt;TABLE BORDER=1&gt;&lt;TR&gt;&lt;TH&gt;Tables_in_crocowords&lt;/TH&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;T_BEST_LEVEL&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;T_CONNECTED&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;T_CONTEST&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;T_MONEY&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;T_MONEY_CREDIT&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;T_MONEY_DEBIT&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;T_PARTICIPATION&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;T_PERFECT&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;T_PLAYER&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;T_RANK&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;T_REPLAY&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;T_REPLAY_DATA&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;T_REPLAY_LEVEL&lt;/TD&gt;&lt;/TR&gt;&lt;/TABLE&gt;13 rows in set (0.00 sec)

mysql&gt; select * from T_BEST_LEVEL LIMIT 3;
&lt;TABLE BORDER=1&gt;&lt;TR&gt;&lt;TH&gt;fid_contest&lt;/TH&gt;&lt;TH&gt;best_level&lt;/TH&gt;&lt;TH&gt;best_level_score&lt;/TH&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;72&lt;/TD&gt;&lt;TD&gt;1&lt;/TD&gt;&lt;TD&gt;13&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;73&lt;/TD&gt;&lt;TD&gt;1&lt;/TD&gt;&lt;TD&gt;60&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;73&lt;/TD&gt;&lt;TD&gt;2&lt;/TD&gt;&lt;TD&gt;44&lt;/TD&gt;&lt;/TR&gt;&lt;/TABLE&gt;3 rows in set (0.00 sec)


All outputs are in HTML format !

I've tried to look and browse the documentations about this, but couldn't figure how to remove this html output.

Can you help me ?

:~$ mysql --version
mysql  Ver 14.14 Distrib 5.5.37, for debian-linux-gnu (i686) using readline 6.2
You told it to generate html.

$ mysql -H my_base


The -H option is an alias for the --html option.

I assume you were thinking of -h ... which is the shortcut for --host.

http://dev.mysql.com/doc/refman/5.5/en/mysql-command-options.html#option_mysql_html