Topic 1 - [How to Setup eAthena Server SVN]
Topic 2 - [How to Setup Ragnarok Online Server MYSQL Database]
Topic 3 - [How to Setup Ragnarok Online Server Abyss Server and PHP]
Topic 4 - [How to Setup Ragnarok Online Server Control Panel,Cpanel and Zend Optimizier]
Topic 5 - [What to do NEXT?]
<---Topic 1--- [Main Page] ---Topic 3--->
[Topic 2]
2] Guides on Setting up Ragnarok Online
Server MYSQL Database.
1a.)
What DO you [Need] and to Download?
_
1] MySQL 5.0.27 and other installation files
2] MySQL GUI Tools 5.0-r8 and other installation files
[If any error occurs or installations fail to function, re-download and reinstall from step one all over again.]
[Requires Web Hosting and Dedicated Hosting Servers or Dedicated Server to host Website and Server Online 24/7]
1b.) [Download from the following Sponsored Reference Links]
Please NOTE that: For other type of operating system, check this website: Link
2.)
Install MySQL 5.0.27
-Click Next
-Choose Typical and then click Next.
-Click Install.
-Choose to skip sign up and then click Next.
-When the installation finished, Tick Configure the MySQL Server now and click Finish.
-Now you can choose Detailed Configuration or Standard Configuration. This would be up to you to choose any of it. You can just choose standard configuration and click Next.
-Next, Under Service Name Column, Choose MYSQL5 and then click Next.
-Next, Just enter any password for this root user and click next. Do not change the username as this username and password would be used later as your database login.
-Click Execute and after its done, click Finish. If any errors occurs, uninstall MYSQL5.0.27 and reinstall everything again.
3.) -Install MySQL GUI Tools 5.0-r8
4.)
-Next, Open MySql Adminstrator and it will prompt out a window, Type in the Host Name, Username and password as shown below.
Stored Connection: [Just leave this column empty]
Server Host: localhost
Username: root
Password: (enter the password you have created before for the user root)
Port: 3306
-Click Ok and you should now be in MYSQL Adminstrator.
-Go to your left column and look for User Adminstration and click on Add New User.
-Enter this inside the columns:
MySQL User: ragnarok
Password: ragnarok
Confirm Password: ragnarok
Click Apply Changes when you are done.
-When you are done, exit MYSQL Adminstrator.
5.)
-Open MYSQL Query Browser from your Desktop or Start Menu.
-If you cant find it in your desktop, try finding it from the following directory C:\Program Files\MySQL\MySQL Tools for 5.0
6.)
-After you open MySQL Query Browser, a window should prompt out, type this out in the following blanks:
Stored Connection: [just leave it empty]
Server Host: localhost
Username: root
Password: [enter the password we created before for root]
Default Schema: ragnarok
Port: 3306
-Click OK to create a new ragnarok schema.
7.)
-You should now be inside MySQL Query Browser.
-Click once on the Ragnarok Database on your right column and make sure it is bold.
-Go to menu, click File, Open Script and search for a folder named sql-files which should be in your eAthena Server Folder.
-When you are inside the sql-files folder with your MySQL Query Browser, click on Main.sql and click open.
-Once it is done loading, click on the Green Execute Button on your upper right hand corner and it should do some executing. Do the same with Mail.sql and some latest upgrade.sql .
-Once you are done, click on the Resultset 1 Tab to go back to the main page. Right click on any database, eg.Ragnarok and choose Create New Schema , type in log and click ok. Once it is done, click once on log database and make sure it is bold, Go to menu, File, Open Script and choose logs.sql and click on the Green Execute Button.
-Now, click on the Resultset 1 to go back to the main page. Click once on Ragnarok database, right click on Ragnarok database and click refresh. There should be some database files shown on your right column. Search for a database named login and click Quadruple (4) times on it. A window should prompt out .
-To edit the login table, click once on edit on the bottom, look at column 1 and change the username s1 , password p1 to the username and password you used eariler on in your char_athena and map_athena.
-To make a GM[Game Master] Account, Right click on any place between the white screen, click create new column. Change the newly created empty column number id to 2000000 and choose a username and password for your GM account. As for the level column , put 99 for adminstrator.
-After you have done, click Apply Changes.
-You are now done with your MySql Database. EXIT now.
<---Topic 1--- [Main Page] ---Topic 3--->
60 comments:
the logs and the testro i puted are not bold. how was that?
and i got error when i open the log.sql map and char. something like this [SQL]Access denied for user ragnarok to database ragnarok.
how am i going to resolve this ? please help me. thanks !
please help me about the [SQL]access denied for user 'ragnarok'@'%' to database ragnarok.
thanks in advance please help mee
If you get an access denied when running SQL it's because you need to go back to your MySQL Administrator.
Then in user administrator(on the left) you choose ragnarok. There will be 3 things on the top, one as "shema Privilege"
Choose log and ragnarok, and put them in the left box using << button.
:) Wish it help!
i dont have mail.sql and which upgrade.sql should i execute
the upgrade SQL with the biggest number. if it has main in it, apply that first b4 executing the upgrade-SQL######.
"click Quadruple (4) times on it."
when i click 4 times on it nothing comes up
What do you mean by any place between the white screen? I can't find the place that lets me create a new column
I don't have mail.sql too.
and I can't find the create new column
If i just wanna host private RO for lan-gaming use instead of online 24/7. I just need follow step 1 and 2 will do?
Map server crashed! restarting in 15 seconds! press ctl+C to cancel restart!
the issue is same for char n login.. I have set the privilege, anything else?
How come when I try to put in the
Stored Connection: [Just leave this column empty]
Server Host: localhost
Username: root
Password: (enter the password you have created before for the user root)
Port: 3306
It comes out
ERROR 1064<42000>: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntacx to use near ' Soted Connection:
Server Host: local host
Username: root
Password: {yeah my pass}
D' at line 1 . Please help =(
which sql upgrade I have to execute first?
dont have mail.sql..help me please...
Why it takes so long to conenct to MYSQL server instance until now It still connecting can someone help me?
Hello. Please help me .. MySQL Administrator to write localhost root and root, and it is there I can table that.
Write:
Stored Connection:
Server Host: localhost
Username: root
Password: root
Port: 3306
Table:
MySQL administrator error
MySQL error number 2003
Can´t connect to MySQL server on ´localhost´(10061)
if you want to check the netvork connection, plase click Ping button
OK Ping
plase help me
please help me with > " Do the same with Mail.sql and some latest upgrade.sql . " ..cannot find it.. T_T
can i run it with others program then iRo (Gravity)? can i use gameflier ragnarok? >> http://ro.gameflier.com
is it columns or rows? ._. i can't add columns, only tabs.. lawls
is it okay if i download the latest mysql . the MYSQL 5.1.45??please reply asap
is it okay if i download the latest MYSQL 5.1.45?
i got all my server up, the only problem was it always failed to connect to server and i cant change the server display name.. Thanks for your good guide. Mark here
i cant find mail.sql
i cant find mail.sql
how to apply changes on msqyl plz help me
how to apply changes on msqyl plz help me
i manage to make my server running, but my friends can't connect to it always failed to connect, how can i fix this? tnx in advance :D
Yeah, there is no Mail.sql
So is it ok that we would skip the Mail.sql?
error 2003 when i click ok when i done with mysql adminstrator
Ok Ping
same problem with kindly five.
error 2003.
what''s the problem???
please help!
if i already run the server . where i can log in and play ? help please
i have this error in my mapserv.bat
[Info ]: SVN Revision: '12969M '
[Status ]: Done loading plugin 'UPnP'
[Info ]: Console silent setting: 0
[Error} :
what will i do ? HELP ..
what on earth ... it doesn't work !!!
Where The White Screen!!!!!!!!!!!!!!
I NOt Found IT
why i can't install mysql.essential.5.0.45 it said that the system administrator has set policies to prevent this installation please help me
Why There is an Error 1045 it saids that my My TCP 3306 is not opened to access to it please chat me at FB stupidmf_47@yahoo.com please ASAO
Request For Fast Reply(Help):Cant find mail.sql and which upgrade sql im trying to open server self server from a month please kindly help me out pls Plsss :(
Request For Fast Reply(Help):Cant find mail.sql and which upgrade sql im trying to open server self server from a month please kindly help me out pls Plsss :(
Those who want help can add me:
dastgirpojee@rocketmail.com
Those who want help can add me:
dastgirpojee@rocketmail.com
Somebody can help me? add my email luph_bear46@yahoo.com i have a problem there's no mail.sql and what upgrade.sql should i execute?
rtdn [url=http://www.bootswould.com]uggs boots sale[/url]
ugg boots put in a google + like key
pxxc [url=http://www.bootswould.com]www.bootswould.com[/url]
You'll discover a number of web-sites to purchase your captivating underwear. There may be plenty of outlets in your location and when not, you can find a huge selection of lingerie outlets on the web. Have a trip to your uncovering teddy in satin or silk as well as an attractive, total time-span salad dressing bathrobe with your preferred content material. Yet again, satin or man made fibre and reasonably trendy.
tkrc [url=http://www.bootssay.com]cheap ugg[/url]
You might be strategy lots of quantities of folks that is going to be identified as having diabetic issues donning? Are you gonna be the same as the relaxation whorrr regarding obtaining difficulties retaining stability and wellbeing with the all forms of diabetes? Diabetes mellitus is truly a Living-threatening condition ,Low-cost Uggs OutletUggs Sales , in addition to a balanced body is commonly a real concern. Thousands and thousands Battle to Preserve stability as well as balanced system. Diabetic aren the only real one particular striving. For several years the last top rated purpose of research workers correcting supplements would be to delivers a completely total supplement that gains all components of the vintage physique purchases necessary methods. Many people 1 year throw time and effort and money away on overall wellness nutritional supplements that they have to practical experience blend collectively. This usually introduced troubles and adverse reactions thinking about most items weren adequately tested alongside one another for penalties. Overall a completely-organic item effortlessly have confidence in and utilize uggs cheap , to be assured my own mail to ensure that harming our body with synthetic substances. For cease a while further from the ultimate purpose of enhance research workers is to lead to a complete and overall dietary supplement that rewards every aspect the body within the essential methods. More and more persons shell out a lot of time and money on intricate supplements that they need to like mix inexpensive uggs females shoes or boots ,uggs sale made, usually introducing unpredicted issues and results plenty of considering the available merchandise destination been sufficiently examined alongside one another. Complete an exciting-normal merchandise,Ugg Boot Wall plug, when we not one men and women intending to retain filling your program with synthetic chemical substances even as occur accomplishing at as very long. Well It my opinion that the lookup has concluded ugg sheepskin boots caroline shoes british isles
Hello! I could have sworn I've been to this site before but after browsing through some of the post I realized it's new to me.
Anyways, I'm definitely happy I found it and I'll be bookmarking and checking
back often!
Feel free to surf to my web page - buy a car with bad credit
Also see my webpage - buying a car with bad credit,buy a car with bad credit,how to buy a car with bad credit,buying a car,buy a car,how to buy a car
hermes bagsBirkin Handbags uhcc 2013 Hermes BagsHandbags Hermes mgcl
Аlternatively, BCWipe саn use thе Сhrіs Gutmann
wiping strategiеѕ, οr A sіnglе
рass oveгwгiting, thоugh the lаter is unԁoubtedly
not гisk-free It is the best way tо еnѕure you
or maybе nо bad сredit for you ωish a grеater chanсе of increasing a loan 'Availability of Instant Cash These loans would be the boon knowing they are temporary and far a lesser amount of risky The fact that a unique loan is now being secured within the money working capital these email his financial needs friends or family, there's not that many сhoiсeѕ available Often this
is cеrtaіnly stateԁ for а pегсеnt on the sale ρricе
tag such as thгее ρеrсеnt
of thе fіnal cost Мanу of us kept up wіth
еνeгy others аrtіcles oг blog рοsts and ѕpоken on the phone considегably learn more Thosе able to
ρut 10 % down purchase an even better rate-the Marketing assistant funding price in this case would be 1 Occasionally the appraisal report can be used by the two of you to set a sale value of the property estimated In spite you have a most severe credit record while in the financial contract, short excessively high solution to match any of your short-term needs It is usually not scarce for beginners to help ruin its good clothes through completely wrong application of blazer badges If you have ever heard of CPA or Cost Per Action business design, this should sound familiar How could they do it in such a way people are tallied up these people offered, but there is them without any difficulties The only thing is that you must have a current banking account and must often be earning the actual monthly income 3000, even though some lenders may perhaps allow a larger borrowing based on your settlement criteria Bad credit describing are some things employs your corporations cost of obtain a sum based on your wages flow Rate of interest recharged on the financial is a bit beyond other financial loans Perhaps you prepaid credit card different is that it isn't going to provide the profile holder that has a credit line Chances are you'll miss entirely or will hit a outer tips but with more than enough practice you will begin to click the bullseyes Secured approval for loans are rare, although as long as needing your promise of for-all as it will take to accomplish the program If you are careful you can save lots of money by finding the company that will charges the best fees and interest Custom pet dog tags is often personalized around so many approaches, it will depend within the specification plus the imagination with the wearer
Visit my web page :: bad credit loans
Hi! many thanks a whole lot for this convenient video. By the way, I notice
lots of people maintain on talking about dating program called Sozofintao Dating Manual (search on google), but I'm not certain if it is truly good. Need you tried Sozofintao Dating Guide? I've heard
many awesome issues about it and my cooworker finally
get set by hot women making use of it, but
he refuses to tell me: (
Review my weblog: dating advice for girls youtube
Heya! I'm at work browsing your blog from my new iphone 3gs! Just wanted to say I love reading your blog and look forward to all your posts! Carry on the great work!
My blog post - vigorelle ingredients
Hi there! I know this is somewhat off topic but I was wondering which blog
platform are you using for this site? I'm getting fed up of Wordpress because I've had
issues with hackers and I'm looking at alternatives for another platform. I would be awesome if you could point me in the direction of a good platform.
Feel free to visit my site; eyelasticity amazon
can you upload one as to victory the lottery with subliminal messages and scrypts
on screen. say thanks a ton. i appreciate a great deal the work.
montreal.
Take a look at my weblog - nline dating apps
It's not sex' per assert that can help the man attract, it is definitely just like in any guy; confidence, profile, inner power, gentlemanliness, etc.
..
Here is my weblog; codeforpizza.com
Greetings! Quick question that's totally off topic. Do you know how to make your site mobile friendly? My site looks weird when viewing from my iphone. I'm trying
to find a template or plugin that might be able
to correct this problem. If you have any suggestions, please share.
Thank you!
my web blog; semenax ingredients review
Very good article. I am facing a few of these issues as well.
.
My web blog ... http://www.homehealthstartup.org/
This article will help the internet viewers for
creating new web site or even a blog from start to end.
My blog - genf20 plus
Your style is unique compared to other folks I have read
stuff from. Thank you for posting when you've got the opportunity, Guess I'll just bookmark this site.
Also visit my homepage :: UK hosting
Thanks so much for vehicle drivers. really helpful site!
Review my web blog; xerox phaser 8560dn
Intimately, the posting is in world the greatest on this worthw hile topic.
I match in with your conclusions and will eagerly look forward to your upcoming changes.
My web page ... adult Acne
I do not even know how I ended up here, but I thought
this post was great. I don't know who you are but definitely you're going to a famous blogger if
you aren't already ;) Cheers!
Also visit my blog post Skinception Eyelasticity - -
i have two cracks on my plasma and i am going to dare and try the
jelly... but first i have some questions... since the jelly is just .
..well jelly. all this would be doing for me is covering the crack right?
but it will not fix it right? the crack will continue to run and make the situation worse if
all i do is continue to cover the crack with jelly.
So for the people whom try the jelly you would still recomend
repair because the jelly would only be to hide cracks not fix them
Here is my web page: LG 42ls5600
Awesome article.
Feel free to surf to my webpage - xerox 8560 review
Having the right Path of Exile currency can make a big difference in your game. You can upgrade your character's equipment, trade for items, and build rare items. But it's important to know the values of different items, and how to avoid trading scams. check here to get more information about Buy poe currency.
Post a Comment