First Step 1: is to download all of the following *Note: Navicat Download and MySQL download links are not mine, I borrowed them from another guide*
1) MySQL:

2) Navicat:
(Or if you want a free version of navicat go to the navicat site
and download the lite version. Works just the same.)3) Datapack - Freya (UPDATED):

4) Server Files - Freya (UPDATED):

*NOTE* - Because the servers are now on Freya, the installation may be a little different. If this guide continues to help you, then by all means use it. If it does not, please post a reply or pm me with the problem you're having and I'll do my best to help you. Everything is the same, up to the point where you configure your IP's and the gameserver/loginserver, that's where it gets a little different.
Step 2: Make a Lineage 2 Server folder in C:\ and name it whatever you want. For example I named mine "My Lineage 2 Server"

Step 3: Extract both your datapack and server files to the folder you just made. Make sure you extract them one at a time, I find it less complicates things. After finished, your folder should look like this:

Step 4: Now here is how to install navicat.






Step 5: Installing MySQL Server 5.1. It is important that you DO NOT change the directory of the install, and that you DO NOT already have a version of MySQL Server already installed. It may complicate making your server to run.
Now for the first part, just keep clicking next, next, next then install. After that's done you'll be asked if you want to "Config your MySQL Server" and "Register your MySQL Server Now"... uncheck the box beside "Register your MySQL Server Now". The config should look a little like this. Mine may differ from yours because I already have my server working.




Step 6: Now it's time to config your navicat. Follow the pics below. Open navicat, click on "Connection > MySQL"






Step 7: Now that you have your navicat setup properly it's time to install your database. So go into your Lineage 2 Server folder that you extracted your database and server files to and you should see a folder called "tools"... once inside double click database_installer and follow the on screen prompt. Type in EVERYTHING it says to type in for default except for your password. Your password is the password you used for MySQL.

Step 8: Now it's time to config your config files. server.properties and loginserver configs. Now this is an important step... If you just want to play alone and you have a router, then the InternalHostname HAS to be the ip of your computer. NOT the default gateway ip. The ip of your router. If you don't have a router and want to play alone, well, you'll just have to not give anyone your external ip address.
First, go to your gameserver > config > server.properties like in the pictures.





Now the next thing you have to go to your login folder where your gameserver folder and go login > config > loginserver





Step 9: Now it's time to register a name for your server. If you do not, the server will not run. After you register your server you'll get a file called hexid take it and paste it in your gameserver > config > folder. Like the following.



Step 10: Now it's time to register your first account. Follow the pictures, input your username and password and make sure the account access level is 100. Account and character access levels are different.



Step 11: Now it's time to see if your server works. If you followed this guide correctly... it should. Go to your login folder and double click startloginserver.bat Then go to your gameserver folder and double click on startgameserver.bat. Your server should run and look like this:




Now if you did this step by step. Every detail your server should work. If it doesn't you did something wrong. Reply back with pictures or a detailed summary of what's wrong with it and I'll try to fix it for you.
Just to show you guys that this guide works, I forgot to mention that while attempting this guide I screwed up my own server. So I deleted everything, went through the guide, and successfully re-hosted my server.
Also, one last thing I forgot to mention... if you want to play on your server alone, go to your hosts file located in C:\WINDOWS\system32\drivers\etc folder and open it up with notepad. You're going to want to add this line in: "Internal Ip Here" l2authd.lineage2.com internal ip where it says internal ip here without the quotes... for example: 192.168.XXX.XXX l2authd.lineage2.com and if you want other people to play in your server you're going to want to give them your external ip as found above. But it should look like XXX.XXX.XXX.XXX l2authd.lineage2.com but there's not always 3 numbers where the X's are. That's okay. Good luck!






