Jump to content

Recommended Posts

Posted

Hey Guys

 

I know many people who have problems with configurating the MySQL server, becouse of this I have decided to make a tutorial, in which i will show you how to set up a L2J server without MySQL.

 

ATTENTION: THIS IS NOT A FULL GUIDE IT'S ONLY A EXTENSION TO THE NORMAL GUIDE!!

 

first some things i want to say:

1.I'm 17 years old an go to school, my englisch is not perfect! please don't critizise my englich skills!

2. This is my first tutorial, but I will give my best to write correctly and explain it as good as I can.

3.This is not a Funtopic,it is possible to set up an L2J server without MySQL server

4. in this tutorial I will use L2J Interlude

 

Ok let's start.

 

First of all you will need

xampp

then you will need

Navicat

and then the Interlude or other L2J packs.

 

If you have download xampp, you have to install it.

Choose you language, and follow the instructions.

When the Setup finished look on your Desktop, you will have an xampp shortcut there.

Open Xampp and Start Apache & MySQL, Now tick the box SVC on the Left of MySQL.

bTSnA.jpg

 

Xampp includes his own MySQL server this is the reason, why you Don't need to Download MySQL.

Xampp has setup you MySQL server with the Default configuration "root@localhost" use Password NO

 

seems your loginID is root and a PW is not set.

 

now you have to install Navicat:

Open Setup.exe and follow the instructions.

After you have installed Navicat you have to create a new Connection

V2SbG.jpg

 

 

Type 'Localhost' in the field: Connection Name

EwNkT.jpg

 

DONE!

 

now Extract the L2J packs in a folder and go to 'tools' and start database_installer.bat

 

Now the Funny part begins:

 

You have to Change the MySQL path to the Path of xampp.

 

Still type 'C:\xampp\mysql\bin' and press enter

OhJwF.jpg

 

Then set the configuration like in the picture below:

 

vw4AY.jpg

 

Now the database will be installed

 

Following steps will be explained HERE

 

if you follow my instructions you wouldn't have problems with set up L2J server

 

I hope this will help some people who have problems with MySQL!

 

Greetz

Horizons

Posted

You wanted alternative for MySQL so you decided to use MySQL??? You just instaled same MySQL just it was included in xampp package. You're still using it, so this all "GUIDE" makes absolutely no sence.

Posted

You wanted alternative for MySQL so you decided to use MySQL??? You just instaled same MySQL just it was included in xampp package. You're still using it, so this all "GUIDE" makes absolutely no sence.

 

@xuinia:

Posting spam is not tolerated in these forums.

 

On topic:

I have heard that, at least in earlier xampp versions, the MySQL is configured either in aggressive mode, which may cause CPU spikes whenever MySQL service is not idle, or in regressive mode, which provides really, really low performance, which is generally unacceptable in l2j.

Care to elaborate?

 

@an0s:

If MySQL did not work, xampp will not work as well.

Only if you knowingly messed up MySQL installation, only then xampp will work.

Posted

Only if you knowingly messed up MySQL installation, only then xampp will work.

Yes i messed up the installation now i can't install it

Posted

@xuinia:

Posting spam is not tolerated in these forums.

What I wrote has nothing to do with spam.

Topic says: How to set up L2J server without MySQL server

And inside topic he explains how to set up a server by using MySQL...

xampp is a package, containing apache + php +  MySQL. So he's still using same mysql, just it is installed by xampps installer.

Posted

What I wrote has nothing to do with spam.

Topic says: How to set up L2J server without MySQL server

And inside topic he explains how to set up a server by using MySQL...

xampp is a package, containing apache + php +  MySQL. So he's still using same mysql, just it is installed by xampps installer.

sry maybe I have say it with wrong words. I mean how to set up l2j without MySQL server 5.1 (the programm)

xampp contains mysql , thats right but it's much easier to install and configure. that what I meant.

 

Thats why I decided to make the guide

 

and btw. If Mysql server 5.1 Doesnt work, you can unistall it and & install xampp. Xampp will set all mysql settings to default.

 

In any case it works at my PC. And I think xampp is a good alternative to MySQLserver 5.1

  • 5 weeks later...
Posted

At least to me this is completely USELESS, since having some programs in one package. would make you risk to have a facked up config [some crashes too], you will always run that risk because you do not know when all the process on xampp [shitty program like wamp (that's what i think)] will crush and make a mess.

About using this, might be ENOUGHT [only that] if you are testing yet, with your friends are finding bugs, and so on, but for a live server, i will never recommend this, if you want to have a server performancing well, you need to use mysql community board [from official site].

 

P.S. I read few people said that have messed their mysql so didn't know what to do to make their server .. well about that, you just need to clean your computer, going to delete ghost files [hidden and missing to be deleted ones] and deleting that from services list, and one more thing, installing that with another service name [not mysql anymore, for example use any of the other options like mysql55, mysql5, mysql5.1 and so on].

 

Thanks for sharing this guide, i aprecciate the time you have spent to make this, but remember one thing, althought be difficult to clean your computer to back to use mysql [official one], will be better for a better performance.

 

Greets ;D

Posted

At least to me this is completely USELESS, since having some programs in one package. would make you risk to have a facked up config [some crashes too], you will always run that risk because you do not know when all the process on xampp [shitty program like wamp (that's what i think)] will crush and make a mess.

About using this, might be ENOUGHT [only that] if you are testing yet, with your friends are finding bugs, and so on, but for a live server, i will never recommend this, if you want to have a server performancing well, you need to use mysql community board [from official site].

 

 

P.S. I read few people said that have messed their mysql so didn't know what to do to make their server .. well about that, you just need to clean your computer, going to delete ghost files [hidden and missing to be deleted ones] and deleting that from services list, and one more thing, installing that with another service name [not mysql anymore, for example use any of the other options like mysql55, mysql5, mysql5.1 and so on].

 

Thanks for sharing this guide, i aprecciate the time you have spent to make this, but remember one thing, althought be difficult to clean your computer to back to use mysql [official one], will be better for a better performance.

 

Greets ;D

maybe it is useless for you but usefull for sb else...But you have to respect other ppls work anyway...Express your feelings in a better way.Anyway it's helpfull for these who have probs with mysql.....

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



  • Posts

    • The Time Has Come!    Tomorrow, L2DoubleDamage officially launches! Get ready for epic PvP battles, legendary rewards, and tons of action-packed features!    Opening Date: February 28, 2025  Opening Time by Country:  Greece: 20:00  Brazil: 15:00  Russia (Moscow): 21:00  Argentina: 15:00  Important Note: The donation weapons, armors, and jewelry will be closed for 2 days for the donors.   Key Features:  100% PvP Full Balance – No Pay to Win!  Ultra Stable – No Wipes, Long-Term Project!  Siege Castles: Giran, Aden, Rune  Giran Siege Reward: 100€ Real Money! (Every week after: 50€)  VIP Autofarm: x2 Drop & Name Color Change  6 Grand Bosses & 6 Special Grand Bosses!  Casino – Try Your Luck & Win Big!  Daily PvP Events – Show off your skills!  Enchant Rates: Safe +6, Max +25  JOIN NOW and prepare for the ultimate PvP experience! Check out the official links below:    Website: L2DoubleDamage  Discord: Join Here  Instagram: Follow Us  YouTube: Watch the Trailer  Facebook: Like Our Page  Get ready! The adventure begins tomorrow!    🚀 JOIN NOW & Experience the Best PvP Gameplay Ever! 🚀 🌐 Website: http://www.l2doubledamage.com/ 💬 Discord: https://discord.gg/l2doubledamage 📷 Instagram: https://www.instagram.com/l2doubledamage/ 📘 Facebook: https://www.facebook.com/profile.php?id=61573159438765&sk=about_contact_and_basic_info 📺 YouTube:  
    • 🔥 L2Custom.com - FRESH START/WIPE! 🔥 🗓️ Wipe/Open Date: 2025-03-01, 18:00 GMT+2 ⚔️ Chronicle: Interlude | Rates: High 🌟 Key Features: ✅ Custom Items – Enhanced PvP Experience ✅ Full Buffer – No Hassle, Just Action ✅ Olympiad (A-Grade Only) – Every Week ✅ Castle Sieges – Every Week 🚀 Fresh Start – Dominate from Day 1! Gather your clan, forge alliances, and prove your strength on the battlefield! 🌐 Join Now: www.l2custom.com 💥 Don’t miss out on the ultimate PvP experience! 💥
    • A new template is available: Ancient-World - Responsive HTML Template    
    • We are still taking new orders! Let us talk on Telegram!
    • Hello. Looking for bot for L2 Reborn x1 Origin. Some1? L2adrenaline dont work ;/
  • Topics

×
×
  • Create New...