On Thu, March 23, 2006 3:07 pm, Jim Cheetham wrote: > 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 >
Thanks to you both. silly me, http://www.justfuckinggoogleit.com etc etc
