How to adjust display settings of mysql command line?

You can use the \G command (instead of the ;) at the end of your SQL queries…

Example:

SELECT * FROM USER \G

It will display your table in row form instead of column form.