Howto reset mysql password on ubuntu server 9.10

New IBM server has arrived, its IBM X3100-42X. Standard install required; DNS, LAMP and OpenSSH server on  Ubuntu Server 9.10. Problem came when I forgot password for MySQL. I think the solution isn’t far from what I done in FreeBSD. First attempt login to MySQL server : # mysql -uroot -p Enter password: ERROR 1045 …

More