[Squiffy]

mysql -u root mysql

and I THINK you need to drop the quotes around the username bit... and don't forget grant option

GRANT ALL PRIVILEGES ON *.* to username@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;