Black Friday 2023 at Serverspace. 50% cash back on Cloud Servers
November 10, 2023
Updated November 10, 2023

How to get a list of MySQL tables

Databases Linux


The significance of utilizing Database Management Systems (DBMSs) with greater uniqueness cannot be overstated, as it contributes significantly towards an organization's growth and development. A unique approach to using a DBMS can lead to increased efficiency in data management and retrieval, which subsequently allows for better decision-making processes based on accurate information.

Moreover, by leveraging the power of DBMS uniqueness, organizations are able to streamline their operations, reduce costs associated with manual processing of data, and ultimately improve customer satisfaction. Furthermore, an innovative approach towards using a DBMS is crucial in remaining competitive within the ever-changing technological landscape, as it enables businesses to stay ahead of the curve by adapting new technologies that align with their unique needs.

The utilizing DBMS's more uniquely is essential for organizations striving to achieve optimal results and remain at the forefront of innovation.

How to see tables?

In many configurations, DBMS installations are set up without a graphical user interface (GUI), which allows users to navigate through the entire system in an interactive manner. This approach is beneficial as it enables optimal resource utilization by decreasing efficiency demands on server memory and improving overall performance. However, managing such systems can be challenging for unprepared individuals; thus, we have devised a solution that simplifies this process. To access the command-line interface (CLI) of your running server, enter the following command:

mysql -u root -h localhost -p
Get into
Screenshot №1 — Get into

In such a scenario, you may need to replace root and localhost with your own credentials (optional). The -u option specifies the user who will connect to the system, while -h denotes the target host for connection. To proceed with authentication via password, simply enter the requested information after inputting the command. Once logged in, you can use a series of commands to view all tables within your database:

USE online_store

By that command we choose default database where we will manipulate data. Then we can finally take a look at the created tables:

Show tables
Screenshot №2 — Show tables

Alright we can see created tables before, after every creation you need to enter command again!


This tutorial has equipped you with the knowledge and tools necessary to navigate and manage databases effectively, whether through command-line interactions or user-friendly GUI interfaces.

5 out of 5
Аverage rating : 5
Rated by: 1
33145 North Miami, FL, United States 2520 Coral Way apt 2-135
+1 302 425-97-76
700 300
700 300

You might also like...

We use cookies to make your experience on the Serverspace better. By continuing to browse our website, you agree to our
Use of Cookies and Privacy Policy.