MySql access denied for root - doh!

If you are not careful, you can easily demote your root account in mysql to have zero access - "Access denied for 'root@localhost' using password YES". Fear not, it is easily solved by restarting the mysql service with the option --skip-grant-tables. If you're running mysql on Windows, it's easiest to add the row

skip-grant-tables=1

to your my.ini and restart the service. Fix the access rights and don't forget to restart in normal mode or you'll have an all-users-all-access database.
---------------------------------------------------------------
#wapmarks - WAP links and personal phone startpage