Starting with MariaDB 10.4 (released in June 2019), you can use the OR keyword with IDENTIFIED VIA to allow any-of several authentication methods: CREATE OR ALTER USER `minecraft` IDENTIFIED VIA unix_socket OR mysql_native_password USING PASSWORD("s3cr3tpasswvrd"); Even if your OS vendor kinda sucks at providing updates, MariaDB provides an official repository serving at least this version to distributions as old as Ubuntu 14.04, CentOS & RHEL 6, Debian 7, and Fedora 28 …
Reset WordPress password via SQL
mysql -u root ← SELECT wordpress; UPDATE `wp_users` SET `user_pass` = MD5( 'correct horse battery staple' ) WHERE `wp_users`.`user_login` = "wp-admin";