Hello everyone, I host a server and I bought a dedicated server. I use theforgottenserver(the newest version) and Gesiors site. I've reoved phpmyadmin from xampp and still my server got hacked by a guy, I don't know HOW, but he managed to give everyone level etc.. So I wonder what can I do to protect my server?
Hacking problem!
- Thread starter Saj
- Start date
Oooh, I will use your hints charizard, thanks a lot, but I dont understood one part, can you EXPLAIM me, how to make a backup of the database? Step by Step pls, Im kinda newbie in that field.
sorcerers king
spo
WoW Just search on the forums On pro for ur server!
Blue Charizard
Blue where it counts
Making a backup of your database can be done by either downloading MySQL administrator, and executing backups through there, or by downloading a program which executes backups automatically at a certain time.
To execute a backup manually using MySQL administrator, just do the following:
1. Download the MySQL GUI Tools pack from MySQL :: MySQL GUI Tools Downloads
2. Run MySQL administrator and login using either your root username/password, or use the user/password of a mysql user which has access to your otserv database.
3. On the menu to the left, click "Backup".
4. Click "New Project".
5. Give a name to your project, the file which contains the backup will have the name that you type in, follwed by the date and time when the backup was executed.
6. On the list below, click on the otserv database (or whatever name your otserv database uses)
7. Click on the ">" button, and make sure all the otserv database stuff has a checkbox.
8. Click the "Execute Backup Now" button.
9. Select where to save your backup.
10. Once the thing has finished, you now have a complete backup of your otserv database in the location you chose, which can be restored at any time.
There, i hope that will help a few people make their database a little less prone to complete destruction by scriptkiddie hackers that doesn't have a life
To execute a backup manually using MySQL administrator, just do the following:
1. Download the MySQL GUI Tools pack from MySQL :: MySQL GUI Tools Downloads
2. Run MySQL administrator and login using either your root username/password, or use the user/password of a mysql user which has access to your otserv database.
3. On the menu to the left, click "Backup".
4. Click "New Project".
5. Give a name to your project, the file which contains the backup will have the name that you type in, follwed by the date and time when the backup was executed.
6. On the list below, click on the otserv database (or whatever name your otserv database uses)
7. Click on the ">" button, and make sure all the otserv database stuff has a checkbox.
8. Click the "Execute Backup Now" button.
9. Select where to save your backup.
10. Once the thing has finished, you now have a complete backup of your otserv database in the location you chose, which can be restored at any time.
There, i hope that will help a few people make their database a little less prone to complete destruction by scriptkiddie hackers that doesn't have a life
Making a backup of your database can be done by either downloading MySQL administrator, and executing backups through there, or by downloading a program which executes backups automatically at a certain time.
To execute a backup manually using MySQL administrator, just do the following:
1. Download the MySQL GUI Tools pack from MySQL :: MySQL GUI Tools Downloads
2. Run MySQL administrator and login using either your root username/password, or use the user/password of a mysql user which has access to your otserv database.
3. On the menu to the left, click "Backup".
4. Click "New Project".
5. Give a name to your project, the file which contains the backup will have the name that you type in, follwed by the date and time when the backup was executed.
6. On the list below, click on the otserv database (or whatever name your otserv database uses)
7. Click on the ">" button, and make sure all the otserv database stuff has a checkbox.
8. Click the "Execute Backup Now" button.
9. Select where to save your backup.
10. Once the thing has finished, you now have a complete backup of your otserv database in the location you chose, which can be restored at any time.
There, i hope that will help a few people make their database a little less prone to complete destruction by scriptkiddie hackers that doesn't have a life
Its possible to connect using this program to other ip than local? becuse for me it dont working only localhost
Hmmm, kinda hard, or hard to uinderstand xP, u said there is a program that make backups automatically, where I can download that program? and can u explain me to use that program too >.< Im shy to ask u that much but i really need it>.<.
Thanks charizard
Thanks charizard
Blue Charizard
Blue where it counts
Yes its possible, just fill in the right IP/hostname and port, and you can connect to remote mysql servers too.
(however if you disabled root access from a remote machine, when installing mysql, you cannot connect to the root account from any other machine than the computer mysql is installed on)
Well by program i ment "programs", there is alot of programs which does just that, though most of them is ment for big companies and costs money to use.
The program i use is called "Auto Backup for MySQL Professional Edition", however it costs money.
I dont know of any other program than that one, so i suggest you check google, allthough even if you were to get it, i cant really tell you how to manage that one, since its even more complex than MySQL Administrator.
AnasAshraf
New Member
why it's proplem i can give you a hacker make you hack real tibia!!!!
No nono, I mean, Blue charizard said "you can manage your database from another pc thats not the server nor hoster", I want to disable thta, It is possible?
For example: If I write "<host-ip>/phpmyadmin", it acces to the database from another machine, Its possible to disable that?
For example: If I write "<host-ip>/phpmyadmin", it acces to the database from another machine, Its possible to disable that?
Nikkster
Programmer
Use this guide to restrict anyone but you to enter PhPmyadmin. It's probably one of the safest ways.
For example:
This allows only those with the IP 123.456.7.890 and 11.22.33.44 to enter PhPmyadmin, aswell as your local computer (127.0.0.1). Ofcourse, you can take away one if you only want yourself to enter Phpmyadmin.
For example:
Code:
$cfg['Servers'][$i]['AllowDeny']['order'] = 'deny,allow';
$cfg['Servers'][$i]['AllowDeny']['rules'][] = 'allow % from 127.0.0.1';
$cfg['Servers'][$i]['AllowDeny']['rules'][] = 'allow % from 123.456.7.890';
$cfg['Servers'][$i]['AllowDeny']['rules'][] = 'allow % from 11.22.33.44';
$cfg['Servers'][$i]['AllowDeny']['rules'][] = 'deny % from all';
Doonrak
Banned User
- Joined
- Mar 2, 2008
- Messages
- 512
- Reaction score
- 0
Its the config.php file in phpmyadmin folder.
Similar threads
