Guillaume Rousse <[EMAIL PROTECTED]> writes: > Le Samedi 1 Mars 2003 18:48, warly a �crit : >> http://qa.mandrakesoft.com/show_bug.cgi?id=1404 >> >> >> >> >> >> ------- Additional Comments From [EMAIL PROTECTED] 2003-03-01 18:48 >> ------- I will add mysql_fix_privilege_tables in the next package I build, >> however this command will >> fail if a password is required for the root user. > I don't know MySQL, but the situation is the same for PostgreSQL: automatic > upgrade requires dumping databases, which will fails if local connection from > super-user requires autentication. > > A solution for Postgresql would be to stop the server, replace old pg_hba.conf > with one allowing connection without password, relaunch the server, dump > database, upgrade everything, restore database, then restore original > pg_hba.conf > > Hope this can help.
Good idea ! In MySQL it is also possible replacing the user tables in the mysql database with a new one allowing root connection without password. -- Warly
