Older patches can be found here like 2.4.3 to 3.3.0 → 3.3.5a

http://www.wowpedia.org/Patch_mirrors

The following site lists all patches since alpha to cata (en and us versions)

http://www.wowpedia.org/Patch_mirrors_(old_patches)

The way MaNGOS handles this is fairly simple and painless

The account information is held in the account table of the realm Database

The `sha_pass_hash` field is nothing else but the SHA1 hash of "USERNAME:PASSWORD", the upper-case username, a ":" and the upper-case password.

As the password-field contains the username, you cant just change the username in the `account` table, you always have to change the password-hash too but don't worry, it sounds harder then it is - Luckily mysql provides all we need.

Change password:

SQL:

UPDATE `account` 
SET `sha_pass_hash` = SHA1(CONCAT(UPPER(`usernameabc`),':',UPPER('passwordxyz'))), `v`='', `s`='' 
WHERE `id` = x; 

Where 'usernameabc' is the username, 'passwordxyz' is the password and 'x' is the account id of the existing entry.

Change username:

SQL:

UPDATE `account` 
SET `username` = 'usernameabc', `sha_pass_hash` = SHA1(CONCAT(UPPER('usernameabc'),':',UPPER('passwordxyz'))), `v`='', `s`=''
WHERE `id` = x; 

Where 'usernameabc' is the username, 'passwordxyz' is the password and 'x' is the account id of the existing entry.

Create new account:

SQL:

INSERT INTO `account` (`username`,`sha_pass_hash`) 
VALUES ('usernameabc', SHA1(CONCAT(UPPER('usernameabc'),':',UPPER('passwordxyz')))); 

Where 'usernameabc' is the username, 'passwordxyz' is the password.

Listing all characters belonging to an account:

SQL:

SELECT character0.characters.* 
FROM realmd.account
LEFT JOIN character0.characters ON realmd.account.id = character0.characters.account
WHERE username='player'

Where character0 is your characters DB, realmd is your realm DB. player is the name of the account you want to find the characters for.

I am writing this little article about default accounts in MaNGOS and how to deal with them.

> WHAT ARE DEFAULT ACCOUNTS ?

Default accounts are accounts created in the account table of the auth DB when you have a fresh install :

After a fresh install you will get those 4 default accounts that allow you to connect directly to your realm in order to make quick tests.

> HOW CAN YOU USE THEM ?

As you can see you have only encrypted password in DB but the scheme is easy : all passwords are equal to the account name.

Note : They are not case sensitive when you type them in the game client.

> PLEASE... DELETE THESE ACCOUNTS IF THEY ARE NOT NEEDED AFTER YOUR FIRST TESTS !

We recommend that you get rid of these accounts and create your own ones, for obvious security reasons :

DELETE FROM `account` WHERE `username` IN ('ADMINISTRATOR', 'GAMEMASTER', 'MODERATOR', 'PLAYER');

If you let them as it is and run a live server... anyone would be able to connect as a GM if you do not change the default passwords.