View Single Post
  #90  
Old 11-25-2009, 02:57 AM
Kobaz
Hill Giant
 
Join Date: Nov 2008
Location: Gold Coast, Oz
Posts: 119
Default

You can reset the root password for mysql by stopping mysql and restarting it using the following command:

Code:
mysqld --skip-grant-tables --skip-networking
This starts mysql without any security, hence disabling networking support.

You can then run the client, where you
Code:
use mysql;
and use standard SQL commands to reset your root password. Then stop mysql, and restart it normally.
Reply With Quote