Re: mysqldump and the dreaded lost root password dilemma

2004-09-18 Thread Mitch Pirtle
Thanks Brent, your solution is the one that worked for me. In 4.0.20 there was no 'Super_priv' column however. ? On Fri, 17 Sep 2004 15:20:43 -0400, Brent Baisley <[EMAIL PROTECTED]> wrote: > There probably is a "root" user, but it's not called root. You can name > the "root" user whatever you

Re: mysqldump and the dreaded lost root password dilemma

2004-09-17 Thread Brent Baisley
There probably is a "root" user, but it's not called root. You can name the "root" user whatever you want. You probably just don't have a user named "root", which is why you can change the password for user "root". You want to start MySQL with the skip grant tables options, just like in the doc