MySql, Uncategorized

How to check if InnoDB engine is enabled in MySQL

How to check if InnoDB engine is enabled in MySQL If you want to check , if InnoDB is enabled on the server , you can check this via two methods : [email protected][#] mysqladmin variables | grep have_innodb If the above command show the output as below : | have_innodb | YES then it means InnoDB …

Security, Uncategorized

How to disable root login in linux

How to disable root login in linux  Login to shell. Copy and paste below command to server using your favourite editor. pico -w /etc/ssh/sshd_config Find the line Protocol 2, 1 Uncomment it and change it to look like Protocol 2 Next, find the line #PermitRootLogin yes Un-comment it. It looks like PermitRootLogin no Save the …

Security, Uncategorized

How to check the RAID Drive Status

RAID – Redundant Array of Inexpensive Disks   How to check 3ware RAID drive status Login to the server via SSH. Paste the below command. 3ware /c0 show It will show the status of all RAID drives. If you are getting any error then try using the below RAID command. 3ware maint rescan How to check Adaptech RAID drive status …


SoftLink Scan

SoftLink Scan on the servers :   Hacker creates softlinks under one account and makes link with other users. This way he can hack other accounts. So how to find such compromised account under which hacker has created softlinks.   Following is the command which scan on the server and generates result in file: /root/found_links.txt …

Installation, PHP

How to install memcache

How to install memcache Definition: Memcache is a high-performance memory object caching system intended to speed up dynamic web applications by alleviating database load. Memcache is extremely fast. It uses libevent, which provides a mechanism to execute a callback function when a specific event occurs on a file descriptor, to scale to any number of open …

MySql, Uncategorized

How to take Database Backup using phpMyAdmin

How to take Database Backup using phpMyAdmin. First you need phpMyAdmin which is a MySQL Database Administration Tool. 1 – Open phpMyAdmin 2 – Click on Export 3 – Under Export – Select the database you want to backup 4 – Select SQL 5 – Select Structure, Add DROP TABLE, Add IF NO EXISTS, Add …

MySql, Uncategorized

Mysql Commands

Mysql Commands: How to check mysql connection or login to your Database using shell ========================= [email protected][#] mysql -u username -p ========================= it will ask for password then provide the correct password.   Create Database on the Mysql Server ========================= mysql> create database [databasename]; ========================= ex : mysql>create database Dresses;   List all databases on the …


How to download the files forcefully using .htaccess

How to download the files forcefully using .htaccess without displaying it in browser   Create .htacceses file under your accout and insert the below code. AddType application/octet-stream .avi AddType application/octet-stream .mpg save and quit the file.