How To Retrieve or Reset the Root MySQL Password

<div dir="ltr" style="text-align: left;" trbidi="on"> <h1 class="entry-title" style="background-color: white; border: 0px; box-sizing: inherit; font-family: proxima-nova, sans-serif; line-height: 3.4rem; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> <span style="color: #990000; font-size: large;"><u>Retrieve or Reset the Root MySQL Password</u></span></h1> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">MySQL AB was a software company that was founded in 1995. It was acquired by Sun Microsystems in 2008; Sun was in turn acquired by Oracle Corporation in 2010.</span></span></div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">This is a quick tutorial how to reset your <a href="http://www.hackthesec.co.in/search/label/Mysql_Database">MySQL</a> root password. It does require root access on your server. </span></span></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5sGSkdiY6rimv0IB8iREbyy1vyE5VOacsLnlh5LPLdoInHSPOaxVR6h0TApVBc3Zh5ovP0Cfr-XsJn1tFthuOYMnwyYupGoPn3zjvrfrowqAwqbs32Qj4qTAIiFnKjAM7v6E7TLETS7el/s1600/reset-mysql-root-password-www.hackthesec.co.in.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5sGSkdiY6rimv0IB8iREbyy1vyE5VOacsLnlh5LPLdoInHSPOaxVR6h0TApVBc3Zh5ovP0Cfr-XsJn1tFthuOYMnwyYupGoPn3zjvrfrowqAwqbs32Qj4qTAIiFnKjAM7v6E7TLETS7el/s1600/reset-mysql-root-password-www.hackthesec.co.in.jpg" /></a></div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span></div> <div> <span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>Step #1</u></b></span></span></div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Stop MySQL:</span></span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;">service mysql stop</span></span></pre> </div> <div> <b style="color: #0b5394; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;"><u>Step #2</u></b></div> <div> <span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Start MySQL in single-user mode, bypassing password authorization, by pasting in the command below (the ampersand is required):</span></span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;">mysqld_safe --skip-grant-tables &</span></span></pre> </div> <div> <b style="color: #0b5394; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;"><u>Step #3</u></b></div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Now type "mysql" to connect:</span></span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;">mysql</span></span></pre> </div> <div> <b style="color: #0b5394; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;"><u>Step #4</u></b></div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">At the mysql prompt, change the root password using the following three commands:</span></span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;">UPDATE mysql.user SET password=password("YourNewStrongPassword") WHERE user='root'; FLUSH PRIVILEGES; exit;</span></span></pre> </div> <div> <b style="color: #0b5394; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;"><u>Step #4</u></b></div> <div> <span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Now stop MySQL and start it in normal mode:</span></span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;">service mysql stop service mysql start</span></span></pre> </div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><div> <b style="color: #0b5394;"><u>Step #5</u></b></div> <div> Verify that you are able to connect to MySQL by entering "mysql".</div> </span></span><span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><div> <b style="color: #0b5394;"><u>Step #6</u></b></div> <div> Finally, update the MySQL root password in<b> /etc/.my.cnf</b> to match the new value. You can use vi, vim or nano:</div> </span></span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;">vi /root/.my.cnf</span></span></pre> </div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>Recovering the Root MySQL Password on a cPanel server</u></b></span></span></div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">The root <a href="http://www.hackthesec.co.in/search/label/Mysql">MySQL</a> credentials are stored locally in a file that only the root user can access. After you’ve connected to the server as root via <a href="http://www.hackthesec.co.in/search/label/SSH">SSH</a>, you can view the credentials by running the following command:</span></span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;">cat /root/.my.cnf</span></span></pre> </div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">That should output a result containing the MySQL password, which will appear similar to the following:</span></span></div> <div> <pre class="xtypo_info" style="background: url("assets/shadow.png") 50% 100% repeat-x rgb(245, 245, 245); border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-shadow: rgb(204, 204, 204) 0px 0px 3px; box-sizing: border-box; font-stretch: normal; margin-bottom: 10px; overflow: auto; padding: 9.5px; tab-size: 4; text-shadow: rgb(255, 255, 255) 0px 1px 0px; word-break: break-all; word-wrap: break-word;"><span style="color: #333333; font-family: menlo, monaco, consolas, courier new, monospace; font-size: large;"><span style="line-height: 18.5714px; white-space: pre-wrap;">[root@host ~]# cat /root/.my.cnf [client] password=#@hackthesec user=root</span></span></pre> <pre class="xtypo_info" style="background: url("assets/shadow.png") 50% 100% repeat-x rgb(245, 245, 245); border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-shadow: rgb(204, 204, 204) 0px 0px 3px; box-sizing: border-box; font-stretch: normal; margin-bottom: 10px; overflow: auto; padding: 9.5px; tab-size: 4; text-shadow: rgb(255, 255, 255) 0px 1px 0px; word-break: break-all; word-wrap: break-word;"><span style="color: #333333; font-family: menlo, monaco, consolas, courier new, monospace;"><span style="font-size: 12px; line-height: 18.5714px; white-space: pre-wrap;"><a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a> <a href="https://www.twitter.com/Hackthesecurity">https://www.twitter.com/Hackthesecurity</a> <a href="http://facebook.com/htsecu">http://facebook.com/htsecu</a> <a href="http://feeds.hackthesec.co.in/hackthesec">http://feeds.hackthesec.co.in/hackthesec</a></span></span></pre> </div> </div>

How To Retrieve or Reset the Root MySQL Password

Retrieve or Reset the Root MySQL Password MySQL AB was a software company that was founded in 1995. It was acquired by Sun Microsystems ...

Read more »