{"id":5279,"date":"2020-08-12T17:31:05","date_gmt":"2020-08-12T12:01:05","guid":{"rendered":"https:\/\/www.skynats.com\/?p=5279"},"modified":"2020-08-12T17:31:05","modified_gmt":"2020-08-12T12:01:05","slug":"how-to-reset-mysql-root-password-in-centos-7","status":"publish","type":"post","link":"https:\/\/www.skynats.com\/blog\/how-to-reset-mysql-root-password-in-centos-7\/","title":{"rendered":"How to Reset MySQL root password in Centos 7"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/www.mysql.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL<\/a> Is an open-source Relational Database Management System (RDMS). It uses tables, triggers, variables, views, etc. <a href=\"https:\/\/mariadb.org\/\" target=\"_blank\" rel=\"noreferrer noopener\">MariaDB<\/a> is a fork of MySQL. The database structures and indexes of MariaDB are same as the MySQL. This blog covers the steps to reset MySQL root password without any data loss.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here in <a href=\"https:\/\/www.skynats.com\/blog\/\" target=\"_blank\" rel=\"noreferrer noopener\">Skynats<\/a>, we had done so many mysql root password reset without any data losses under our <strong><span style=\"color:#ed6c0a\" class=\"has-inline-color\"><a href=\"https:\/\/www.skynats.com\/linux-server-management\/\" target=\"_blank\" rel=\"noreferrer noopener\">server management<\/a><\/span> <\/strong>service.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><span class=\"has-inline-color has-vivid-cyan-blue-color\">Reset root password in Safe Mode<\/span><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Check MySQL or MariaDB version<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql --version\nmysql  Ver 15.1 Distrib 10.3.22-MariaDB, for Linux (x86_64) using readline 5.1<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Stop MySQL\/MariaDB service<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>systemctl stop mariadb<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Then start MySQL\/MariaDB in safe mode without loading the privileges<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqld_safe --skip-grant-tables --skip-networking &amp;\n\n200306 10:56:59 mysqld_safe Logging to '\/var\/lib\/mysql\/mysqltest.err'.\n200306 10:56:59 mysqld_safe Starting mysqld daemon with databases from \/var\/lib\/mysql\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Then connect MySQL\/MariaDB as root and run change password query\/command<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql -u root -p\n\nMariaDB &#91;(none)]> FLUSH PRIVILEGES;\nMariaDB &#91;(none)]>  ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword';\nMariaDB &#91;(none)]> FLUSH PRIVILEGES;\nMariaDB &#91;(none)]> exit<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Next kill\/stop the MySQL\/MariaDB instance process id<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>kill $(cat \/var\/lib\/mysql\/mysqltest.pid )<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Start MySQL\/MariaDB in normal mode<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>systemctl start mariadb<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Now, Login as mysql root user with new password<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql -u root -p\n\nPassword:<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">You can able to login the MySQL\/MariaDB using new root password.<\/p>\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 website from Downtimes<\/strong><\/p><cite>Get our experts to manage your server with weekly auditing and 24\/7 monitoring<\/cite><div class=\"wp-block-button\"><a href=\"https:\/\/www.skynats.com\/linux-server-management\/\" class=\"wp-block-button__link\" style=\"color: white;margin-top: 10px;\">GET STARTED NOW<\/a><\/div><\/blockquote><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL Is an open-source Relational Database Management System (RDMS). It uses tables, triggers, variables, views, etc. MariaDB is a fork of MySQL. The database structures and indexes of MariaDB are same as the MySQL. This blog covers the steps to reset MySQL root password without any data loss. Here in Skynats, we had done so [&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":[124,125,46,126],"class_list":["post-5279","post","type-post","status-publish","format-standard","hentry","category-blog","category-server-management","tag-mariadb-root-password","tag-mariadb-server","tag-mysql-server","tag-root-password-reset"],"_links":{"self":[{"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/posts\/5279","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=5279"}],"version-history":[{"count":0,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/posts\/5279\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/media?parent=5279"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/categories?post=5279"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/tags?post=5279"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}