I'd setup your password after i installed apache, mysql etc. and today I didn't remember it. How do i change it out? Maybe produce a new account? I simply need accessibility database.

EDIT: I am utilizing it on ubuntu

EDIT : I'd be okay having a destructive way also. i.e. un-install everyting then re-install everything but that is also asking password and I'd rather not re-install the entire OS. :(

This really is covered within the MySQL manual.

See http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

concerning the root password have a look here:

just in case you're a user, request the DB admin for a replacement.