MariaDB – set root password and activate authentication


https://0049am.wordpress.com/2018/07/10/mariadb-set-root-password-and-activate-authentication/

root@server:/# mysql -u root -p  
MariaDB [(none)]> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('NEWPASSWORD');  
MariaDB [(none)]> UPDATE mysql.user SET plugin = '' WHERE user = 'root' AND host = 'localhost';  
MariaDB [(none)]> FLUSH PRIVILEGES;