MySQL Lost Password: Difference between revisions

no edit summary
mNo edit summary
No edit summary
Line 1: Line 1:
=[http://akekuqegify.co.cc UNDER COSTRUCTION, PLEASE SEE THIS POST IN RESERVE COPY]=
{{Uc nav mysql}}
{{Uc nav mysql}}
'''Lost Password'''
'''Lost Password'''
Line 5: Line 6:


On refreshing the page received this error message:
On refreshing the page received this error message:
  <nowiki>#</nowiki>1045 - Access denied for user 'root'@'localhost' (using password: YES)
  &lt;nowiki&gt;#&lt;/nowiki&gt;1045 - Access denied for user 'root'@'localhost' (using password: YES)


He then went into apanel used '''MySQL Server Configuration''' to set this new password and received the following error message:
He then went into apanel used '''MySQL Server Configuration''' to set this new password and received the following error message:
  Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost'  
  Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost'  
  (using password: YES) in W:\home\admin\www\mqsetup.php on line 46<br>Error connecting to mysql
  (using password: YES) in W:\home\admin\www\mqsetup.php on line 46&lt;br&gt;Error connecting to mysql


'''Not a real problem:'''
'''Not a real problem:'''
Line 42: Line 43:
The MySQL server requires restarting (from MySQL console) with skip grant table option set as follows:
The MySQL server requires restarting (from MySQL console) with skip grant table option set as follows:


# Start a command prompt: ('''Start''' > click on '''Run''' > type '''cmd''' click '''OK''')
# Start a command prompt: ('''Start''' &gt; click on '''Run''' &gt; type '''cmd''' click '''OK''')
# Type following lines into the command prompt:<br>'''W:'''<br>'''cd usr\local\mysql\bin'''<br>'''mysqld-opt --skip-grant-tables --user=root'''  ''Note: Do not copy and paste you must type it in.''
# Type following lines into the command prompt:&lt;br&gt;'''W:'''&lt;br&gt;'''cd usr\local\mysql\bin'''&lt;br&gt;'''mysqld-opt --skip-grant-tables --user=root'''  ''Note: Do not copy and paste you must type it in.''
# Note the flashing cursor indicating server is running. Minimise this window ('''do not close it''').
# Note the flashing cursor indicating server is running. Minimise this window ('''do not close it''').


Dialogue in the command prompt looks similar to this:
Dialogue in the command prompt looks similar to this:


<div style="background:#f0f0f0; border:1px solid #000000; padding-left:10px; width:60%">
&lt;div style=&quot;background:#f0f0f0; border:1px solid #000000; padding-left:10px; width:60%&quot;&gt;
Microsoft Windows XP [Version 5.1.2600]<br>
Microsoft Windows XP [Version 5.1.2600]&lt;br&gt;
(C) Copyright 1985-2001 Microsoft Corp.
(C) Copyright 1985-2001 Microsoft Corp.


C:\Documents and Settings\mpg>'''w:'''<br>
C:\Documents and Settings\mpg&gt;'''w:'''&lt;br&gt;
W:\>'''cd usr\local\mysql\bin'''<br>
W:\&gt;'''cd usr\local\mysql\bin'''&lt;br&gt;
W:\usr\local\mysql\bin>'''mysqld-opt --skip-grant-tables --user=root'''<br>
W:\usr\local\mysql\bin&gt;'''mysqld-opt --skip-grant-tables --user=root'''&lt;br&gt;
'''-'''
'''-'''
</div>
&lt;/div&gt;


=== Set Password and Update grant tables ===
=== Set Password and Update grant tables ===
Line 62: Line 63:
Start a second command prompt set new password (root) and update grand tables as follows:
Start a second command prompt set new password (root) and update grand tables as follows:


# Start a command prompt: (Start > click on Run > type cmd click OK)
# Start a command prompt: (Start &gt; click on Run &gt; type cmd click OK)
# Type following lines into the command prompt:<br>'''W:'''<br>'''cd usr\local\mysql\bin'''<br>'''mysql'''<br>'''USE mysql;'''<br>'''UPDATE user SET password=password("root") WHERE user="root";'''<br>'''flush privileges;'''<br>'''exit'''<br>
# Type following lines into the command prompt:&lt;br&gt;'''W:'''&lt;br&gt;'''cd usr\local\mysql\bin'''&lt;br&gt;'''mysql'''&lt;br&gt;'''USE mysql;'''&lt;br&gt;'''UPDATE user SET password=password(&quot;root&quot;) WHERE user=&quot;root&quot;;'''&lt;br&gt;'''flush privileges;'''&lt;br&gt;'''exit'''&lt;br&gt;
# That's it finished.
# That's it finished.


Dialogue in the command prompt looks similar to this:  
Dialogue in the command prompt looks similar to this:  


<div style="background:#f0f0f0; border:1px solid #000000; padding-left:10px; width:60%">
&lt;div style=&quot;background:#f0f0f0; border:1px solid #000000; padding-left:10px; width:60%&quot;&gt;
Microsoft Windows XP [Version 5.1.2600]
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
(C) Copyright 1985-2001 Microsoft Corp.


C:\Documents and Settings\mpg>'''w:'''<br>
C:\Documents and Settings\mpg&gt;'''w:'''&lt;br&gt;
W:\>'''cd usr\local\mysql\bin'''<br>
W:\&gt;'''cd usr\local\mysql\bin'''&lt;br&gt;
W:\usr\local\mysql\bin>'''mysql'''<br>
W:\usr\local\mysql\bin&gt;'''mysql'''&lt;br&gt;
Welcome to the MySQL monitor. Commands end with ; or \g.<br>
Welcome to the MySQL monitor. Commands end with ; or \g.&lt;br&gt;
Your MySQL connection id is 1<br>
Your MySQL connection id is 1&lt;br&gt;
Server version: 5.0.41-community-nt MySQL Community Edition (GPL)
Server version: 5.0.41-community-nt MySQL Community Edition (GPL)


Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.


mysql> '''USE mysql;'''<br>
mysql&gt; '''USE mysql;'''&lt;br&gt;
Database changed<br>
Database changed&lt;br&gt;
mysql> '''UPDATE user SET password=password("root") WHERE user="root";'''<br>
mysql&gt; '''UPDATE user SET password=password(&quot;root&quot;) WHERE user=&quot;root&quot;;'''&lt;br&gt;
Query OK, 1 row affected (0.11 sec)<br>
Query OK, 1 row affected (0.11 sec)&lt;br&gt;
Rows matched: 1 Changed: 1 Warnings: 0
Rows matched: 1 Changed: 1 Warnings: 0


mysql'''> flush privileges;'''<br>
mysql'''&gt; flush privileges;'''&lt;br&gt;
Query OK, 0 rows affected (0.16 sec)
Query OK, 0 rows affected (0.16 sec)


mysql> '''exit'''<br>
mysql&gt; '''exit'''&lt;br&gt;
Bye
Bye


W:\usr\local\mysql\bin>
W:\usr\local\mysql\bin&gt;
</div>
&lt;/div&gt;


=== Kill process and restart ===
=== Kill process and restart ===
Line 103: Line 104:
# Stop the servers using '''Stop.bat''' close your browser.
# Stop the servers using '''Stop.bat''' close your browser.
# Start the servers using '''Server_Start.bat'''
# Start the servers using '''Server_Start.bat'''
# From apanel run phpMyAdmin.<br>Under Uniform Server check '''Server version: 5.0.41-community-nt'''<br>Confirms the update was '''successful.'''
# From apanel run phpMyAdmin.&lt;br&gt;Under Uniform Server check '''Server version: 5.0.41-community-nt'''&lt;br&gt;Confirms the update was '''successful.'''


=== Conclusion ===
=== Conclusion ===
322

edits