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?]
2] Guides on Setting up Ragnarok Online
Server MYSQL Database.
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
Install MySQL 5.0.27
-Choose Typical and then click Next.
-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
-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
Password: (enter the password you have created before for the user root)
-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
Confirm Password: ragnarok
Click Apply Changes when you are done.
-When you are done, exit MYSQL Adminstrator.
-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
-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
Password: [enter the password we created before for root]
Default Schema: ragnarok
-Click OK to create a new ragnarok schema.
-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.