Log into Plesk control panel on your dedicated server:
1. Click Websites & Domains
2. Click on Databases
Creating a MySQL Dump File
Run the following command to dump a database:
# mysqldump database_name > Database_name.sql
For example, you want to dump a database called “mydb”.
# mysqldump mydb > mydb.sql
How to Reset a MySQL root Password
1. # /etc/init.d/mysqld stop
2. Start MySQL server without password:
# mysqld_safe –skip-grant-tables &
Check Apache Version on a Dedicated Server
1. Login to your dedicated server as root user.
2. Use the following command:
# /usr/local/apache/bin/httpd -v
Server version: Apache/2.2.16 (Unix)
Server built: Feb 6 2012 11:41:41
Checking Your Dedicated Server for a DDOS Attack
You can use the following commands on a Linux server to determine if your dedicated server is being DDOS attacked.
# netstat -anp |grep ‘tcp\|udp’ | awk ‘{print $5}’ | cut -d: -f1 | sort | uniq -c | sort –n
This command will show you the list of IP’s which have logged in is maximum number of connections to your server.
How to Use sudo to Assign Root Access to a User
Using Netstat Command
Netstat is a tool in the Linux which can be used to monitor network services. It dictates you about the processes that are using a port. Netstat displays all the ports in use and used by all of the processes, however, you can limit those to only a specific port simply by using the “grep” command.
How to Setup a LAMP Server on CentOS 6
Setting MaxClients in Apache/prefork MPM
- Determine how much RAM is available to Apache
- Determine how much RAM each Apache process uses
- Set MaxClients to: (RAM available to Apache) / (RAM per Apache process)
Read More
Securing OpenSSH
OpenSSH (or Secure SHell) has become a de facto standard for remote access replacing the telnet protocol. However, a default installation of ssh isn’t perfect, and when running an ssh server there are a few simple steps that can dramatically harden an installation.
