How to make a 3.2.2a Server!

i get stuck at authenticating when i try to connect.. my wow version is 3.2.2a and realmlist set to set realmlist 127.0.0.1:3306, 127.0.0.1 3306, 127.0.0.1, 24.127.192.58:3306, 24.127.192.58. 24.127.192.58 3306

i used the 24.127.192.58 address because that was the one showing in the local ip address section of the my sql proggy.

I setup everything fine with the dbs up working nicely. i run the servers and they load up fine makes the beep then its done assuming.. looks like its up :P but cant connect :( any ideas? Also i have my db files ect in another folder next to my wow folder. is that ok? do i need to put it inside of the wow folder that has the game files or just leave it?

the realmd only has this in its box dunno if that means its connected



MaNGOS/0.15.0-DEV (* * Revision 8859 - 4e71b65bd858a2bd8d7d5df2523b6dcfba84b235)
for Win32 (little-endian) [realm-daemon]
<Ctrl-C> to stop.

Using configuration file realmd.conf.
Database: 127.0.0.1;3306;root;test;realmd
MySQL client library: 5.0.56
MySQL server ver: 4.0.18-max-nt-log
SQL: SET NAMES `utf8`
SQL ERROR: Unknown system variable 'NAMES'
SQL: SET CHARACTER SET `utf8`Added realm "FlameRealm- Nightmar".

SQL ERROR: Unknown character set: 'utf8'Added realm "FlameRealm- Sunset".

realmd process priority class set to HIGH




tried again and got this

MaNGOS/0.15.0-DEV (* * Revision 8859 - 4e71b65bd858a2bd8d7d5df2523b6dcfba84b235)
for Win32 (little-endian) [realm-daemon]
<Ctrl-C> to stop.

Using configuration file realmd.conf.
Database: 127.0.0.1;3306;root;test;realmd
MySQL client library: 5.0.56
MySQL server ver: 4.0.18-max-nt-log
Added realm "FlameRealm- Nightmar".
Added realm "FlameRealm- Sunset".
realmd process priority class set to HIGH

SQL: SET NAMES `utf8`
SQL ERROR: Unknown system variable 'NAMES'
SQL: SET CHARACTER SET `utf8`
SQL ERROR: Unknown character set: 'utf8'

Really ghood but how we connect in game?:/

anyone have completed creature_addon.sql file ??

Code:

---

Error in creature_addon table, probably sql file format was updated (there shoul
d be 9 fields in sql).

---

this version if WOTLK or Burning Crusade ??