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