MySQL Installation and Configuration - Setting up Private WoW Server
By Reaper-X on Jun 27, 2007 in Guide, Software, Tutorials, Windows
This is the first part of the Creating your own World of Warcraft Server using Mangos
- The First part is all about Installing and Configuring MySQL on your Windows Machine
- The Second part is about Configuring the WoW Mangos itself
- The Third part is all about Setting up Private WOW Server for Lan Party
- The Fourth part is all about Installing and Setting up Apache Webserver with PHP
Since i'm still getting lots of email asking me on how to set up a private wow server using mangos and including from the comments i received on my previous guide and that's including here. I’ve decided that it’s best for me to explain it again but this time i'm going to use image instead of text only (previously someone ask me to write guide using images so here goes the guide) btw i had to set up virtual machine just to wrote this guide lol
Also i’d like to say many thanks to all the site visitors and to all who leave comments on this site especially at my wow mangos guide because your suggestion helps me to make this site better
Note : Since there are lots of images used, i think it’s better if i split this guide in two part. And at this part, i'm going to tell you how to install and configure mysql
As a sidenote, you can also use mysql for many things as well instead of just as WoW Private Server only. This means this is a general purpose mysql installation
Okay without further ado, let’s start the guide :
Requirement :
At the time i wrote this, the latest stable mysql version is MySQL 5 Community Edition
And don’t forget to download the 40 MB MySQL (Full MySQL) instead of the small version ;)
Installing MySQL :
After you’ve downloaded and saved the MySQL Setup into your harddrive, run it and choose Custom Installation and continue until this part and adjust it according to image below
And choose to install it
Feel free to register with mysql.com although it does not have anything to do with your mysql installation. I put this, because some people think they need to register with MySQL.com first in order to use mysql program on their computer
After finished with the previous step, choose to configure mysql now (it’ll automaticaly run the mysql server instance config wizard)
That’s it for the installation process, now we need to configure it
Configuring MySQL :
If at the previous step you choose to configure it now, you’ll get below screen … or if you did not choose to configure it now, you can run it using the mysql server instance config wizard shortcut from the start menu
and then
and then choose the Multifunctional Database
And now you need to set up a directory where the InnoDB data shgould be saved (it’ll be created automatically if the directory does not exist so you do not have to worry about creating it first)
In this example the InnoDB directory located at C:\Mysql InnoDB Datafiles
As for the next step, you can adjust maximum concurrent connection depend on your need but most of the time you do not need to set the value to high unless you’re planning on creating public server and you have busy server (if you do this you already violated Mangos Terms of Use)
As for the next step you need to configure on what port should mysql listen to incoming connection (default is port 3306) and it’d be better if you do not change it (you do not need to worry about security because by default root account can only be accessed from local machine or in the other words from your own computer)
Now you need to configure the default charset mysql should use. In this example i'm using UTF8
This is the most important steps because if you forget to check the Include BIN Directory in PATH you need to start all over the mysql configuration process again (or you can edit your windows environment variable manually)
Btw this is one of the many problems many people had before (to those who’s allowed me to connect to their computer via remote assistance know this) … it is the Command Not found / Not Recognized error message from the command prompt ;)
Now here goes another important part, the root password. And you need to remember it or else you will need to reset your mysql root password. Also keep the enable root access from remote machines unchecked as security purpose
Note : This is different that mysql.com account if you decided to register with them or already registered with them
Now you just need to continue and let the instance config wizard do the rest for you and you’ve finished installing mysql on your computer :D
And now we need to make sure MySQL already running and can be accessed directly from the command prompt … so open the command prompt by typing CMD in the run command
- Start Menu
- Run
- type CMD
or
- Start Menu
- Accessories
- Command Prompt
and then type like below image (when prompted for password, type your root password)
If you can type the above command without problem, this means you just configured mysql to work properly on your computer … congrats :D
as for the next part, i’m going to write about Configuring the Mangos itself … stay tune :)
Note : This is a quick and dirty installation, i didn’t write about mysql query cache and any other optimization related configuration. So you’ll need to play around with it by yourself :)
Website RSS Feed
Stumble this post
Bookmark this post on Del.icio.us
Submit this post to Digg
Submit this post to Reddit
Print this
Trackback URL
everytime i try to execute it always stops at "Start Service", any ideas why please?
go to where you've installed mysql (for example C:\Program files\MySQL) and search for .err file and open it using notepad or any other text editor and you'll know the reason it wont start :)
Same problem as above, stops on start service.
Only .eer file I found said error 123, which I looked up and it said
(ERROR_INVALID_NAME)
The filename, directory name, or volume label syntax is incorrect.
Tried diff dir and still wont work, help plz? thx
thanks for help, i had to my the "MySQL InnoDB Datafiles and "MySQL InnoDB Log Directory"
says cannot create windows service for MySQL. error:0 .. help meh :)
nevermind I got it :)
I posted on a different guide as well, but figured i should post here too since this one is more recent, so whenever i do the execute step it tells me it cant start mysql errror:0 on the starting mysql phase, can you please tell me what to do to fix this, you can message me at skeloman64@hotmail.com
im getting teh cannot create windows service for MySQL. error 0
ok i got farther, but not by much, on the next stage of the execute on configuring mysql, it says it cannot access the log because either a firewall is blocking it or the password is wrong...
please help asap once again my msn is skeloman64@hotmail.com
I am getting the same problem as they are cannot create windows service for MySQL. error 0
Also i am getting the port cannt not be accessed not sure how to change that or what i messed up
email is: Ripit901@cox.net
I tried to make a private server for a game and during the configuration of MySQL, at the part where you click the checkbox to include the Bin Directory, the top part with the checkbox to install as a window service, is completely greyed out. I continued and found I could not open 3306. I use windows XP... any idea what I'm doing wrong?
I believe this link will give you a solution to the can't create windows service error message :)
# Shadow
did you previously installed mysql on your machine ? or is there any other program use the same port as mysql ? (port 3306)
hey thanks for the place to download these things and stuff i like the pictures u put in, but i have the same problems as others says cannot create windows service for MySQL. error:0, possible to tell us some reasons it may be broken or not working and how to fix them, i know u gave us a link on troubleshooting it, but sorry i dont get alot of this computer stuff
i was wandering wat u did to get the service to begin working get back to me at T_Bone717@comcast.net ty
Can't start service? | Jul 3, 2007 | Reply
says cannot create windows service for MySQL. error:0 .. help meh
Can't start service? | Jul 3, 2007 | Reply
nevermind I got it
i got the same prob how did u fix it?
anyone know?
ok i got past that one error now i have
The secruity settings could not be applied
error Number 1045.
Access denied for user 'root'@localhost'(using password: Yes)
Anyone know how i can fix it please, i have been trying to get a server for ages now.
I would really appreciate the help.
*maker103 hey this may work for you, go into your firewall options if you have one, and make a port for 3306 name it whatever you want, and that should work. if it doesnt you can try reconfuguring it, but when it gets to the security information, uncheck the box that says "change security info" that may bypass it
I have same problem as maker..but no firewall>
this is Also my first time installing MySQL...
Can I just skip it and it'll still work?
Nevermind..I didn't change anything but I clicked retry and it worked that time=)
Ok just wanna say awesome job showing everything but I got 1 more question...
What would I put for realmslist if I didn't want it to be LAn enabled or public at all? My own IP?
yes ur ip adres goes there, skelomon thanks for the help ;)
Awe kk, thanks=)
Will I have to re download WoW and TBC in order to create my own server? I don't want to get deep into this and then it all be for not because I had the wrong patch.
holy sh*t i helped someone? two people? man i wish my firewall wasnt gay and could add ports, id be on my own server livin the good life!
skeloman yea u did help me ;)
thankyou
now it says service caould not be started error: 0 ;(
i cant get it to work i get to the step where i have to click the exicute button and then the starting services one fails so i cant finish plz helpo ill let you do that remote assistance thingie if you need to
o if you want to get a hold of me im at zztt37861@yahoo.com
Just a tip...
in some mysql clients, the string variable of IP may have to be used with (double)" not single.
In my Pc i had to use the sintax
-- Update realmlist set address = , address = where id = 1;
Okey donkey?!
Cya!
the tags didnt gone in the last message =[
i'l write again the sintax
-- Update realmlist set address = (Old Ip), address = (New Ip) where id = 1;
brent - you actually dont have to redown load it as long as you still have all patch versions saved on your computer, use the repair.exe in the world of warcraft folder itll take you back to first version of tbc then just add patchs back in. its a little quicker then completly reinstalling
I cannot enter any instances now that I have set up my private server, can you help me?
also my friends cannot log in to the realm.
When configuring MySQL I can't seem to get around the Error: 0. I have reinstalled it and deleted the mysql program folder before installing and it still seems to give me that error. Is anyone else having this seemingly unfixable problem?
Anyone made a server they want tested by me? i am a very responsible GM. email me at jb95@hotmail.co.uk
Sorry for asking this but i didnt see it anywhere unless im blind but if we meaning 10 of us wanted to play TBC via LAN this way do we all need to install WoW and TBC or could we just copy the whole thing from 1 computer and run it that way Please reply ASAP we want to play this weekend comeing up
ok error 1045 someone got any idea how to fix it? i turned off my firewall to see, didnt work im not sure what to do
yes, you'll need to install the WoW client (wow installation cd to each computer)
Where did you get that message ? from the command prompt or .. ?
Same here error 1045 iv tryed to ass the port 3306 TCP but it still came up so i turned off my firewall and tryed and it still came up whit " Access denied for user 'root'@'localhost'(using password : YES) this comes up when i execute on the " Apply security settings" any idear's? cause im all out
thnx!
I've been getting problems with some BS about a fire-wall. Any help?
I followed your instructions as best as i could but MYSQL still doesnt seem to want to work properly, im sooo lost..help?? :(
Your best bet is to look for .err file in your mysql installation directory (unless you've modified the default path of mysql data directory)
I have a server if any one needs help or wants to join you can get a hold of me at fullmetalxxxnx@aol.com or use xfire fullmetalnx use xifre its the best way to get a hold of me and the only thig wrong that really big about my server is one kill gets you to lvl 70 and one kill drops 234523 gold lol will be fix
I get the same error about a firewall blocking port 3306. I've tried to install both with that port as an exception and with the firewall turned off completely. The error always occurs without fail.
Does anyone know what is really causing this error and how to fix it?
I can not find any working solutions via google or by searching the MySQL forums or help files.
Thanks
i assume you've disabled your firewall software, so try running this command through command prompt :
1. net stop mysql && net start mysql
2. mysql -u root -p
and enter your password when prompted
if you can connect to your mysql via command prompt, that mean mysql is working
wow 1 kill goes to 70 ? that's an extremely high rate wow server :P
Yeah, reaper...my ports are still closed and i dont even understand what the SQL did...i turned off all my fire walls on my comp and my firewall bellsouth is hosting for me...know what i should do?
I just checked in my run if it worked and it did.
Ah that mean mysql is working, now try importing all the mangos database and then run the mangos process and see if it's working or not (if you've imported the database correctly, you can see mangosd window and realmd window displaying status message)
Errm one problem
ive downloadsed mysql - 5.045 - only one i could find
Ive extracted it cose i had to and now i cant find how to install it anyone know why?
Wait that was my fault im in such a rush to get my kick ass gm powers woo! that i downloaded linux version not windows version - im an idiot i know
I found out how to fix it. If you still have this problem maybe its because there are some files and folders in the path you chose to install you SQL
So first you need to remove(from the installer) your sql and then manualy delete the remaning folders(C:MySQL InnoDB Datafiles\ and C:Program Files\MySQL\) then to not get the "port can not be accessed" could be coz of your firewall so i closed it. This worked for me :)
Just in case after you removed the sql and deleted the folders, exe---> CMD and type "sc delete sql" and reinstall sql.
ok, i download the Msql version 5.0 and the 40 mb full version, my installation skips the step with the regestring at Msql thing, and then it stops at Start Service saying Error #0...
i have checked to err file and it came up weirdly in code...
any ideas how to fix this it said data drive is full got heaps of space.....8gig left.
thanks
When I am in the command prompt and I type in my password, it says "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)"
does that mean it is blocking it somehow or I don't have the 'rank' to do it??
ok, i deleted all of it and tried reinstalling again, now i get that "Could not start the service MySQL.Error:0" umm
wth lol
my firewalls are bugged
if it says port 3306 is already in use, is that a problem?
back to 1045...
hmm when i klick execute nothing happend and the program aint answer what shall i do!?
Im sorry to make this question. Maybe you already said somewhere but i dont see it...
If i'm going to do the classic wow server... i need to install wow without patchs? or up to what patch?
same with TBC server, till what patch?
Im so sorry but i dont have a idea :(
Hey, I followed all the steps before and it work. So i switched computers on my LAN becuase this one ran better. Now when i follow the steps I get to the Execute part of the Instance Configure Wizard and it gets to the Apply Security Settings and it give me this message:
Error Nr. 2003
Can't connect to MySQL server on "localhost" (10061)
I opened the port and everything but it just wont work. Please help me
kylemcbr@gmial.com
Have you tried checking the process list (Task Manager -> Process List) and see if the mysqld process is listed there ?
i seem to be having the same problem as most people regarding the startup services but i have yet to see a fix on here....here is the error i get...
InnoDB: Error: log file .\ib_logfile0 is of different size 0 177209344 bytes
InnoDB: than specified in the .cnf file 0 25165824 bytes!
070826 16:50:16 [ERROR] Default storage engine (InnoDB) is not available
070826 16:50:16 [ERROR] Aborting
...i would love to get past this error so i can run into another one
that error message means, the InnoDB Storage / Logsize has different size compared to the specified value in your my.cnf
the easiest way to fix it, delete the ib_logfile0,ib_logfile1,etc from your mysql data directory and restart the mysql service to force mysql to recreate the data again
or you can also choose to disable InnoDB completely if you aren't going to use it by :
1. adding skip-innodb into your my.cnf
2. comment (#) all innodb configuration in your my.cnf
3. restart mysql
uh, error 1045, i dont even have a firewall, i dunno what is up
uh and i tried doing it in command prompt, i enter he password and it still gives the erro, btw i already have mangos downloaded and my server is up and runnin g, i am just using mysql to get my friends online
Ok got it all up and running. It's working well although the following bugs I was wondering if anyone could help me with:
1) Can't use any of the chat channels at all and nothing is displayed in the chat windown when I type something.
2) XP bar missing.
3) Most importantly my cash is set to 0 copper and no matter what cash I add or stuff I sell I do not receive the money.
4) Grsphical glitches like some models are hold little blue and white boxes.
I hope you can assist in this as right now I possess 5/5 Dual Wield Specialisation but unfortunately my whole skill page is empty, which means I cannot dual wield at all, despite specialising in it. Wierd huh? Help peoples!!
when i go to enter my password it makes a loud beep noise and says its wrong! i already got a account, help?
btw do u need mySql to run ur own private server?
from your description, it seems that the mangos you're using is not compatible with your WoW installation. I can only suggest you to get another mangos revision (preferably newer release, or the latest one that is compatible with the full SDB you're going to use)
as a note, if you look at my previous wow mangos screenshot, you'll see that im using Dual Weapon (i think the weapon name is DeathBringer or something, IIRC) because im just guessing weapon name lol
and im not experiencing chat, or money issue as you described even with the old mangos revision (3462) for wow classic only
loud beep noise ? from mysql or from mangos window ?
of course :) because that's where your character data, game database (weapon, warp, etc), and your realm information stored
hey when i try to do the command promp thing it says it's not recognized
you just need to run the mysql server instance config wizard and don't forget to add mysql bin directory to windows path when asked :)
Coming from a previous post on the older guide in which Reaper-X asked me if I had the realm loop problem...
This post should go here, as I followed this guide.
I'm not sure what the realm loop problem is exactly...because it connects to the realm and sits there and displays the message "Retrieving Character List" and gives me the cancel option. It just sits there.
I followed your guide to the letter with no problems and I know my version of mangos is compatible because I checked that before I started the installation (Revision 4344 which is supposed to be able to run TBC 2.1.3 which is what I have installed). I also got the correct SDB files from the link you provided.
When I execute it always stops at Start Service and
says cannot create windows service for MySQL. error:0
i tried to uninstall the Program but it doesn't help
please some1 can help me?
help,, iit always stops at the 3rd spot and says error 0,, help plz
I got "Cannot create Windows service for MySQL. Error:0" which stopes at "Start service" like everyone else. E-mail me at meintein@earthlink.net with details on how to fix this ASAP.
Here's the Solution for mysql service problem
OK Im just wondering what would happen if i get a higher version of MySQL?
Actually you can install any version that fit you best (or any version that is available for download from mysql website) :)
as a side note, i've tested mangos with MySQL 4.1.x , and mysql 5.0.xx without problem
Hello. Well i downloaded the MySQL, but now im currently stuck at "Start Service" its not going farther then that. The buttons are greyed out also, idk what to do!
I pressed execute and its currently stuck on "Start Serivice" please can i get some assistance?
Argh, It was all going so well until i got into the game. I was unable to create a character due to SQL ERROR: Unknown column 'pending_honor' in 'field list'
Any suggestions?
Yo reaper , awesome stuff here ... one thing ... Have you heard about anything or way to initiate a mob AI to the data .... cause i have tried about 5 different DB's and not one of them has workin spell casting mobs.... all mobs in all DB's i have tried just physically attack. Im searchin around right now ... but if u know of anything , be appreciated m8.
Ok , well i have studied a bit on this thing called ScriptDev and i have the sql files ... i am not sure i understand how to import them into the exsisting mangos database ... the only option i see is to restore from SQL ... i have done this and it seemed to affect nothing ... maybe it has added speech abilities to the silvermoon guards ... but otherwise , not one mob casts any spells .. no boss's either ... i dont understand. Any ideas?
As far as gettin stuck at the Service Started status .... i had this happen once .. i just uninstalled MySQL and manually removed all left over traces from the program files dir... as well as the InnoDB folder ... delete it all and freshly install it. Worked for me. Just make sure you uninstall and remove every last left over peice of data from yer machine.
Well .. after a few hours of playin around in the mangos database .. i discovered that a small amount of creatures do cast spells. Seems that most creatures in the database do not have a script attactched to them.
Heres what i did ...
Charlga Razorflank eg : had no script or spell casting caps enabled (which we know is rediculous as in the real version he does cast things).
I added the line "generic_creature" to scripts (as other creatures that do cast have this script) and aded 2 spells into spell1 and spell2 (spells were of my choice). Whoila .. Razorflank now casts spells.
Im just curious .. is there a way to find more scripts .. seems it would take a millenium to hand edit the whole damn database O.o ...
Anyways , just wanted to say once more ... great article Reaper .. helped alot ... and if u do know of anything about these scripts .. would be appreciated.
TY :D
# Goblisleez
just in case you want to import the scriptdev2 sql file, you can type this at the command prompt
mysql -u root -p -D mangos < scriptdev2.sql
and if you take a look inside the scriptdev2.sql file, actually it's just updating the creature_template table to make the monster cast spells
# Pool
Argh, It was all going so well until i got into the game. I was unable to create a character due to SQL ERROR: Unknown column ‘pending_honor’ in field list
it seems that you're using patched mangos that is using honor system, to fix it you need to execute the sql file included with that release
I can't even find a MySQL to dl! I found one for a mac computer but nothing else. Did they stop hosting it? If they did is it possible still to get ahold of it for free?
Direct Link to mysql 5.0.45 win32 version :)
click here
hey,
when i open Server instance config i get a lil blue screen and then nothing happens ?
whats wrong?
It works now, thanks to ur link above guess i wasnt downloadign good one ;S
I cant believe it.. again i only get that dam lil blue box!
what the fak
how much errors you can get
now i got 1045 error
acces denied for user 'root@localhost
i already did everything with port 3306
pls what to do now ?
Error 1045 / Access Denied message mean (in your case), you're not supplying the correct password for the root username
to fix it ... simply use the correct password for the root username
the default password for root (if you haven't changed it) is blank ... or in other words without any password
Only thing i can do is retry or skip >.>
to make thing easier, uninstall and then delete your mysql installation directory (default location can be found at)
C:\program files\mysql
and then reinstall mysql again
also if you previosly had mysql installed from any other program (if you're using WoW Repack from somewhere that includes everything), make sure that mysql process is not running
you can check if the mysql process is running or not by looking for mysqld process via task manager
Deleted all
Process closed
Deleted Amrican93 repack(to make priv server but never worked for me)
Installing
Configuring
Setting Password (i wont forget i use it for everything)
Executing...
YES
It works
never been so far now..
Thanx Reaper u rock!
You rock!
THANX!
But in command prompt
if i type
mysql -u root -p nothing happens
cant enter my pass..
Is it working or not?
since if i press start apache & SQL on MaNGOS
i get a loud beep noise and the window closes
# Neo
Did you receive any error message when typing mysql -u root -p ?
and by default mangos is going to make a beep noise when launched, but if you don't like it you can change the mangosd.conf (configuration file) so it doesn't make a loud beep noise when started
Yes i get an error then.
MYSQL am not recognized as an internal or external task, program or batchbestand
I translated it with a program maybe some words are not rlly good( im not english )
is it also normal in mangos everything closes instantly after i pressed.
and the other buttons al go to a non existing website?
I am getting the 1045 error but when I cmd prompt it and put in the password I installed it with it works ie. mysql -u root -p gives me the prompt for password I use my password and all works but the end of the install still gives the error.
I dont know why i got that recognize error im 100000% sure i checked Include BIN Directory in PATH.
I configured again and checked it.
still the recognize error
I assume that you're installing mysql to it's default path
now just you need to type this from the command prompt
PATH=C:\Program Files\MySQL\MySQL Server 5.0\bin
and then type mysql -u root -p
NOTE : The above is just a temporary solution which mean you'll need to retype PATH whenever you close the command prompt window
To make it permanent, use below instruction
and to make sure mysql already written the BIN path into your windows directory
open System Properties, then go to advanced tab, open the Environment Variables and look under your system Variables for :
PATH
and then see if mysql bin directory is listed there
If it's not there, add the mysql bin directory manually
If i do PATH=C:\Program Files\MySQL\MySQL Server 5.0\bin
it says:
Too many parameters.
if i do mysql -u root -p then still same error.
I checked system variables and Path is there.
Any more ideas?
I got Vista
can any1 tell me where i download mangos from?
# Neo
Unfortunately i haven't tried using Vista yet :( ... so i can't give anymore info about it
# Kris
Just in case you didn't notice, i just posted my own compiled mangos, for more info just click here
OK so I got my server running and I can login on the same computer as the server. But when I try to login in from another computer on my network it goes to logging into the server. Then it just loops back to the realm list
My client version is 2.1.3 (6898)...and the mangos version is unknown.
Help would be greatly appreciated.
~TBSKira~
Hi @ all!! This question may seem a bit strange, but when "MySQL Server Instance Configuration Wizard" ask for the root password, i donno what to type in? Which password is it i have to enter? Or, where can i find it?
Thank you man! This tutorial is awsome, i really appreciated that.
# Hellboy
Asked for previous password ? well that mean you need to use your previously registered password for your root account
# Bernardo
Your welcome Bernardo, glad you like it :)
I've gone through all the steps and tried all the troubleshooting suggested in the comments. I get to the very last step, accessing mysql from the command prompt. I typed in mysql -u -root -p and hit enter. I was prompted for my password so I entered my password and hit enter. I get the following error:
ERROR 1045 : access denied for user '-root'@'localhost'
is this a problem and if so, how can I fix it?
Hey Reaper havent tryed this yet but looks good =D great job haha! specialy with actualy answer questions most people make a guide and leave it like it is =/
i cant get past start server and iv done it just as u have... can u help me?
Kris
ok i read the one guys comment... so u dont need mysql to run the server on ur own... i just want to play by my self... just want to practic some GM commands... so i just need mangos??
how do u configure mysql or what do u import.. like http://www.bytehost.com will host my server free but what do i import? what mysql file??
My problem with this is that in the Custom Installation Menu, I have no "MySQL Instance Manager" in the list.
Any way to fix that?
Lo,i got my wow server running but when i came home today my mysql doesnt start,i tried strat mysql, but it says ERROR 1405 (28000) : Access denined for user root@loaclhost (using password : Yes )in command prompt.Can you help me?
# Matt C
you'll need to use the correct password for root which is asked when installing mysql :)
to make thing easier, uninstall mysql first, and then delete all mysql directory in program files
and then reinstall it again
# Micah
If it's for me, if i want to write something related to guide, of course i have to be prepared to answer various questions asked by the site visitors :)
Unless i missed your question of course because i didn't see it (if there're to many questions asked in a single day) ;)
# kris
No you need mangos and mysql both, because mangos look for the items, data, and such stuff (including your login) in the mysql database :)
# Elliott
Are you planning on running the mangos process from your computer and stored the database elsewhere (in your case the byethost) ?
Because it's not possible to run the mangos process from a web hosting with mysql support
you'll need a dedicated server to run process that requires high memory usage (just like i said before)
if you're sure you want to store the mysql database over at the byethost (which i dont recommend) you need to know what kind of server byethost offers to you ;)
is it Linux server ? and if its a linux server do you have a shell access / ssh access ?
or is it a CPanel server ? Plesk, etc ?
and so on :)
Note : you'll need to give some more info about your server setup first (like the Operating System,etc) so i can help you :)
# Ashley
Which mysql version you've downloaded ? did you get the 40 MB version for windows or the smaller version ? if you've downloaded 40 MB version then mysql server instance config wizard already included in the package (tested) but if you're using the smaller version, i can't really talk to much about it since i havent tried using the small version :)
# Baah
From the looks of that error message, it seems that you're not using the correct password for root (unless it says that mysql service can't be started)
to check whether mysql service already started or not
open task manager -> process list -> and see if mysql process is listed there :)
plz help me, when you start the command line client you do youre password then it starts. but the CMD code isnt working so whats the problem plz tell!!
OMG IVE DONE THIS OVER AND OVER LIKE 10 TIMES AND NO MATTER WUT I DO OR CHANGE IT JUST KEEP SAYING ERROR 1045 ACESS DENIED FOR USER 'ODB'@LOCAL HOST USIN PASSOWRD NO! WTF IS WRONG LOL please let me know man this is fustrating and ive already ripped my pillow cover 2ce
ok ok ok i think i got it but heres the thing... if i go to command promt(the comps command promt) and do wut u said it dont work. but if i go mysql's command promt it just asks for my password and when i type it in, it all works. is that right?
lol i feel like a spammer but forget the first 2 posts i made im sure its fine, but you closed the post on next page and ur instructions arnt makin any sesne, im tryin to make a clasic wow server not tbc and i followed you links for magnos but when downloaded they're a .rar file not zip i cant extract anything?
# HELP
Could you tell me which command prompt is not working for you ?
# shaderade
aah ... you'll need winrar (shareware) to extract it ... or you can use 7-zip (freeware and opensource) to extract it ;)
http://www.7-zip.org
Hey i have a problem. I want to create wow tbc 2.2.2 server. I am by step where i must copy vmaps,maps and dbc. I copied all of these folders in a new folder. Than i opened mangosd conf. to changed datadir to my direction. I started the mangosd, and it showed me an error: file missing /maps/0004331.map i looked in the folder maps and there was that 0004331.map. But the mangosd showes me still the error. I reinstalled wow and i copyed vmaps and maps once more time but the there was still that error!!!:,( PLs help me
ok. when i am installing (using 5.1) , it says error 2003. the security could not be applied to the database because the connection has failed. cannot connect to MySQL server on "localhost" (10061)
I have my firewall off and i even put port 3306 as an exception. Retrying is not working :'(. I had done this before, then I removed it using remove programs and am trying again.
I keep getting stuck at "Start service" and it always says "Cannot create Windows service for MySQL. Error: 0"... Help?
Mr.Fix it, let me tell u somthing...u put on this site bad download link of mysql...try do it better next time thank you. sorry for my corection.
I think this will help others http://www.soft32.com/Download/Free/MySQL_Windows_Server/4-972-1.html