• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

MySQL [COMPLETE TUTORIAL]How to setup a server!

exique

Natala-ot.com
Joined
Sep 28, 2008
Messages
1,673
Reaction score
25
Location
Sweden
This is the complete tutorial for you that know nothing about OTs / MYSQL on how to setup a own OT.
First check so you got all necessarily ports open in your router /firewall. Ports: (
7171/7172/80)

If you dont know how to open the ports you can use:
PortForward.com - Free Help Setting up Your Router or Firewall


After opening the ports you can check if they are open on:
Open Port Check Tool

After that you need to download xampp:

Here you got all xampp files.
Just download the latest version (installer).

84533826.jpg


Click in Apache and MYSQL it's absolutely necessarily !

After installing go to:
http://localhost/security/xamppsecurity.php

You can choose to save the password as a text file.
It's good to have a backup if you forget! So I suggest you save it there just in-case!

After choosing you password you need to restart Apache and Mysql.
You can do it two ways:

Go to your xampp folder and press the "Xampp restart".

Or you can use the xampp control panel which might be usefull in the future!
Hit the Stop buttons and then press the Start button which will appear after you have stopped.
18830275.jpg


After that go to:
http://localhost/phpmyadmin/

Then enter root as user name and your password under it.
After logging in there is one thing you need to do to make your server even more secure..
Do this:
30337189.jpg


DROP USER 'pma'@'localhost';
After that you should download a server to start with..
There is many good servers.. but I recommend 0.2.4 which you can get by clicking here.
After downloading the server you will need to download the dll files here.

Once finished with downloading the dll files you will need to extract them into the server. (Only the dll files.. Not the whole map.)

Now you will need to go into the config.lua and change these things:
-- MySQL
mysqlHost = "localhost"
mysqlUser = "root"
mysqlPass = "" <- your password
mysqlDatabase = "" <- name of your database (will come to that later)
mysqlPort = 3306

and the sql connection should be like this if you are using MYSQL.

-- SQL
sqlType = "mysql"
passwordType = "plain"
When you are done changing those things then you need to create a database!

So.. Go into
http://localhost/phpmyadmin/ again and login..
After logged in you can either create a new database or use the "test" database that's already there:

58608118.jpg


After you created you database you need to import "schema.mysql" or "forgottenserver.sql" depending on what server version you choose.

39716680.jpg


After that you are done! You got your own server!


[SHORT] How to create a GOD

First you will need to create a character and an account.
After that go to the "accounts" table and find your account and then change the account type to 5 and the group_id to 3.
After that you press "drive".

Then you got the "players" table and find you character and change the group_id to 3
and you can change the name to "GOD <nick>" if you want.


After that you've got a GOD!
Note: Your character has to be offline when you change this.

Feel free to add some reputation if you found this tutorial useful!
 
Last edited:
I think, thread name should be : How to setup database for otserv. Anyway nice :>
 
Great tutorial! I'll definitely refer players to this thread when asked for help setting up an OT!

Red
 
Very nice one indeed!

I suck at these kind of things and the only reason I am trying is because I want to learn more.

One question though, that probably some other random noob like myself are wondering about is:

"First check so you got all necessarily ports open in your router /firewall. Ports: (7171/7172/80/3306)"

Where do I check lol? :thumbup:

Might be an obvious answer to this one :blink: Anyway, rep+
 
Very nice one indeed!

I suck at these kind of things and the only reason I am trying is because I want to learn more.

One question though, that probably some other random noob like myself are wondering about is:

"First check so you got all necessarily ports open in your router /firewall. Ports: (7171/7172/80/3306)"

Where do I check lol? :thumbup:

Might be an obvious answer to this one :blink: Anyway, rep+

Well.. where you check is (it's included) Open Port Check Tool

Anyways..
Thanks for the positive comments :)
I will soon make a new tutorial how to setup a website ^^
 
i came up with the same problem symbolz but i persevered (got annoyed turned comp off and half hour later calmed down turned it bk on) and it worked so idk
 
Cool.. I'm now downloading XAMPP. then ill make the server!
I think my pc is fuull of Shi*! :S

Thanks +rep!
 
Back
Top