[support] Database problem

[russgri at xarahost.com]

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 at 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20060424/d5544c15/attachment.htm