So I found myself explaining the differences with MySQL users and how they authenticate. First of all this information is not new but can be found here:
I will just show some real world examples to explain
this.
MySQL uses the username as well as the login when it evaluates
the permissions of a user. This is why a best practice is to
remove the anonymous users.
For this example I will start off with the following
users
MariaDB [(none)]> select user , host from
mysql.user;
+---------+-----------+
|
user | host |
+---------+-----------+
| root |
127.0.0.1 |
| root | ::1 …