{"id":5435,"date":"2020-09-29T16:39:58","date_gmt":"2020-09-29T11:09:58","guid":{"rendered":"https:\/\/www.skynats.com\/?p=5435"},"modified":"2025-10-30T12:06:51","modified_gmt":"2025-10-30T06:36:51","slug":"reset-mariadb-root-password-in-centos-8","status":"publish","type":"post","link":"https:\/\/www.skynats.com\/blog\/reset-mariadb-root-password-in-centos-8\/","title":{"rendered":"Reset MariaDB root password in Centos 8"},"content":{"rendered":"\n<p id=\"bkmrk-if-we-forgotten-the-\">If you lost the MariaDB root password on your centos 8 server, there is no need to worry about it. You can follow the below steps to reset mariadb password in centos 8. <\/p>\n\n\n\n<p>On our <a href=\"https:\/\/www.skynats.com\/hourly-server-support-services\/\" target=\"_blank\" rel=\"noreferrer noopener\"><span class=\"has-inline-color has-vivid-red-color\">server management plans<\/span><\/a>, our experts will help you to reset the password without any data losses safely. You can check with our team at any time for emergency support.<\/p>\n\n\n\n<p id=\"bkmrk-at-first-you-have-to\">At first you have to find the version of MariaDB by using following command<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql --version<\/pre>\n\n\n\n<p id=\"bkmrk-then-you-should-stop\">Then you should stop the currently running MariaDB server by:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">systemctl stop mariadb<\/pre>\n\n\n\n<p id=\"bkmrk-if-you-run-mysql-or-\">If you run MariaDB without loading information about the user privileges. This will allow you to access the database command line with the root privileges without providing the root password.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo mysqld_safe --skip-grant-tables --skip-networking &amp;<\/pre>\n\n\n\n<p id=\"bkmrk-now-you-can-able-to-\">Now you can able to access the MariaDB prompt with root privileges without using the password.1<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql -u root<\/pre>\n\n\n\n<p id=\"bkmrk-the-most-commonly-us\">The most commonly using ALTER USER command to change root user password may not be supported in some versions of MariaDB. It&#8217;s because of grant tables are not loaded. We can reload the grant tables by issuing the following command.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">MariaDB &gt;  FLUSH PRIVILEGES;<\/pre>\n\n\n\n<p id=\"bkmrk-if-you-are-using-the\">If you are using newer MariaDB 10.1.20 and newer you can use the following command.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">MariaDB [(none)]&gt; ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';<\/pre>\n\n\n\n<p id=\"bkmrk-for-mysql-5.7.5-and-\">For older version of MariaDB, you can use the following command.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SET PASSWORD FOR 'root'@'localhost' = PASSWORD ('new_password');<\/pre>\n\n\n\n<p id=\"bkmrk-make-sure-to-replace\">Make sure to replace the new_password with the strong one.<\/p>\n\n\n\n<p id=\"bkmrk-if-the-alter-user-co\">If the ALTER USER command doesn&#8217;t work , then you can try with the below command.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">UPDATE mysql.user SET authentication_string = PASSWORD ('new_password') WHERE USER = 'root' AND HOST = 'localhost';<\/pre>\n\n\n\n<p id=\"bkmrk-after-this-you-shoul\">After this you should remember to reload the grant tables by using FLUSH PRIVILEGES command.<\/p>\n\n\n\n<p id=\"bkmrk-then-you-have-to-kil\">Then you have to kill the currently running mysql_safe PID.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">netstat -tlnp | grep mysqld<\/pre>\n\n\n\n<p id=\"bkmrk-then-you-can-find-th\">Then you can find the PID of currently running MariaDB process.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">kill -9 PID<\/pre>\n\n\n\n<p id=\"bkmrk-replace-the-pid-with\">Replace the PID with your PID of MariaDB process.<\/p>\n\n\n\n<p id=\"bkmrk-then-start-the-maria\">Then start the MariaDB by using the below command<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">systemctl start mariadb<\/pre>\n\n\n\n<p>MariaDB<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql -u root -p<\/pre>\n\n\n\n<figure class=\"wp-block-pullquote is-style-default\"><blockquote class=\"has-text-color has-vivid-red-color\"><p><strong>Prevent your websites from downtimes<\/strong><\/p><cite>Get our experts to provide 24&#215;7 emergency support for crash recovery<\/cite><div class=\"wp-block-button\"><a href=\"https:\/\/www.skynats.com\/hourly-server-support-services\/\" class=\"wp-block-button__link\" style=\"color: white;margin-top: 10px;\">GET STARTED NOW<\/a><\/div><\/blockquote><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>If you lost the MariaDB root password on your centos 8 server, there is no need to worry about it. You can follow the below steps to reset mariadb password in centos 8. On our server management plans, our experts will help you to reset the password without any data losses safely. You can check [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,68],"tags":[146,124,126],"class_list":["post-5435","post","type-post","status-publish","format-standard","hentry","category-blog","category-server-management","tag-mariadb-mysql-password-lost","tag-mariadb-root-password","tag-root-password-reset"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.9 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Reset MariaDB root password in Centos 8 | Skynats<\/title>\n<meta name=\"description\" content=\"Reset your MariaDB root password in CentOS 8 with this easy guide. Regain access fast \u2014 follow our step-by-step tutorial now!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.skynats.com\/blog\/reset-mariadb-root-password-in-centos-8\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Reset MariaDB root password in Centos 8\" \/>\n<meta property=\"og:description\" content=\"Reset your MariaDB root password in CentOS 8 with this easy guide. Regain access fast \u2014 follow our step-by-step tutorial now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.skynats.com\/blog\/reset-mariadb-root-password-in-centos-8\/\" \/>\n<meta property=\"og:site_name\" content=\"Server Management Services | Cloud Management | Skynats\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/skynats\" \/>\n<meta property=\"article:published_time\" content=\"2020-09-29T11:09:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-30T06:36:51+00:00\" \/>\n<meta name=\"author\" content=\"Pooja V\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@skynatstech\" \/>\n<meta name=\"twitter:site\" content=\"@skynatstech\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Pooja V\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/reset-mariadb-root-password-in-centos-8\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/reset-mariadb-root-password-in-centos-8\\\/\"},\"author\":{\"name\":\"Pooja V\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#\\\/schema\\\/person\\\/030d5856dd5166055eecc07218d2455e\"},\"headline\":\"Reset MariaDB root password in Centos 8\",\"datePublished\":\"2020-09-29T11:09:58+00:00\",\"dateModified\":\"2025-10-30T06:36:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/reset-mariadb-root-password-in-centos-8\\\/\"},\"wordCount\":306,\"publisher\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#organization\"},\"keywords\":[\"mariadb mysql password lost\",\"mariadb root password\",\"root password reset\"],\"articleSection\":[\"Blog\",\"server management\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/reset-mariadb-root-password-in-centos-8\\\/\",\"url\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/reset-mariadb-root-password-in-centos-8\\\/\",\"name\":\"Reset MariaDB root password in Centos 8 | Skynats\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#website\"},\"datePublished\":\"2020-09-29T11:09:58+00:00\",\"dateModified\":\"2025-10-30T06:36:51+00:00\",\"description\":\"Reset your MariaDB root password in CentOS 8 with this easy guide. Regain access fast \u2014 follow our step-by-step tutorial now!\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/reset-mariadb-root-password-in-centos-8\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.skynats.com\\\/blog\\\/reset-mariadb-root-password-in-centos-8\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/reset-mariadb-root-password-in-centos-8\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Reset MariaDB root password in Centos 8\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/\",\"name\":\"Server Management Services | Cloud Management | Skynats\",\"description\":\"Server Management and Cloud Management\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#organization\",\"name\":\"Skynats Technologies\",\"url\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Sknats-Logo-New-whole.png\",\"contentUrl\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Sknats-Logo-New-whole.png\",\"width\":989,\"height\":367,\"caption\":\"Skynats Technologies\"},\"image\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/skynats\",\"https:\\\/\\\/x.com\\\/skynatstech\",\"https:\\\/\\\/www.instagram.com\\\/skynatstech\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/skynats-technologies\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCvTAjrFJ4_E2MJKwlDHomlg\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#\\\/schema\\\/person\\\/030d5856dd5166055eecc07218d2455e\",\"name\":\"Pooja V\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/acf2642637f84bdab7ffece47787a6a4ee655dab6404beac2a1a33db563041c4?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/acf2642637f84bdab7ffece47787a6a4ee655dab6404beac2a1a33db563041c4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/acf2642637f84bdab7ffece47787a6a4ee655dab6404beac2a1a33db563041c4?s=96&d=mm&r=g\",\"caption\":\"Pooja V\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Reset MariaDB root password in Centos 8 | Skynats","description":"Reset your MariaDB root password in CentOS 8 with this easy guide. Regain access fast \u2014 follow our step-by-step tutorial now!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.skynats.com\/blog\/reset-mariadb-root-password-in-centos-8\/","og_locale":"en_US","og_type":"article","og_title":"Reset MariaDB root password in Centos 8","og_description":"Reset your MariaDB root password in CentOS 8 with this easy guide. Regain access fast \u2014 follow our step-by-step tutorial now!","og_url":"https:\/\/www.skynats.com\/blog\/reset-mariadb-root-password-in-centos-8\/","og_site_name":"Server Management Services | Cloud Management | Skynats","article_publisher":"https:\/\/www.facebook.com\/skynats","article_published_time":"2020-09-29T11:09:58+00:00","article_modified_time":"2025-10-30T06:36:51+00:00","author":"Pooja V","twitter_card":"summary_large_image","twitter_creator":"@skynatstech","twitter_site":"@skynatstech","twitter_misc":{"Written by":"Pooja V","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.skynats.com\/blog\/reset-mariadb-root-password-in-centos-8\/#article","isPartOf":{"@id":"https:\/\/www.skynats.com\/blog\/reset-mariadb-root-password-in-centos-8\/"},"author":{"name":"Pooja V","@id":"https:\/\/www.skynats.com\/blog\/#\/schema\/person\/030d5856dd5166055eecc07218d2455e"},"headline":"Reset MariaDB root password in Centos 8","datePublished":"2020-09-29T11:09:58+00:00","dateModified":"2025-10-30T06:36:51+00:00","mainEntityOfPage":{"@id":"https:\/\/www.skynats.com\/blog\/reset-mariadb-root-password-in-centos-8\/"},"wordCount":306,"publisher":{"@id":"https:\/\/www.skynats.com\/blog\/#organization"},"keywords":["mariadb mysql password lost","mariadb root password","root password reset"],"articleSection":["Blog","server management"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.skynats.com\/blog\/reset-mariadb-root-password-in-centos-8\/","url":"https:\/\/www.skynats.com\/blog\/reset-mariadb-root-password-in-centos-8\/","name":"Reset MariaDB root password in Centos 8 | Skynats","isPartOf":{"@id":"https:\/\/www.skynats.com\/blog\/#website"},"datePublished":"2020-09-29T11:09:58+00:00","dateModified":"2025-10-30T06:36:51+00:00","description":"Reset your MariaDB root password in CentOS 8 with this easy guide. Regain access fast \u2014 follow our step-by-step tutorial now!","breadcrumb":{"@id":"https:\/\/www.skynats.com\/blog\/reset-mariadb-root-password-in-centos-8\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.skynats.com\/blog\/reset-mariadb-root-password-in-centos-8\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.skynats.com\/blog\/reset-mariadb-root-password-in-centos-8\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.skynats.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Reset MariaDB root password in Centos 8"}]},{"@type":"WebSite","@id":"https:\/\/www.skynats.com\/blog\/#website","url":"https:\/\/www.skynats.com\/blog\/","name":"Server Management Services | Cloud Management | Skynats","description":"Server Management and Cloud Management","publisher":{"@id":"https:\/\/www.skynats.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.skynats.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.skynats.com\/blog\/#organization","name":"Skynats Technologies","url":"https:\/\/www.skynats.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.skynats.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.skynats.com\/blog\/wp-content\/uploads\/2021\/08\/Sknats-Logo-New-whole.png","contentUrl":"https:\/\/www.skynats.com\/blog\/wp-content\/uploads\/2021\/08\/Sknats-Logo-New-whole.png","width":989,"height":367,"caption":"Skynats Technologies"},"image":{"@id":"https:\/\/www.skynats.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/skynats","https:\/\/x.com\/skynatstech","https:\/\/www.instagram.com\/skynatstech\/","https:\/\/www.linkedin.com\/company\/skynats-technologies","https:\/\/www.youtube.com\/channel\/UCvTAjrFJ4_E2MJKwlDHomlg"]},{"@type":"Person","@id":"https:\/\/www.skynats.com\/blog\/#\/schema\/person\/030d5856dd5166055eecc07218d2455e","name":"Pooja V","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/acf2642637f84bdab7ffece47787a6a4ee655dab6404beac2a1a33db563041c4?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/acf2642637f84bdab7ffece47787a6a4ee655dab6404beac2a1a33db563041c4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/acf2642637f84bdab7ffece47787a6a4ee655dab6404beac2a1a33db563041c4?s=96&d=mm&r=g","caption":"Pooja V"}}]}},"_links":{"self":[{"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/posts\/5435","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/comments?post=5435"}],"version-history":[{"count":4,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/posts\/5435\/revisions"}],"predecessor-version":[{"id":16511,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/posts\/5435\/revisions\/16511"}],"wp:attachment":[{"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/media?parent=5435"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/categories?post=5435"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/tags?post=5435"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}