Prolly heard it before *sigh* server setup fubar

[shanxi]

Alright. I hate asking people for help but god damnit here i am. Resistance is futile. I started out following this post just as it said:

http://www.eqemulator.net/forums/viewtopic.php?t=17531

I got all the downloads and everything, and installed all the programs in the proper directories.

I am using..
11-09-04_compiled_perl
ActivePerl-5.8.2.808.MSWin32-x86
peq_kunark_release-1099244294
mysql-4.0.22-win
NMAKE.exe (cant remember where I got it but it took me a while to find)
and the default.pl and plugin.pl from the post.
I didnt know what "additional database files I need"ed so I didnt bother with those yet.

Installation Steps:
1) I installed MySQL, but what the hell was "run the prog i had you download?"
You gain experience!
2) extracted compiled perl to c:\eqemu as well as spells_us.txt
You gain experience!
3)installed perl 5.8
You gain experience!
4) put NMAKE.exe into c:\perl\bin
You gain experience!
5) disaster struck-
a Perl 5.8 scowls at you, ready to attack. What would you like your tombstone to say?

I open cmd prpt, type perl -MCPAN -e shell
and c:\Perl folder opens up. clearly not what i wanted to happen. So i say fuck it and go ahead with the instructions.. I dont get anything prompting me for anything.

I restart my computer just because instructions say so. then i type install IO::Scalar into cmd prpt. instead of installing something, it simply opens my c:\WINDOWS\system32 folder 0.o

So, I sigh to myself and trudge forward.

I type perl -MIO::Scalar -e "print 'Installed'" into cmd prpt and like the first substep of 5), opens my c:\Perl folder.

Soo.. reading down, I am directed to search http://search.cpan.org for Scalar.pm and WrapTie.pm.
Cpan.org looks at you apprehensively. You appear to have the upper hand.
This only takes me a few minutes, I download the 2 files, stick em in the c:\Perl\lib\IO folder and set to try to backtrack over the last few steps I described. I repeated them many times now, with the same results. (So step 5 is completely fucked up)
Pain and suffering hits YOU for 1242 points of damage!
6) copied plugin.pl to the c:\eqemu directory
-created c:\eqemu\quests and copied default.pl to said folder

Extracted PEQ_Kunark_RC1 to c:\mysql\bin

Run WinMySQLAdmin.exe and selected my inherently easy, unforgettable user/pass, and stuck it in the slots.

You gain experience!

mysql.exe scowls at you, ready to attack. What would you like your tombstone to say?

I get my little window, looks like this:
-----------------------------------------------------------------------------

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13 to server version: 4.0.22-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

-----------------------------------------------------------------------------

Ok, i say to myself hell this cant be that hard..

mysql> GRANT ALL PRIVELAGES ON eq.* TO pooky@localhost IDENTIFIED BY 'mypassword' WITH GRANT OPTION; (enter)
ERROR 1044: Access denied for user: '@localhost' to database 'eq'
mysql>
-----------------------------------------------------------------------------
So naturally what do i do? of course I try every little change I can make to the "user" "pass" and "localhost" areas. I searched many many forums across the net, not only eqemu (which said to use image@113.113.13.13 --- 'bleh' after altering the db.ini)

It seems the access denied (1044) goes hand in hand with error 1064..
-------------------------------------------------------------------------------
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13 to server version: 4.0.22-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database Forum
-> grant all privileges on eq.* to pooky@localhost
-> identified by 'mypassword';
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'grant all privileges on eq.* to pooky@localhost identified;
mysql>
---------------------------------------------------------------------------------

I read this..

Try this
mysql -u root -p PASSWORD <---where the hell do I type this?

Where PASSWORD is the password of the root account.


If I type it in cmd prpt, i get nothing, and if I type it in mysql> I get nothing lol.

Pain and suffering hits YOU for 32000 points of damage!
You have been slain by MySQL!
LOADING...PLEASE WAIT

Sorry for the really long post, I just wanted you guys to know each of my steps so you could maybe figure exactly what I did wrong. And tossed in a little EQ Humor to lighten the mood =)

I am gaining more and more interest in programming, im just... not that good at it