{"id":1542,"date":"2020-08-31T23:00:00","date_gmt":"2020-08-31T19:30:00","guid":{"rendered":"https:\/\/parsdev.com\/wpblog\/recover-root-mariadb\/"},"modified":"2025-07-28T08:54:27","modified_gmt":"2025-07-28T05:24:27","slug":"recover-root-mariadb","status":"publish","type":"post","link":"https:\/\/parsdev.com/blog\/recover-root-mariadb\/","title":{"rendered":"\u0631\u06cc\u0633\u062a \u06a9\u0631\u062f\u0646 \u0631\u0645\u0632 \u0631\u0648\u062a Mariadb"},"content":{"rendered":"<p>\u0627\u06af\u0631 \u0634\u0645\u0627 \u0631\u0645\u0632 \u0631\u0648\u062a <span dir=\"LTR\">Mariadb<\/span><span dir=\"RTL\"><\/span><span dir=\"RTL\"><\/span><span dir=\"RTL\"><\/span><span dir=\"RTL\"><\/span> \u0631\u0627 \u0641\u0631\u0627\u0645\u0648\u0634 \u06a9\u0631\u062f\u06cc\u062f \u0646\u0627\u0631\u0627\u062d\u062a \u0648 \u0646\u06af\u0631\u0627\u0646 \u0646\u0634\u0648\u06cc\u062f. \u0628\u0627 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0628\u0647 \u0631\u0627\u062d\u062a\u06cc \u0645\u06cc&zwnj;\u062a\u0648\u0627\u0646\u06cc\u062f \u0631\u0645\u0632 \u0631\u0627 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u06a9\u0646\u06cc\u062f.<\/p>\n<p dir=\"RTL\">\u200b<\/p>\n<ul>\n<li dir=\"RTL\" value=\"NaN\"><span dir=\"RTL\"><\/span>\u0633\u0631\u0648\u0631 <span dir=\"LTR\">Mariadb<\/span><span dir=\"RTL\"><\/span><span dir=\"RTL\"><\/span><span dir=\"RTL\"><\/span><span dir=\"RTL\"><\/span> \u0641\u0639\u0644\u06cc \u0631\u0627 \u0645\u062a\u0648\u0642\u0641 \u06a9\u0646\u06cc\u062f \u0648 \u0628\u0627 \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0622\u0646 \u0631\u0627 \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u06a9\u0646\u06cc\u062f \u0628\u0647 \u0637\u0648\u0631\u06cc \u06a9\u0647 \u0627\u0632 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u0646\u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f.<span dir=\"LTR\"><\/span><\/li>\n<\/ul>\n<pre class=\"highlight\" courier=\"\" dir=\"ltr\" new=\"\" style=\"margin-top: 0px; padding: 0px 0.4em; border: 1px solid rgb(221, 221, 221); font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 16px; line-height: inherit; font-family: Monaco, Menlo, Consolas, \">\r\n<code courier=\"\" new=\"\" style=\"margin: 0px; padding: 0px 0em; border: none; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: 13.6px; line-height: inherit; font-family: Monaco, Menlo, Consolas, \"><span class=\"nv\" style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(38, 139, 210) !important;\">$ <\/span><span class=\"nb\" style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(133, 153, 0) !important;\">sudo <\/span>systemctl stop mariadb\r\n <span class=\"nv\" style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(38, 139, 210) !important;\">$ <\/span><span class=\"nb\" style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(133, 153, 0) !important;\">sudo <\/span>mysqld_safe <span class=\"nt\" style=\"margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: bold !important; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline; color: rgb(38, 139, 210) !important;\">--skip-grant-tables<\/span> &amp;<\/code><\/pre>\n<ul>\n<li><span dir=\"RTL\"><\/span>\u200b\u0645\u062c\u062f\u062f\u0627 \u0628\u0627 \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0628\u0647 <span dir=\"LTR\">Mariadb<\/span><span dir=\"RTL\"><\/span><span dir=\"RTL\"><\/span><span dir=\"RTL\"><\/span><span dir=\"RTL\"><\/span> \u0645\u062a\u0635\u0644 \u0634\u0648\u06cc\u062f.<span dir=\"LTR\"><\/span><\/li>\n<\/ul>\n<pre class=\"highlight\" courier=\"\" dir=\"ltr\" new=\"\" style=\"white-space: pre; margin-top: 0px; padding: 0px 0.4em; border: 1px solid rgb(221, 221, 221); font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 16px; line-height: inherit; font-family: Monaco, Menlo, Consolas, \">\r\n<code courier=\"\" new=\"\" style=\"margin: 0px; padding: 0px 0em; border: none; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: 13.6px; line-height: inherit; font-family: Monaco, Menlo, Consolas, \"> <span class=\"nv\" style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(38, 139, 210) !important;\">$ <\/span>mysql <span class=\"nt\" style=\"margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline; font-weight: bold !important; color: rgb(38, 139, 210) !important;\">-u<\/span> root<\/code><\/pre>\n<ul>\n<li dir=\"ltr\" value=\"NaN\"><span dir=\"RTL\"><\/span>\u0628\u0627 \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u0631\u0627 \u0631\u06cc\u0633\u062a \u06a9\u0646\u06cc\u062f. \u062a\u0648\u062c\u0647 \u06a9\u0646\u06cc\u062f \u0628\u0647 \u062c\u0627\u06cc \u0648\u0627\u0698\u0647 <span dir=\"LTR\">password<\/span><span dir=\"RTL\"><\/span><span dir=\"RTL\"><\/span><span dir=\"RTL\"><\/span><span dir=\"RTL\"><\/span> \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u0627\u0645\u0646 \u062e\u0648\u062f \u0631\u0627 \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f.<span dir=\"LTR\"><\/span><\/li>\n<\/ul>\n<pre class=\"highlight\" courier=\"\" dir=\"ltr\" new=\"\" style=\"margin-top: 0px; padding: 0px 0.4em; border: 1px solid rgb(221, 221, 221); font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 16px; line-height: inherit; font-family: Monaco, Menlo, Consolas, \">\r\n<code courier=\"\" new=\"\" style=\"margin: 0px; padding: 0px 0em; border: none; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: 13.6px; line-height: inherit; font-family: Monaco, Menlo, Consolas, \"> <span class=\"n\" style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(38, 139, 210) !important;\">use<\/span> <span class=\"n\" style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(38, 139, 210) !important;\">mysql<\/span><span class=\"p\" style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;\">;<\/span>\r\n <span class=\"k\" style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(203, 75, 22) !important;\">update<\/span> <span class=\"k\" style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(203, 75, 22) !important;\">user<\/span> <span class=\"k\" style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(203, 75, 22) !important;\">SET<\/span> <span class=\"n\" style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(38, 139, 210) !important;\">PASSWORD<\/span><span class=\"o\" style=\"margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline; font-weight: bold !important;\">=<\/span><span class=\"n\" style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(38, 139, 210) !important;\">PASSWORD<\/span><span class=\"p\" style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;\">(<\/span><span class=\"nv\" style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(38, 139, 210) !important;\">&quot;password&quot;<\/span><span class=\"p\" style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;\">)<\/span> <span class=\"k\" style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(203, 75, 22) !important;\">WHERE<\/span> <span class=\"k\" style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(203, 75, 22) !important;\">USER<\/span><span class=\"o\" style=\"margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline; font-weight: bold !important;\">=<\/span><span class=\"s1\" style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(42, 161, 152) !important;\">&#39;root&#39;<\/span><span class=\"p\" style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;\">;<\/span>\r\n <span class=\"n\" style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(38, 139, 210) !important;\">flush<\/span> <span class=\"k\" style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(203, 75, 22) !important;\">privileges<\/span><span class=\"p\" style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;\">;<\/span>\r\n <span class=\"n\" style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(38, 139, 210) !important;\">exit<\/span><\/code><\/pre>\n<ul>\n<li dir=\"RTL\" value=\"NaN\"><span dir=\"RTL\"><\/span>\u0633\u067e\u0633 <span dir=\"LTR\">Mariadb<\/span><span dir=\"RTL\"><\/span><span dir=\"RTL\"><\/span><span dir=\"RTL\"><\/span><span dir=\"RTL\"><\/span> \u0631\u0627 \u0631\u06cc\u0633\u062a\u0627\u0631\u062a \u06a9\u0646\u06cc\u062f.<span dir=\"LTR\"><\/span><\/li>\n<\/ul>\n<pre class=\"highlight\" courier=\"\" dir=\"ltr\" new=\"\" style=\"margin-top: 0px; padding: 0px 0.4em; border: 1px solid rgb(221, 221, 221); font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 16px; line-height: inherit; font-family: Monaco, Menlo, Consolas, \">\r\n<code courier=\"\" new=\"\" style=\"margin: 0px; padding: 0px 0em; border: none; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: 13.6px; line-height: inherit; font-family: Monaco, Menlo, Consolas, \"> <span class=\"nv\" style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(38, 139, 210) !important;\">$ <\/span><span class=\"nb\" style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(133, 153, 0) !important;\">sudo <\/span>systemctl start mariadb\r\n<\/code><\/pre>\n<div>&nbsp;<\/div>\n<p dir=\"RTL\">\u0645\u06cc&zwnj;\u0628\u06cc\u0646\u06cc\u062f \u06a9\u0647 \u0628\u0631\u0627\u062d\u062a\u06cc \u0631\u0645\u0632\u0639\u0628\u0648\u0631 \u0631\u06cc\u0633\u062a \u0634\u062f. \u062d\u0627\u0644\u0627 \u0634\u0645\u0627 \u0628\u0627\u06cc\u062f \u0628\u0627 \u0631\u0645\u0632 \u062c\u062f\u06cc\u062f \u062e\u0648\u062f \u0628\u062f\u0648\u0646 \u0647\u06cc\u0686 \u0645\u0634\u06a9\u0644\u06cc \u0628\u0647 \u0633\u0631\u0648\u0631 <span dir=\"LTR\">Mariadb<\/span><span dir=\"RTL\"><\/span><span dir=\"RTL\"><\/span><span dir=\"RTL\"><\/span><span dir=\"RTL\"><\/span> \u0645\u062a\u0635\u0644 \u0634\u0648\u06cc\u062f.<\/p>\n","protected":false},"excerpt":{"rendered":"\u0627\u06af\u0631 \u0634\u0645\u0627 \u0631\u0645\u0632 \u0631\u0648\u062a Mariadb \u0631\u0627 \u0641\u0631\u0627\u0645\u0648\u0634 \u06a9\u0631\u062f\u06cc\u062f \u0646\u0627\u0631\u0627\u062d\u062a \u0648 \u0646\u06af\u0631\u0627\u0646 \u0646\u0634\u0648\u06cc\u062f. \u0628\u0627 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0628\u0647 \u0631\u0627\u062d\u062a\u06cc \u0645\u06cc&zwnj;\u062a\u0648\u0627\u0646\u06cc\u062f&hellip;","protected":false},"author":1,"featured_media":1541,"comment_status":"open","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"csco_singular_sidebar":"","csco_page_header_type":"","csco_page_load_nextpost":"","footnotes":""},"categories":[3],"tags":[],"class_list":{"0":"post-1542","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-linux","8":"cs-entry"},"_links":{"self":[{"href":"https:\/\/parsdev.com/blog\/wp-json\/wp\/v2\/posts\/1542","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/parsdev.com/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/parsdev.com/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/parsdev.com/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/parsdev.com/blog\/wp-json\/wp\/v2\/comments?post=1542"}],"version-history":[{"count":5,"href":"https:\/\/parsdev.com/blog\/wp-json\/wp\/v2\/posts\/1542\/revisions"}],"predecessor-version":[{"id":6937,"href":"https:\/\/parsdev.com/blog\/wp-json\/wp\/v2\/posts\/1542\/revisions\/6937"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/parsdev.com/blog\/wp-json\/wp\/v2\/media\/1541"}],"wp:attachment":[{"href":"https:\/\/parsdev.com/blog\/wp-json\/wp\/v2\/media?parent=1542"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/parsdev.com/blog\/wp-json\/wp\/v2\/categories?post=1542"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/parsdev.com/blog\/wp-json\/wp\/v2\/tags?post=1542"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}