On Thu, Mar 23, 2006 at 02:41:33PM +1200, Nick Rout wrote: > Apart from a sharp blow to the head, what is the remedy for losing the > root password for my mysql installation (ie the root mysql user not the > root system user).
http://www.google.com/search?client=opera&rls=en&q=mysql+lost+root+password&sourceid=opera&ie=utf-8&oe=utf-8 Stop MySQL, restart it without the grant table data (--skip-grant-tables), connect and set GRANT yourself access, flush privs to propogate your change, restart, enjoy :-) -jim
