Type "mysql -h -u -p", replacing "host name" and "username" with your host name and username. Enter your password when prompted. Type "SHOW DATABASES" to see the databases available on your server.

MySQL Command Line Log in to MySQL as the root user or a user with privileges to the database containing the data you want to export.

6 rows in set (0.00 sec) Just the Tip of the Iceberg! The mysql command-line interactive program is a very powerful way to access, display and even manipulate data without the need for any GUI at all.