Best Answer: How Can I See Database in Linux?
Contents

How can I see all MySQL databases in Linux?

To list all databases in MySQL, run the following command: mysql> show databases; This command will work for you no matter if you have an Ubuntu VPS or CentOS VPS. If you have other databases created in MySQL, they will be all listed here.

How do I find the database name in Linux?

To get a list of the databases without logging in to the MySQL shell you can use either the mysql command with the -e option which stands for execute or the mysqlshow that displays databases and tables information.

Maya Lin-Takahashi

Maya Lin-Takahashi

Consumer Tech & Gadget Reviewer

Maya is a hardware enthusiast who tests and reviews smart home devices, smartphones, wearables, and audio gear. She focuses on practical consumer value and build quality.

Share this article
Twitter Facebook Pinterest