How to reset MYSQL password
 

I have installed MYSQL on linux (fedora 17) and I forgot MYSQL password how can I reset new password and one more thing user table is crashed

bugzilla installation error
 

i am working on fedora 17
while installing bugzill it's giving an error
ERROR:install_driver(mysql) failed: Attempt to reload DBD/mysql.pm aborted.
Compilation failed in require at (eval 1314) line 3, <DATA> line 558