<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2873" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial size=2>Changing a username for an account with WHM or
Cpanel usually results in havoc.</FONT></DIV>
<DIV><FONT face=Arial size=2>In a shared scenario the username is appended to
databasename.</FONT></DIV>
<DIV> </DIV>
<DIV>If your database is name drupal then it
becomes username_drupal</DIV>
<DIV>and since your password is attached to a username rather than inherited in
some way.</DIV>
<DIV>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.</DIV>
<DIV>as for the database:</DIV>
<DIV>My Cpanel will not allow me to change successfully a username.</DIV>
<DIV>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
</DIV>
<DIV>olduser1...usually 8 letters or less. and assign any password to it.</DIV>
<DIV> 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.</DIV>
<DIV> </DIV>
<DIV>Hope this helps</DIV>
<DIV>Russ Griechen</DIV>
<DIV> </DIV>
<DIV> </DIV></FONT></DIV>
<DIV><B>From:</B> <A title=brucewhealton@yahoo.com
href="mailto:brucewhealton@yahoo.com">Bruce Whealton</A> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=support@drupal.org
href="mailto:support@drupal.org">support@drupal.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Sunday, April 23, 2006 11:22
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [support] Database problem</DIV>
<DIV><BR></DIV>
<DIV>Hi all,</DIV>
<DIV> 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</DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BLOCKQUOTE></BODY></HTML>