LOL. a video would be too easy. :p
first of all, do you have mysql running with the green light, and have you given permissions in navicat? i will assume you do.
the fix to the ServerShell error:
in the guide it says to change C:/[Your server name]/AccServer/Gameserver.cfg to read "1000 1 127.0.0.1 1 root test JZ", change it to read "1000 1 127.0.0.1 root test jz", without the "" of course. there is an extra 1 in there. :D:p
also check all ip addresses and servernames, check all instances of root and test and make sure they are correct, check all instances of jz or JZ and make sure they are all the same and match what is in your mysql data folder. (i changed mine all to jz). pretty much just open up your ACCServer and Gamerserver folders and open every file that you can open in word, look at whats there, and change it to what you need. LOL :D
you will also have to edit the GetConfig.ini file in your ACCServer folder, open it in word and change "ACCName=AccountServer.exe" to "ACCName=ACCServer.exe". change the MappedAddress to your IP address, and change the ACCServerDir, MSGServerDir, and NPCServerDir to point to where your files are located. although i think i got the ACCServer to run without doing this, it should probably be changed.
(edit: GetConfig.ini is used by jzgateway which isn't used. so it shouldn't make a difference if you modify it or not. - ty bobcake for pointing that out.)
oh yeah, i wouldn't advise to modify anything in your windows system32 folder. you can't just paste or extract a .dll file in there. :p
Try that out and see what you can come up with, hopefully that will fix the problems. :) and if not, post up the problem and i'll try to help out.