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 on 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

The above commands are used to List of all Database will be displayed in the MySQL Server.

Categorized in:

Tagged in:

, ,