ERROR SOURCE FOR 6.0 WINDOWS SERVER GUIDE (Perl Enabled)

[Malignus Wingnut]

If you are having errors with the setting up of your server following my guide in the tutorials section, please post them here.

Please post ALL errors you are having, instead of making separate posts.

I will be making a compendium of errors and solutions up at this main post as people submit them.

I'll ask that the only posts that are made here contain PROBLEMS, as to not clutter the post.

Finally, the information you will need to post on the problem is:

1) What step gave you the problem.

2) ALL information pertaining to the problem. (If it's an error regarding the database, tell me what databse you are using, and what additional queries you have run/files you have sourced)

3) If you're getting an error from a program (zone.exe, world.exe, mysql.exe, etc....) post EXACTLY what that program says, guessing only makes my job tougher.

That's it, got a problem, hit me.

edit: a_Guest03 -
Added link to the guide you're talking about. Stickied

PROBLEM/SOLUTION COMPENDIUM:

IF MYSQL.EXE BEEPS AND CLOSES:

1) Open up the task manager by pressing CTRL + ALT + Delete.

2) Find the tab that has the list of images. Find the image named mysqld-nt.exe. If it is NOT there, proceed on to step 3. If it IS there, end the process, close the task manager, and skip to step 4.

3) Locate your task bar, there should be stoplight there. If there is, right click on it, and find the option to "Start the Service". Click this and the light should turn green. If it does not turn green, proceed to step 4.

4) Open up the folder C:\Windows. Locate the file my.ini, open this file, and copy down the user= and pass= lines. You will need this username/password later. Now DELETE my.ini.

5)Open up the folder C:\mysql\bin and locate WinMySQLAdmin.exe. Run this file, you will be prompted by the Select username/password window. Type in the user/pass from step 4. There will now be a green stoplight in your taskbar. Problem solved. Mysql.exe should now open without beeping and closing.


IF BOOT5ZONES.BAT GIVES YOU A 2006 ERROR:


1)Follow steps 1-5 of the fix for Mysql.exe beeping and closing.

2) When you reach the part where a green stoplight will now be in your taskbar, you are finished.


IF THE GRANT ALL PRIVILEGES LINE OF MYSQL DOESNT WORK:

1) Open a Command Prompt by going to your start menu, clicking RUN, typing in "cmd" (without the quotes) and hitting enter.

2) Type:

CD C:\mysql\bin

3) Then type

mysql -u root mysql

4) Now proceed to type the Grant all Privileges line again:

GRANT ALL PRIVILEGES ON *.* TO Username@localhost IDENTIFIED BY 'Password' WITH GRANT OPTION;

Replacing Username with your MySQL Username and Password with your MySQL Password (Both selected when running WinMySQLAdmin.exe for the first time.) It should now work.

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