mysqld_safe --skip-grant-tables --skip-networking &
 
mysql -u root

FLUSH PRIVILEGES;
 
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('xxxxxxxxxxxx');

How To Reset Your MySQL or MariaDB Root Password _ DigitalOcean Archive du 20/12/2016 le 29/04/2020