If you have your own server and have MySQL installed with some database, and would like to view
the contents of a table in that database, then you can follow the steps below:-
Step 1: Login to your Linux server and run the command below on the MySQL command line to login :-
mysql -u root -p [enter]
enter the password
Step 2: View the databases created on the system :-
show databases;
Step 3: Use the database under which you would like to view the contents of the table. For ex-
use abc_db;
Step 4: View the tables in that database using the command below:-
show tables;
Step 5: Now to view the contents of a table, run the command :-
select * from table_a1b2;
After running the command above, you will see the contents of the table.
]]>