Showing entries 1 to 1
Displaying posts with tag: connection verification (reset)
MySQL User connections

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 …

[Read more]
Showing entries 1 to 1