This is an old revision of the document!

mariadb reenable password authentication

Disable unix socket authentication

update mysql.user set plugin='' where user='root';
flush privileges;

Update password

update mysql.user set password=password('yourpasswd') where user='root';

or run mysql_secure_installation from command line and set password.

Check

select user,host,password,plugin from mysql.user;
MariaDB [(none)]> select user,host,password,plugin from mysql.user;
+------+-----------+-------------------------------------------+--------+
| user | host      | password                                  | plugin |
+------+-----------+-------------------------------------------+--------+
| root | localhost | *C3F43AFF2CF6AACD60EE1AAB1B48ADB3066E0EA4 |        |
+------+-----------+-------------------------------------------+--------+

Tested on

Debian 10.8
10.3.27-MariaDB-0+deb10u1

References

https://kofler.info/root-login-problem-mit-mariadb/

antisaWiki

Table of Contents

mariadb reenable password authentication

Disable unix socket authentication

Update password

Check

Tested on

See also

References