2024-03-24

when forget root password of mariadb

sudo systemctl stop mariadb

sudo mysqld_safe --skip-grant-tables --skip-networking &

mysql -u root

MariaDB [(none)]> FLUSH PRIVILEGES;

ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';