To change a user name.
<p>If possible, avoid changing the user name.  One issue is that the user name and email address are connected.  There are two ways to do this:</p>
<ol>
<li>Note what groups the user is in, then <a href=\"/dopsysadmin/faq/119.html\">remove the user</a>
and then create a new account, adding them to the groups</a></li>
<li>Edit the database by hand and hope for the best</li>
</ol>

<h2>Changing a username by editing the database by hand</h2>

<ol>
<li>Use <a href=\"/mysql\">MySQL</a> and go to the 
<code>users</code> database, then the <code>profiles</code> table
and search for the user profile by name and then edit the record and change the name</li>
<li>Use <a href=\"/mysql\">MySQL</a> and go to the 
<code>auth_<i>N</i></code> database, then the <code>users</code> table, search for the username, edit the record and change the name.  This will fix the user_websites() method.
</ol>