MariaDB 10.3 Access denied for user 'root'@'localhost' error

MariaDB 10.3 login error

 

$ mariadb -u root -p
Enter password: 
ERROR 1698 (28000): Access denied for user 'root'@'localhost'

 

$ sudo mariadb -u root -p

 (or sudo mysql -u root -p)

 

after login

 

MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'PassW0rd';
Query OK, 0 rows affected (0.001 sec)

 

MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.001 sec)

 

re-login

$ mariadb -u root -p

 

 

https://stackoverflow.com/questions/28068155/access-denied-for-user-rootlocalhost-using-password-yes-after-new-instal