Use a tool like "phpmyadmin", login as the root user, edit the permissions section; it should list the username, the md5 (or sha) version of the password, and the host it can connect to...

Generally it should show several copies of the same user, for differant hosts:
localhost
localhost.localdomain
127.0.0.1

I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!