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> show tables;

mysql> select * from T_BEST_LEVEL LIMIT 3;
<TABLE BORDER=1><TR><TH>fid_contest</TH><TH>best_level</TH><TH>best_level_score</TH></TR><TR><TD>72</TD><TD>1</TD><TD>13</TD></TR><TR><TD>73</TD><TD>1</TD><TD>60</TD></TR><TR><TD>73</TD><TD>2</TD><TD>44</TD></TR></TABLE>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

1 Answer 1


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.


  • Oh my god, you're totally right. Thanks a lot (yes, it was a mistake between -H and -h...)
    – Orabîg
    Jul 18, 2014 at 23:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.