Warning: Creating default object from empty value in /www/htdocs/v030397/mysql-qotd/wp-content/plugins/sitepress-multilingual-cms/sitepress.class.php on line 4991

Warning: Creating default object from empty value in /www/htdocs/v030397/mysql-qotd/wp-content/plugins/sitepress-multilingual-cms/sitepress.class.php on line 4993
Question 1: How do you check which databases exist inside your mysql instance? – MySQL Question of the Day

Skip to content

By urs in mysql questions

(Find all correct answers)

a) mysqlshow -p -u root *
b) mysqllist -p -u root --all-databases
c) mysql -p -u root -e "show databases"
d) mysql -p -u root --execute "select schema_name from information_schema.schemata"
e) mysqldisplay --all-databases
 

[ Client/Server Concepts (5%) - Invoking Client Programs ]

 

Tags: , ,

Comment Feed

One Response

  1. Answers:

    a c d

    The commands mysqllist and mysqldisplay do not exist.

You must be logged in to post a comment.