Nikkster
Programmer
How to setup MySQL [03-03-2010] Photos now! Version: 2.0
Welcome to my tutorial. The thread has been growing a lot and it's time to re-write the tutorial with new updated information.
Status: The tutorial is full but I'm still working on adding new things to the tutorial to keep you updated.
Please everyone, make sure that you have forwarded the ports
7171, 7172,80,3306
To verify that your ports have been forwarded properly, please use this tool: Open Port Check Tool
Port explanation:
7171/7172: Tibia Application
80: Web Application
3306: Database Application (MySQL)
Are you ready?
Let's start off by going to this page to download the latest XAMPP.
If you use Windows, please go to this link and choose the .exe or the .zip download:
apache friends - xampp for windows
If you use Linux, please go to this link and choose the .exe or the .zip download:
apache friends - xampp for linux
Then you install it. If you downloaded the Zip files, extract them to the HTDOCS folder which is located inside the XAMPP folder.
Once that is done, you can setup your XAMPP.
Go to this website:
http://localhost/security/xamppsecurity.php
And then you should come to a page that looks like this:
Enter the password you want for your database and then verify it and press the "Passwort ändret" button.
Then you will need to restart the XAMPP, otherwise your new password is not going to work.
After restarting the XAMPP, you can now login to your PHPMyAdmin and create a database. Go to http://localhost/phpmyadmin/ and follow the steps listed on the following pictures:
Now you will need to import the database. You will find the MySQL file in your open-tibia folder. Go to your PHPMyAdmin, login to the PHPMyAdmin if you are not logged into it already and then click on the Import tab.
Then click on the browse 'button' to open the mysql.sql file.
And finally, choose the mysql.sql file. This is usually located in /schemas/ in the latest Open-Tibia distributions nowadays.
Now when you have imported your database, you will need to configure your config.php. Open config.php in your Open-Tibia Folder. Search for "Database" or "MySQL" until you can see this:
Change the password to the one you picked in the XAMPP setup and then database you created during the setup.
When that part is done, everything should work fine.
If you're using a forgotten server, there is already an account manager built-in to the server, so just make an account using 1/1, when you have made your character and everything, go to your database and click on the player table. You can see your name there, to make the character to a god, change the group id to 6.
Now the character is a char. If you're using the newest schema.sql file, you only need to set the group id to 6 in your character and it will have a god position.
One thing is important if your character will be updated in the database, change the SQL type in config, you need to change from SQLLITE to MySQL, I don't know how to explain better but try to find an option where you can choose a database type.
Welcome to my tutorial. The thread has been growing a lot and it's time to re-write the tutorial with new updated information.
Status: The tutorial is full but I'm still working on adding new things to the tutorial to keep you updated.
Please everyone, make sure that you have forwarded the ports
7171, 7172,80,3306
To verify that your ports have been forwarded properly, please use this tool: Open Port Check Tool
Port explanation:
7171/7172: Tibia Application
80: Web Application
3306: Database Application (MySQL)
Are you ready?
Let's start off by going to this page to download the latest XAMPP.
If you use Windows, please go to this link and choose the .exe or the .zip download:
apache friends - xampp for windows
If you use Linux, please go to this link and choose the .exe or the .zip download:
apache friends - xampp for linux
Then you install it. If you downloaded the Zip files, extract them to the HTDOCS folder which is located inside the XAMPP folder.
Once that is done, you can setup your XAMPP.
Go to this website:
http://localhost/security/xamppsecurity.php
And then you should come to a page that looks like this:
Enter the password you want for your database and then verify it and press the "Passwort ändret" button.
Then you will need to restart the XAMPP, otherwise your new password is not going to work.
After restarting the XAMPP, you can now login to your PHPMyAdmin and create a database. Go to http://localhost/phpmyadmin/ and follow the steps listed on the following pictures:
Now you will need to import the database. You will find the MySQL file in your open-tibia folder. Go to your PHPMyAdmin, login to the PHPMyAdmin if you are not logged into it already and then click on the Import tab.
Then click on the browse 'button' to open the mysql.sql file.
And finally, choose the mysql.sql file. This is usually located in /schemas/ in the latest Open-Tibia distributions nowadays.
Now when you have imported your database, you will need to configure your config.php. Open config.php in your Open-Tibia Folder. Search for "Database" or "MySQL" until you can see this:
Change the password to the one you picked in the XAMPP setup and then database you created during the setup.
When that part is done, everything should work fine.
If you're using a forgotten server, there is already an account manager built-in to the server, so just make an account using 1/1, when you have made your character and everything, go to your database and click on the player table. You can see your name there, to make the character to a god, change the group id to 6.
Now the character is a char. If you're using the newest schema.sql file, you only need to set the group id to 6 in your character and it will have a god position.
One thing is important if your character will be updated in the database, change the SQL type in config, you need to change from SQLLITE to MySQL, I don't know how to explain better but try to find an option where you can choose a database type.
Last edited: