Mysql (MariaDB 10.0.29): Set root password, but still can login without asking password?
On MySQL table you have a column called plugin: MariaDB [(none)]> SELECT host, user, password, plugin FROM mysql.user LIMIT 0,1; +———–+——+——————————————-+——–+ | host | user | password | plugin | +———–+——+——————————————-+——–+ | localhost | root | * | | +———–+——+——————————————-+——–+ 1 row in set (0.00 sec) If I remember correctly the default plugin for mariaDB … Read more