Различия

Показаны различия между двумя версиями страницы.

--- wiki:other:change_root_password_mariadb [2025/12/24 15:10] – создано Diman
+++ wiki:other:change_root_password_mariadb [2025/12/24 15:12] (текущий) – Diman
@@ Строка 1: / Строка 1: @@
 <code bash>
@@ Строка 14: / Строка 13: @@
 FLUSH PRIVILEGES;
-ALTER USER 'root'@'localhost' IDENTIFIED BY 'Ybkf7SzY3IU6sXe7-NEW_PASSWORD';
+ALTER USER 'root'@'localhost' IDENTIFIED BY '-NEW_PASSWORD';
-UPDATE mysql.user SET authentication_string = 'Ybkf7SzY3IU6sXe7-NEW_PASSWORD' WHERE user = 'root';
+UPDATE mysql.user SET authentication_string = '-NEW_PASSWORD' WHERE user = 'root';
 FLUSH PRIVILEGES;
 </code>
+<code bash>
+systemctl unset-environment MYSQLD_OPTS
+systemctl restart mariadb
+mariadb -u root -p {NEW_PASSWORD}
 </code>