2] How to Setup Ragnarok Online RO MYSQL Database


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.]



MySQL 5.0.45



MySQL GUI Tools 5.0-r12

[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:

Anonymous said...

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 !

Anonymous said...

please help me about the [SQL]access denied for user 'ragnarok'@'%' to database ragnarok.

thanks in advance please help mee

Anonymous said...

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!

Anonymous said...

i dont have mail.sql and which upgrade.sql should i execute

Anonymous said...

the upgrade SQL with the biggest number. if it has main in it, apply that first b4 executing the upgrade-SQL######.

Anonymous said...

"click Quadruple (4) times on it."

when i click 4 times on it nothing comes up

Anonymous said...

What do you mean by any place between the white screen? I can't find the place that lets me create a new column

Kendji said...

I don't have mail.sql too.
and I can't find the create new column

RQ said...

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?

pan2 said...

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?

Anonymous said...

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 =(

Anonymous said...

which sql upgrade I have to execute first?

GEE said...

dont have mail.sql..help me please...

Anonymous said...

Why it takes so long to conenct to MYSQL server instance until now It still connecting can someone help me?

Anonymous said...

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

Anonymous said...

plase help me

Blank™ said...

please help me with > " Do the same with Mail.sql and some latest upgrade.sql . " ..cannot find it.. T_T

Blank™ said...

can i run it with others program then iRo (Gravity)? can i use gameflier ragnarok? >> http://ro.gameflier.com

[ iiм εsнiяi ♥ ] said...

is it columns or rows? ._. i can't add columns, only tabs.. lawls

Unknown said...

is it okay if i download the latest mysql . the MYSQL 5.1.45??please reply asap

Unknown said...

is it okay if i download the latest MYSQL 5.1.45?

Anonymous said...

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

wany said...

i cant find mail.sql

wany said...

i cant find mail.sql

kenneth9864 said...

how to apply changes on msqyl plz help me

kenneth9864 said...

how to apply changes on msqyl plz help me

makidu said...

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

Rexaur Zurich said...

Yeah, there is no Mail.sql

So is it ok that we would skip the Mail.sql?

Anonymous said...

error 2003 when i click ok when i done with mysql adminstrator



Ok Ping

Hunter Season said...

same problem with kindly five.
error 2003.
what''s the problem???
please help!

Anonymous said...

if i already run the server . where i can log in and play ? help please

Anonymous said...

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 ..

Anonymous said...

what on earth ... it doesn't work !!!

Anonymous said...

Where The White Screen!!!!!!!!!!!!!!
I NOt Found IT

Anonymous said...

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

Anonymous said...

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

Sanjay Sam said...

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 :(

Sanjay Sam said...

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 :(

Dastgir said...

Those who want help can add me:
dastgirpojee@rocketmail.com

Dastgir Pojee said...

Those who want help can add me:
dastgirpojee@rocketmail.com

Bapet said...

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?

Anonymous said...

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

Anonymous said...

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

Anonymous said...

hermes bagsBirkin Handbags uhcc 2013 Hermes BagsHandbags Hermes mgcl

Anonymous said...

А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

Anonymous said...

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

Anonymous said...

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

Anonymous said...

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

Anonymous said...

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

Anonymous said...

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

Anonymous said...

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

Anonymous said...

Very good article. I am facing a few of these issues as well.
.

My web blog ... http://www.homehealthstartup.org/

Anonymous said...

This article will help the internet viewers for
creating new web site or even a blog from start to end.


My blog - genf20 plus

Anonymous said...

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

Anonymous said...

Thanks so much for vehicle drivers. really helpful site!



Review my web blog; xerox phaser 8560dn

Anonymous said...

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

Anonymous said...

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 - -

Anonymous said...

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

Anonymous said...

Awesome article.

Feel free to surf to my webpage - xerox 8560 review

Zerrnys said...

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.

game servers, game server, online game server, gaming server, game server providers, mohaa game server, game server provider, dedicated game server, dedicated game servers, game server hosting, gaming servers, dedicated gaming server, dedicated gaming servers, multiplayer game server, best game servers, rent a game server, game hosting servers, game servers, game server, online game server, gaming server, game server providers, mohaa game server, game server provider, dedicated game server, dedicated game servers, game server hosting, gaming servers, dedicated gaming server, dedicated gaming servers, multiplayer game server, best game servers, rent a game server, game hosting servers, game servers, game server, online game server, gaming server, game server providers, mohaa game server, game server provider, dedicated game server, dedicated game servers, game server hosting, gaming servers, dedicated gaming server, dedicated gaming servers, multiplayer game server, best game servers, rent a game server, game hosting servers, game servers, game server, online game server, gaming server, game server providers, mohaa game server, game server provider, dedicated game server, dedicated game servers, game server hosting, gaming servers, dedicated gaming server, dedicated gaming servers, multiplayer game server, best game servers, rent a game server, game hosting servers,