How do I list the tables in a MySQL database?

MySQL FAQ: How do I show/list the tables in a MySQL (or MariaDB) database (using the mysql command line client)?

To list/show the tables in a MySQL database:

  1. Log into your database using the mysql command line client
  2. Issue the use command to connect to your desired database (such as, use mydatabase )
  3. Use the MySQL show tables command, like this:
show tables;

A complete explanation follows.