Just want to share an experience I had with MySQL losing the root access er 1045... After granting new priviledges I discovered that when I installed MySQL I (because faulty keyboard) type a password with one different character. I discovered wheb trying to access with:

mysql -u root -ppassword instead of mysql -u root (this one requires you to type and you don't 'see' what works and what don't)...

that way I 'saw' the password that was working (1 in 10 tries), This was driving me nuts...

Just ... to share...

Later

p.d.
MySQL is a tool not everybody use on a 'daily' basis, Once you have it working you can easily IMO forget about it. More if you use a tool to manage your db's... Thats one reason when it breaks it breaks heavilty.. at least newbiews