=====Reset root password=====
<code bash>
mysqld_safe --skip-grant-tables --skip-networking &

mysql -u root
</code>

<code sql>
FLUSH PRIVILEGES;

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('xxxxxxxxxxxx');
</code>

[[https://www.digitalocean.com/community/tutorials/how-to-reset-your-mysql-or-mariadb-root-password|How To Reset Your MySQL or MariaDB Root Password _ DigitalOcean]] {{ :prog:mariadb:how_to_reset_your_mysql_or_mariadb_root_password_digitalocean_2020-04-29_8_18_27_pm_.html |Archive du 20/12/2016 le 29/04/2020}}