To view a list of databases simply issue the following command:
SHOW DATABASES;
Category: Mysql
Delete a MySQL Database on Linux
Pre-Flight Check
These instructions are intended for deleting a MySQL database on Linux via the command line.
I’ll be working from a Liquid Web Core Managed CentOS 7 server, and I’ll be logged in as root.
First we’ll login to the MySQL server from the command line with the following command:
mysql -u root -p
Continue reading “Delete a MySQL Database on Linux”
List tables in a MySQL database
How do I show/list the tables in a MySQL database (using the mysql command line client)?
To list/show the tables in a MySQL database:
Log into your database using the MySQL client, Issue the use command to connect to your desired database, and then Use the MySQL show tables command.
Continue reading “List tables in a MySQL database”