https://briansnelson.com/index.php?action=history&feed=atom&title=How_to_Set_your_MySQL_Password 2026-06-04T12:28:01Z Revision history for this page on the wiki MediaWiki 1.24.1 https://briansnelson.com/index.php?title=How_to_Set_your_MySQL_Password&diff=543&oldid=prev 2014-03-12T18:02:48Z

<p>‎<span dir="auto"><span class="autocomment">Set root password</span></span></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;'> <td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td> <td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 18:02, 12 March 2014</td> </tr><tr><td colspan="2" class="diff-lineno">Line 5:</td> <td colspan="2" class="diff-lineno">Line 5:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>===Set root password===</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>===Set root password===</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Make sure to start Percona</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Make sure to start Percona<ins class="diffchange diffchange-inline">/Mysql</ins></div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; service mysql start</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; service mysql start</div></td></tr> <!-- diff cache key briansne_wiki-wiki_:diff:version:1.11a:oldid:542:newid:543 --> </table>

Brian https://briansnelson.com/index.php?title=How_to_Set_your_MySQL_Password&diff=542&oldid=prev 2014-03-12T18:02:33Z

<p>Created page with &quot;==How to Set your MySQL Password== One of the first things you should do on any MySQL install is set the root password. If you do not set the password anyone that gains acce...&quot;</p> <p><b>New page</b></p><div>==How to Set your MySQL Password==<br /> <br /> One of the first things you should do on any MySQL install is set the root password. If you do not set the password anyone that gains access to your system will have access to everything in the database.<br /> <br /> ===Set root password===<br /> <br /> Make sure to start Percona<br /> <br /> service mysql start<br /> <br /> Log into mysql and check the users<br /> <br /> mysql -u root<br /> <br /> SELECT User, Host, Password FROM mysql.user;<br /> <br /> Now set the root passwords<br /> <br /> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('briansnelson');<br /> SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('briansnelson');<br /> SET PASSWORD FOR 'root'@'localhost.localdomain' = PASSWORD('briansnelson');<br /> <br /> FLUSH PRIVILEGES;</div>

Brian