-
Notifications
You must be signed in to change notification settings - Fork 10
how to reset mariadb root password
vr-greycube edited this page Feb 5, 2023
·
1 revision
https://www.digitalocean.com/community/tutorials/how-to-reset-your-mysql-or-mariadb-root-password
sudo systemctl stop mariadb
sudo mysqld_safe --skip-grant-tables --skip-networking &
mysql -u root
FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
sudo kill `cat /var/run/mysqld/mysqld.pid`