How to display databases, tables, and columns information in MySQL

mysqlshow --user=root --password=root
mysqlshow --user=root --password=root DatabaseName
mysqlshow --user=root --password=root DatabaseName TableName