GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY '<PW>';
FLUSH ALL PRIVILEGES;

sudo /usr/bin/mysql_secure_installation

sudo mysqld_safe --skip-grant-tables

sudo mysql -u root -p

sudo su -
mysql -u root -p

GRANT ALL PRIVILEGES on *.* to 'root'@'localhost' IDENTIFIED BY '<password>';
GRANT ALL PRIVILEGES on *.* to 'root'@'localhost' IDENTIFIED BY '<password>';
FLUSH PRIVILEGES;

UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root' AND plugin = 'unix_socket';
FLUSH PRIVILEGES;

sudo service mysql stop
sudo service mysql start

sudo mysql -u root

use mysql
CREATE USER 'user'@'localhost' IDENTIFIED BY 'yourpassword'
q

mysql-workbench

$ sudo su
[sudo] password for user: yourubunturootpassword
# mysql -r root -p
Enter password: yourmariadbrootpassword

sudo mysql_secure_installation