Recent

Author Topic: MySQL5.7 Show only User-created Database(s)  (Read 591 times)

Zvoni

  • Jr. Member
  • **
  • Posts: 78
MySQL5.7 Show only User-created Database(s)
« on: April 27, 2018, 08:51:42 pm »
Hi Folks,

quick question: Is there any way to list all Databases in MySQL only showing the user-created databases, but not the system ones (mysql, sys, information_schema, performance_schema)?

I know of "show databases", but that one shows all

thx
Zvoni

EDIT: I've created a View excluding those Databasenames.
Solved
« Last Edit: April 27, 2018, 11:30:16 pm by Zvoni »
One System to rule them all, One IDE to find them,
One Code to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie