[Solved] phpmyadmin connection reset error

php logo

phpMyAdmin is a web interface use to work with MySQL database. It is possible to import/export database using phpMyAdmin. Sometimes, while importing/exporting database connection reset error may occur. Possible Reason: The error may occur due to network interruption or PHP memory limit. Solution: If there is no problem with the network connection then try increasing the PHP memory limit by …

Read More »

[Solved] phpMyAdmin not found Ubuntu

php logo

Installing phpMyAdmin using apt-get utility in Ubuntu is easy. While browsing phpMyAdmin link, your browser may start displaying error message as Not Found The requested URL /phpmyadmin was not found on this server. Considering that apache2 is used to access phpMyAdmin: 1) Open apache2 configuration in any editor vi /etc/apache2/apache2.confvi /etc/apache2/apache2.conf 2) Include following line in the configuration file Include …

Read More »

[How To] Convert Camtasia video file Camrec to Avi/MP4

camtasia logo

Camtasia is paid desktop recording software which saves the recorded files in the .camrec format. Such files could not be played by other players than Camtasia. Camtasia .camrec files can be converted to other video files like avi, mp4 using Camtasia itself. There is no need to use any other video converter software. There are two ways to convert the video …

Read More »

[How To] Clear bash history in Linux

shell image

Sometimes, sensitive commands are present in your server bash history. Another user logging in the server will be able to access history of your commands as Linux stores command in the .bash_history file of the user. To delete / clear the bash history of a user, execute following command: history -c && history -whistory -c && history -w The above …

Read More »

[How To] Enable MySQL Event Scheduler status

mysql logo

The event scheduler in MySQL needs to be enabled for some applications to work flawlessly. In this case, a small change is required in the MySQL configuration file my.cnf. Steps: 1. Open my.cnf file in your favourite editor vi /etc/my.cnfvi /etc/my.cnf 2. Add following line event_scheduler=onevent_scheduler=on This will enable MySQL event scheduler on the server. 3. Restart MySQL service /etc/init.d/mysql …

Read More »

[How To] Allow htaccess override in Apache

apache logo

The htaccess override is by default disabled in the Apache Webserver. If you wish to enable htaccess override then small change is required in the Apache configuration file. 1) CentOS/RHEL: Backup the Apache configuration file "http.conf" Open the "http.conf" file in your favourite editor and look for the string "AllowOverride". Change it from "AllowOverride None" to "AllowOverride All". Make sure …

Read More »

[How To] Resolve Google Play Store 923 error

google play store

The Android smartphone users may face issues while using Google Play Store to update/install application with 923 error. Even restarting the phone will not help. In this case, you have to follow some simple steps to resolve the problem 1) Go to Settings > Applications > Google Play Store > Click on Clear Cache 2) Go to Settings > Applications …

Read More »

[Solved] Another mysqld server running on port: 3306

mysql logo

MySQL service may start throwing errors as below while starting/restarting the MySQL service on a Linux server [ERROR] Can't start server: Bind on TCP/IP port: Address already in use [ERROR] Do you already have another mysqld server running on port: 3306 ? [ERROR] Aborting Looking at the error, it seems to be an issue with the MySQL port 3306. Solution …

Read More »

Disk space usage alert script - Linux

shell image

The disk space usage script is created to check the disk space usage and send alerts when disk space usage is critical. #Purpose: Script to check disk space usage and send alert on critical usage. #Created by: Abhijit Sandhan ##################################################### df -H | grep -vE '^Filesystem|tmpfs|cdrom' | awk '{ print $5 " " $6 }' | while read output; do …

Read More »

WordPress 3.9 "Smith" Released

wordpress-logo

The most awaited WordPress version 3.9 "Smith" is released on 16th April 2014 to all. The new version looks promising and can be easily updated from the dashboard in a minute. To know the new features, click here To know the change logs, click here To know how to update WordPress, click here Important: Don't forget to backup the website …

Read More »

[How to ] Fix OpenSSL for Heartbleed Vulnerability

openssl heartbleed image

As you are all aware of the latest OpenSSL vulnerability termed as "Heartbleed", many blogs are providing information what it is and how does it affects. I am going to focus on fixing the OpenSSL Heartbleed vulnerability in this post. Which OpenSSL versions are affected? The OpenSSL version 1.0.1 is vulnerable except version 1.0.1g. Other versions like 1.0.0, 0.9.x are …

Read More »

[How To] Install Apache Maven in Linux, Solaris and Mac OS X

apache logo

The Apache Maven tool is used to build Java projects. It is very important to set Maven environment variables in order to execute the Maven commands. This post will explain how to set Maven environment variables in Linux. 1) Download Apache Maven binary archive under /opt partition from here 1 2 cd /opt wget http://mirror.olnevhost.net/pub/apache/maven/maven-3/3.0.5/binaries/apache-maven-3.0.5-bin.tar.gzcd /opt wget http://mirror.olnevhost.net/pub/apache/maven/maven-3/3.0.5/binaries/apache-maven-3.0.5-bin.tar.gz 2) Extract the archive …

Read More »

[How To] Hide last seen, profile photo, status on WhatsApp

whatsapp logo

WhatsApp - one of the widely used messaging application on Iphone and Android has finally introduced additional privacy features to making it more secure. One can now choose who can/can not view profile photo, status and last seen on WhatsApp. This additional privacy features are available by updating WhatsApp to the latest version for both Iphone and Android. For Android …

Read More »

[How To] Google web fonts HTTPS (SSL) support

google web fonts logo

Google Web Fonts are widely used in the websites because of the large number of fonts availability. Most of the websites are using SSL to encrypt the connections (HTTPS) and some simple connections (HTTP). Google Fonts over  SSL (HTTPS) may not be served and in this case the website may look odd to the visitors in terms of the fonts. …

Read More »

[How To] Enable NTFS support on Ubuntu/CentOS/RHEL/Fedora

Linux logo

The Linux operating systems supports NTFS partition format. To enable NTFS partition support, there are some packages required to be installed. To enable NTFS support on Ubuntu: 1 # sudo apt-get install ntfs-3g# sudo apt-get install ntfs-3g CentOS/RHEL: 1 2 # yum install ntfs-3g # yum install ntfsprogs ntfsprogs-gnomevfs# yum install ntfs-3g # yum install ntfsprogs ntfsprogs-gnomevfs Note: Enable rmpforge …

Read More »