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


  • Sr. Member
  • ****
  • Posts: 392
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


EDIT: I've created a View excluding those Databasenames.
« 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
People call me crazy, because i'm jumping out of perfectly fine aircrafts


TinyPortal © 2005-2018