Translations:MySQL/Startup Guide/150/en

The CREATE USER SQL statement will define users and set the authentication method, commonly by password but other plugins may be available.