wiki.vps-server.ru

Это старая версия документа!

---

systemctl stop mariadb
 
systemctl set-environment MYSQLD_OPTS="--skip-grant-tables --skip-networking"
 
systemctl start mariadb

FLUSH PRIVILEGES;
 
ALTER USER 'root'@'localhost' IDENTIFIED BY '-NEW_PASSWORD';
UPDATE mysql.user SET authentication_string = '-NEW_PASSWORD' WHERE user = 'root';
 
FLUSH PRIVILEGES;