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 want.

mysqldump and the dreaded lost root password dilemma

2004-09-17 Thread Mitch Pirtle
Hi list, First question - I have a machine that was being managed by Plesk, and an update to mod_python left Plesk in a nonrunning state (actually causes apache to segfault). So I am attempting to manually manage MySQL (the way it should be done!) - but there is apparently no root user in

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