ServerCake India

How to List all Databases in MySQL Server?

list the databases in mysql server
Listing the Database in MySQL Server through Command Line

What is MySQL?

MySQL is an open source Relational Databases Management System(RDBMS) based on Structured Query Language(SQL). MySQL runs virtually on all platforms including Linux, Unix and Windows. SQL is the most popular language for adding, accessing and managing contents in the database. It is most noted for its quick processing, proven reliability, ease, and flexibility.

How to List all Databases in MySQL Server?

Login to the MySQL server as a root user by using the command mysql -u root -ppassword

After logging in, MySql you will bMySQL shell.To list all databases in the server, in use the command SHOW DATABASES

To list all database on the server without logging into MySQL server, use the command mysqlshow -u user -ppassword

To show tables in a particular database, use the command mysqlshow -u user -ppassword databasename

Editorial Team

Editorial Team at ServerCake India Blog is a team of experts in Server Administration, Business Development, Management, SEO Analyst & Graphic Designers with more than 5+ years of expertise.

Add comment