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