regarding password profile

[rakesh db]

Hi All,

I am very new to mysql databases. Need to know about setting the password complexity for users in mysql database.

Ask is to find any password rules set for the existing users in mysql database. This is part of an external auditing. For example, when you create an user in the database, the password should meet some password complexity requirements like min 10 chars,password expiry set etc.

We have couple of already existing users in the database. Need to find out whether those users are using any password profiles or password complexity settings.

Mysql database version is 5.6.35-81.0