MySQL / MariaDB DBA

Accounts, Authentication & Security

Question

Account name versus login name: what identifies a database principal?

Answer

An account is the user-and-host identity selected at connection time; a login name is just the client-supplied user component. Grant privileges to the intended account identity, not every host using that name. Applies to MySQL and MariaDB.

This is 3 of 23 free samples for MySQL / MariaDB DBA.

More MySQL / MariaDB DBA topic samples