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. 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 documentation. But instead of reseting the password, you want to > launch the mysql client, which you should be able to do without > providing a user name or password since there are no grant tables > loaded. Once in mysql, switch to the mysql database and do a select on > the user table to see what user name are set. There is a column called > "Super_priv", any record with a Y in that column is probably a valid > "root" user. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]