mysql.information_schema.DATABASE_USERS.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of schemacrawler-mysql Show documentation

There is a newer version: 16.22.3

SELECT
  USER AS USERNAME,
  HOST,
  PLUGIN,
  AUTHENTICATION_STRING,
  PASSWORD_LAST_CHANGED,
  PASSWORD_EXPIRED,
  ACCOUNT_LOCKED
FROM
  MYSQL.USER
ORDER
  BY USER