Server Communication username and password.userid: s1 passwd: p1
-Edit userid and passwd to any username and password you can remeber. You will need this later on in your MySql Database.
-Remeber to remove // for login_ip and char_ip and change the 127.0.0.1 to your internet(wan) ip. You can choose to use no-ip from Link .
-Now you are done with your char_athena. SAVE and exit .
-Edit userid and passwd to the same username and password you used eariler on for your char_athena.
-Remeber to remove // for char_ip and map_ip and change the 127.0.0.1 to the same internet ip you used eariler on in your char_athena.
-Now you are done with your map_athena. SAVE and exit.
Guides on Setting up MYSQL Database.
-Download MySQL 5.0.27, MySQL GUI Tools 5.0-r8 (for windows)
Please NOTE that: For other type of operating system, check this website: Link
2.) 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.
-Under Service Name Column, Choose MYSQL5 and then click Next.
-Just enter any password for this root user. Do not change the username and 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 MYSQL and reinstall everything again.
-Install MySQL GUI Tools 5.0-r8
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 the New User button.
-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.
-If you cant find it in your desktop, try finding it from your
C:\Program Files\MySQL\MySQL Tools for 5.0
-After you open MySQL Query Browser, a window should prompt out, it should be like:
Stored Connection: [just leave it empty]
Server Host: localhost
Password: [enter the password we created before for root]
Default Schema: ragnarok
Click yes 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, right click on ant database 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 back to 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 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 in your char_athena and map_athena.
-To make a gm 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 , put 99 for adminstrator.
-After you have done, click Apply Changes.
-You are now done with your MySql Database. EXIT now.
Guides On Setting Web Server and PHP
1.) [This is for user who is using MySQL 4.1.x and higher]
-Download Abyss Web Server and PHP
-Create a new folder and name it PHP in your Local Disk C:\ and extract PHP 5.2.5 into the PHP folder.
-Go to the C:\PHP\ext folder, copy php_mysql.dll and paste in into the PHP main folder C:\PHP
-In PHP main folder, copy php.ini-recommended, rename it to php.ini and paste it into your windows folder which can be found in your local disk C:\
-When you are done, go into your windows folder and open the php.ini with notepad or wordpad. Search for ;extension=php_mysql.dll and remove ; to make it look like extension=php_mysql.dll . Save and EXIT.
-Install Abyss Web Server.
-After you have installed the Abyss Web Server, open the abyss web server if it dosen't run. If the web server is running, you should see a blue in colour logo in your task bar which is located at your lower right hand corner. Right click on it and click Show Console. Choose your language normally we would choose english. Do so and continue.
-It will then ask you to input Access Credentials [Username and Password] (this is so that you have to login before being able to change things) Put whatever credentials you want but please remember them.You will be prompted for them every time you attempt to open the console, as you will after pressing OK for setting your Access Credentials. You can change your Access Credentials at any time at Abyss Web Server Console :: Console Configuration :: Access Credentials .
-After you have logged in to the abyss web server, Go to Console Configuration and then click on Paramters. Change the port to a port that is not blocked by ur ISP. Click OK twice and Restart.
-Next go back to Console Configuration and click on IP Address Control and change the Order to Deny/Allow if that's not what it's at by default. Press OK twice and Restart.
-Ok , now go back to the main page and click on the Configure button beside the Stop Button. When you are done, click on the Index Files and click add. Key in index.php and click ok.
- You should now be back to the Configure Page. Now click on IP Address Control and click on add. For the Virtual Path, key in / . Change the order to Deny/Allow. Press OK two.
-You shoyld now be back to the Configure Page. Click on the Scripting Parameters . Click Add in Interpreters column and click Browse, go to the directory you extracted your 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 type this in the column shown
-After everything is done, click Restart.
Guides On Setting Control Panel and Zend Optimizier
-Download Zend Optimizer 3.3.3 and LRLCP
Zend Optimizer 3.3.3 : Link
Lrlcp : Link
-Install Zend Optimizer 3.3.3
-Click Next and accepy the license agreement
-Select Other Web Server as you will be using Abyss Web Server
-Browse C:\Program Files\Abyss Web Server\htdocs as your root of web server.
-Create a new folder in C:\Program Files\Abyss Web Server\htdocs and name if after your ro, for example TestRo.
-Now, Extract the Lrlcp control panel into the C:\Program Files\Abyss Web Server\htdocs\TestRo
-Now you are done with your control panel.
-Open your MySql Query Browser and login into it.
-Right click on any database shown at the left column and click Create New Schema and name it after your ro. For example TestRo.
-Click once on TestRo and make sure it is bold.
-Go to menu, File, Open Script and open a file named install in your C:\Program Files\Abyss Web Server\htdocs\TestRo\Install\Install.txt
-Click on the Green Execute button.
-When you are done, close MySql Query Browser.
-Open MySql Adminstrator and login into it.
-Click on User Adminstration and click New User.
-Enter this into the columns
username: TestRo [Must be same as ur MySql Query Browser database]
password: use any password that is easy to remeber.
-Then, click Schema Privileges at the top.
-Click once ragnarok db and click this button. <<
-Do the same to log db and TestRo db
-Now you are done with your MySql Database and Control Panel
How to Create Ragnarok Online Private Server RO Private Server Guides Create Ragnarok Online Private Server Guides on How to Create RO Private Server Ragnarok Online Private Server or How to Make RO Private Server Ragnarok Online Private Server Guides for Free?.How to Make RO Ragnarok.How to Create Free RO Private Server How to Make Free RO Private Server,High Rate Ragnarok Online Private Server Guides,Ragnarok Online Control Panel and Abyss Web Server.How to Create Ragnarok Online Private Server RO Private Server Guides