MySQL / MariaDB login without SUDO

shell.md

$ > sudo mysql -uroot

mysql > SELECT User, Host FROM mysql.user;

mysql > DROP USER 'root'@'localhost';

mysql > CREATE USER 'root'@'localhost' IDENTIFIED BY 'STRING-PASSWORD-NYA';

mysql > GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;

mysql > FLUSH PRIVILEGES;

mysql > exit

$ > mysql -uroot

Thanks for sharing it worked for me in Maria DB 10.1.44

If you want access without password you can skip drop ... and create ... steps