show tables;

Note that you must do this from the mysql command line.

A little longer explanation:

• Log in to your MySQL database, i.e.,
  mysql -u root -p
   
  
• Select your database, i.e.,
  use my_database;
   
  
• Then issue the command, i.e.,
  show tables;