=eAthena SQL=

1.
Download eAthena SQL from my site.
Link

2.
Extract it to anywhere you want but not in your desktop.

3.
Go to Conf folder, open grf-files.txt and edit the patch where your RO folder is but default is C:\Program Files\Gravity\RO\

4.
Files we need to edit are char_athena.conf, and map_athena.conf.
Use Notepad or Wordpad to edit .conf files.

char_athena.conf
-Edit userid: s1 and user_pass: p1 for Server Account.
Just change s1 and p1 to anything you want that we need it later for MySQL in login table.
It's for to prevent ppl to hack your computer.
-Remove // for login_ip:, char_ip: and change 127.0.0.1 to your Internet IP (IP for letting ppl to connect to your server) but if you just want to test, then just use 127.0.0.1, which is Local IP/Computer IP.
-Now we are done with char_athena.conf so, just SAVE and exit.

map_athena.conf
-Edit userid: s1 and user_pass: p1 that need to be same as you edited in char_athena.conf.
-Remove // for char_ip:, map_ip: and change 127.0.0.1 to your Internet IP (read char_athena.conf)
-SAVE and exit.

Everything should be done now for eAthena Server side so, time to set up MySQL.

=MySQL=

1.
Download MySQL 5.0.27, MySQL GUI Tools 5.0-r8
This is for Windows
MySQL 5.0.45
MySQL GUI Tools 5.0-r12

NOTE: For other OS, check here Link

2.
- Install MySQL 5.0.27
-Click Next.
-Choose Typical and click Next.
-Click Install.
-Choose Skip Sign-Up and click Next.
-When It's finished, just click Finish and don't uncheck the Configure the MySQL Server now.
-Now, you can either choose Detailed Configuration or Standard Configuration, which is up to you but if you are unsure, just choose Standard Configuration and click Next.
-In Service Name:, pick MySQL5 and click Next.
-Just enter the password you wish for root and it's important to remember cause we need it later. Click Next.
-Just click the Execute and when done, just click Finish. Go to Task Manager and check if mysqld-nt.exe is running in processes although it's not necessary if no error occured during installation..

3.
Install MySQL GUI Tools 5.0-r8. We only need MySQL Administrator and MySQL Query Browser but just install everything.

4.
Start MySQL Administrator and it will prompt up a window. Fill in Host Name, Username and Password and leave other field as it is but to make sure everything is correct, it should look like this:

6.
-When you are in MySQL Query Browser, click once on ragnarok database that is below Schemata.
-Go to menu, click File and choose Open Script...
-We need to execute main.sql, mail.sql and log.sql (execute upgrade_svn* .sql files, too, if require) so, look for the main.sql, which should be in sql-files folder in eAthena Server and other .sql files.
-Pick main.sql and click Open.
-Click the Green Execute Icon to the upper right to execute. Do the same with mail.sql now and execute it.
-When you are done, we need to create log database by right-click somewhere within the table where the databases are and choose Create New Schema and type in log and click OK.
-Double-click on log database, go to menu, click File, choose Open Script..., open logs.sql and Execute.
-Double click ragnarok database to expand to see all tables.
-Look for login table and double click and double click again.
-Click once on Edit so, we can edit the cells. This icon should be in bottom.
-For userid: and user_pass:, type in the name that you used in char_athena.conf and map_athena.conf.
-When you are done editing, just click the Apply Changes that is next to the Edit icon.

NOTE: userid: and user_pass: must be same in login table, char_athena.conf and map_athena.conf.

7.
- In menu, click Tools and choose MySQL Administrator.
-Go to User Administration and click ragnarok user.
-Now, go to Schema Privileges and click once on ragnarok database/schema and click this button << and then click Apply changes. Do the same with log database/schema.

Now we are done with MySQL.

=Client Side=

1.
Download FullDATA from my site.
Link

2.
-Extract FullDATA to your RO folder so you have a data folder in your RO folder.
-Inside data folder, look for sclientinfo.xml and open it with Notepad. Put your WAN IP (Internet IP) there so you can login to your RO Server to play.
-Send your sclientinfo.xml to those ppl who want to play your server or just tell them your WAN IP.
-Now, just download Hexed client and extract to your RO folder. Use this Hexed client to play RO game.

Next set up is for hosting Ragnarok Online Control Panel, which is optional.

=Abyss Web Server & PHP=

NOTE: This is for user who is using MySQL 4.1.x and higher.
1. Download Abyss Web Server and PHP
Abyss Web Server
PHP 5.2.5

2. Create a folder name PHP in C: and extract PHP 5.2.3 in the PHP folder you created. Will be C:\PHP\
3. Go to C:\PHP\ext\ and copy php_mysql.dll to your PHP main folder, which mean in C:\PHP\
4. In PHP main folder, copy php.ini-recommended to your Windows folder. Rename php.ini-recommended to php.ini and open it with Worpad or Notepad but I would suggest Worpad. Look for this line ;extension=php_mysql.dll and remove this ; so it will be extension=php_mysql.dll. Save and exit.
5. Install Abyss Web Server first and choose if you want to manually start it or start it with Windows.
After installation and when ask if you want to run Abyss Web Server now, then choose YES.
It will run and configure in Internet Explore. Choose Language and you will be in next page. Type in your login name and password to make an account.
You will be in Abyss Web Server Console now. Click the Configuration button, which is next to Stop and select Scripting Parameters.
Check in Enable Scripts Execution
Click Add in Interpreters and click Browse..., go to the directory you installed PHP and select php-cgi.exe or just simple type in this C:\PHP\php-cgi.exe
In Type, choose PHP Style
Check in Use the associated extensions to automatically update the Script
In Associated Extensions, click Add and type in php and press OK
Now just click the OK

In Custom Environment Variables, click Add and enter this...
-------------------------------
Name: REDIRECT_STATUS
Value: 200
-------------------------------
Click OK when done and then click OK in bottom to go back to Configuration
Click Index Files icon, click Add and enter index.php and click OK
Everything is done for Abyss Web Server now.
NOTE: Abyss Web Server must be running if you want other people to access your webserver (ROCP or anything)

=Ragnarok Online Control Panel=

1. Download ROCP here
ROCP 4.3.4a

2. Go to Abyss Web Server folder and then to htdocs folder and extract ROCP 4.3.4a there or any version you have or want to use.
You can either make a new folder to put all ROCP files there or just put all files in htdocs folder.
Example, if I put all files in a new folder with the name CP433, then your ROCP page will be http://YourIPhere/CP433/
but if you just put all files in htdocs folder, then your ROCP page will be http://YourIPhere/
You can use IP 127.0.0.1 to test but if you want people can access your ROCP page, then they must enter your Internet IP or the IP they use to connect to your server.

3. Start MySQL Query Browser, go to File in menu and choose Open Script... and look for the install.sql, which should be in rocp\install\Athena & Freya\. So, just execute install.sql.
If you get error, then try to create a cp database manually. Right-click somewhere within where your ragnarok database is and choose Create New Schema and type in cp. Double-click the cp database you just created. Now just do as I explained in step 2.

4. In menu, click the Tools and choose MySQL Administrator. Go to User Administration and in User Information, enter this:
---------------------
MySQL User : cp
Password: cp
Confirm Password: cp
---------------------
Go to Schema Privileges, click the cp database below to highlight it and click this button <<
NOTE: If you have cp account in your login table, then you have to delete it otherwise ppl can use it to access your ROCP as Admin but you can simply edit it with other name and password.

5. Among all ROCP files... open config.php in Notepad and edit these lines:

Important:
$CONFIG['db_host'] = 'localhost';
$CONFIG['db_username'] = 'cp';
$CONFIG['db_password'] = 'cp';
$CONFIG['cp_db_name'] = 'cp';
$CONFIG['db_name'] = 'ragnarok';
$CONFIG['passphrase'] = 'whatever'; <- Enter any name/password here but no unique letter
$CONFIG['server_type'] = '2'; <- Must be 2

Optional:
$CONFIG['check_server'] = '1'; <- Enter 0 if you don't want it to check server status and 1 for checking server status
$CONFIG['accip'] = '127.0.0.1'; <- Your Internet IP (same IP as uses for eAthena Server)
$CONFIG['accport'] = '6900';
$CONFIG['charip'] = '127.0.0.1'; <- Your Intenet IP (same IP as uses for eAthena Server)
$CONFIG['charport'] = '6121';
$CONFIG['mapip'] = '127.0.0.1'; <- Your Internet IP (same IP as uses for eAthena Server)
$CONFIG['mapport'] = '5121';
$CONFIG['server_name'] = 'Server Name'; <- Enter your eAthena Server name here but it won't affect server side or anything.

You can look around in config.php and edit as you like.
NOTE: I recommend to use Live CP, which I think is better, but it's your decision.
Here is the Link and there is a guide, too. I am not in mood or just lazy to make guide for Live CP so.

Hope I didn't forget anything, so good luck =)