wiki:other:change_root_password_mariadb
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;
systemctl unset-environment MYSQLD_OPTS systemctl restart mariadb mariadb -u root -p {NEW_PASSWORD}
wiki/other/change_root_password_mariadb.txt · Последнее изменение: — Diman