Changing a username for an account with WHM or Cpanel usually results in havoc. In a shared scenario the username is appended to databasename.
If your database is name drupal then it becomes username_drupal and since your password is attached to a username rather than inherited in some way. In other words you create a username when you create a new account...then a cpanel password is assigned to to that username or account. as for the database: My Cpanel will not allow me to change successfully a username. I must create a new account and never use the old username again. If I want to use something similar, I change the last letter to a number such as olduser1...usually 8 letters or less. and assign any password to it. then each database becomes olduser1_drupal and then I create a database username such as asdf123 and use it for that and all other databases on that account.
Hope this helps Russ Griechen
From: Bruce Whealton To: support@drupal.org Sent: Sunday, April 23, 2006 11:22 AM Subject: [support] Database problem
Hi all, I'm hoping someone can help me please. I had installed drupal using cpanel. Recently, I tried changing the username for my account. That had my site (my drupal site) unreachable, with an "unable to select database," error. Well, I realized that the problem was that my cpanel interface adds a prefix to the database, as in myoldaccountid_drpl1