https://wiki.itcollege.ee/index.php?action=history&feed=atom&title=Mysql_parooli_reset 2026-05-06T05:45:22Z Revision history for this page on the wiki MediaWiki 1.45.1 https://wiki.itcollege.ee/index.php?title=Mysql_parooli_reset&diff=341&oldid=prev 2009-09-28T12:29:26Z

<p><span class="autocomment">Kui unustasid MySQLi administraatori parooli</span></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 15:29, 28 September 2009</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l24">Line 24:</td> <td colspan="2" class="diff-lineno">Line 24:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Lõpetuseks startida mysql &lt;pre&gt; /etc/init.d/mysql start &lt;/pre&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Lõpetuseks startida mysql &lt;pre&gt; /etc/init.d/mysql start &lt;/pre&gt;</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; 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><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; 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><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; 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><ins style="font-weight: bold; text-decoration: none;">[[Category:IT infrastruktuuri teenused]]</ins></div></td></tr> <!-- diff cache key ico_mediawiki-ITK_:diff:1.41:old-340:rev-341:php=table --> </table>

Kkarma https://wiki.itcollege.ee/index.php?title=Mysql_parooli_reset&diff=340&oldid=prev 2009-09-28T12:24:44Z

<p><span class="autocomment">Kui unustasid MySQLi administraatori parooli</span></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 15:24, 28 September 2009</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Kui unustasid MySQLi administraatori parooli=</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Kui unustasid MySQLi administraatori parooli=</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; 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><del style="font-weight: bold; text-decoration: none;">1SeiskaMySQL </del>Server.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; 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><ins style="font-weight: bold; text-decoration: none;">1.SeiskaMySQL </ins>Server.</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;pre&gt; sudo /etc/init.d/mysql stop &lt;/pre&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;pre&gt; sudo /etc/init.d/mysql stop &lt;/pre&gt;</div></td></tr> <!-- diff cache key ico_mediawiki-ITK_:diff:1.41:old-338:rev-340:php=table --> </table>

Kkarma https://wiki.itcollege.ee/index.php?title=Mysql_parooli_reset&diff=338&oldid=prev 2009-09-28T12:23:51Z

<p>New page: =Kui unustasid MySQLi administraatori parooli= 1SeiskaMySQL Server. &lt;pre&gt; sudo /etc/init.d/mysql stop &lt;/pre&gt; 2.Käita MySQL võtmega &#039;--skip-grant-tables&#039;, siis pannakse MySQL käima ilm...</p> <p><b>New page</b></p><div>=Kui unustasid MySQLi administraatori parooli=<br /> 1SeiskaMySQL Server.<br /> <br /> &lt;pre&gt; sudo /etc/init.d/mysql stop &lt;/pre&gt;<br /> <br /> 2.Käita MySQL võtmega &#039;--skip-grant-tables&#039;, siis pannakse MySQL käima ilma õigustesüsteemita!<br /> <br /> &lt;pre&gt;sudo mysqld --skip-grant-tables &amp; &lt;/pre&gt;<br /> <br /> 3.Sisene root kasutajana.<br /> <br /> &lt;pre&gt;mysql -u root mysql &lt;/pre&gt;<br /> <br /> 4.Asenda YOURNEWPASSWORD soovitava parooliga, muud muuta pole vaja!<br /> MySQL promti sisesta järgmised käsud:<br /> <br /> &lt;pre&gt;UPDATE user SET Password=PASSWORD(&#039;YOURNEWPASSWORD&#039;) WHERE User=&#039;root&#039;; &lt;/pre&gt;<br /> <br /> &lt;pre&gt;FLUSH PRIVILEGES; &lt;/pre&gt;<br /> <br /> &lt;pre&gt;exit; &lt;/pre&gt;<br /> <br /> Seejärel tuleb MySQL server killida abiks on käsk &lt;pre&gt;sudo killall mysqld &lt;/pre&gt;<br /> <br /> Lõpetuseks startida mysql &lt;pre&gt; /etc/init.d/mysql start &lt;/pre&gt;</div>

Kkarma