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 …