start mysql in save mode

hi

need to reset mysql root password after migra?

kill mysql procs

start mysql with options

/usr/sbin/mysqld --skip-networking --skip-grant-tables

now we login with no password:

mysql -u root

now we update the password:

UPDATE mysql.user SET Password=PASSWORD('yournewpassword') WHERE User='root';

kill mysql procs

start mysql via initscript

some debian specific:
after setting the root password you need to create or update the debian-sys-maint user

CREATE USER 'debian-sys-maint'@'localhost' IDENTIFIED BY 'yourpassword';
GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' WITH GRANT OPTION;
UPDATE mysql.user SET Password=PASSWORD('yourpassword') WHERE User='debian-sys-maint';

have fun