MySQL: Find out which edition you are using

Sometimes, no one in a company knows how many databases they have, or how many commercial licenses they have. So you may be asked to write a report with all the existing MySQL instances, and whether they are Enterprise Editions or Community Editions.

Knowing a MySQL instance edition is very easy:

SHOW GLOBAL VARIABLES LIKE 'license';

If it’s MySQL Community Edition, the value is ‘GPL‘. Otherwise, it is MySQL Enterprise Edition.

Reference

Related articles:

• Find out if you’re running MariaDB, MySQL or Percona Server