Month: August 2014

Enable mod_rewrite in Apache2 on Debian or Ubuntu

Apache2 web server boasts of extensible features which are realized by the notion of pluggable modules. When building Apache2, you compile a set of modules you think are necessary, into it. One such module is called mod_rewrite which is responsible for rewriting website URLs at the …

Uninstall and remove Apache2 on Ubuntu or Debian

Here is how you remove Apache2 cleanly on Ubuntu and Debian. The first step is to stop any running instance of Apache2, because Apache2 will not be properly removed while it is running. $ sudo service apache2 stop Then uninstall Apache2 and its dependent packages. Use …

Setup HTTPS in Apache web Server on CentOS

Web servers use HTTP by default, which is a clear text protocol. As the name suggests, a clear text protocol does not apply any form of encryption on the transit data. While the HTTP-based web server is very easy to set up, it has a major …

Using NGINX as a Web Server for Drupal

Nginx (engine-x) is a web server that is regarded to be faster than Apache and with a better performance on heavy load. The difference is summed up succinctly in a quote by Chris Lea on the Why Use Nginx? page: "Apache is like Microsoft Word, it has a …

Setup & Configure A LEMP Server

1. Choose A Linux Flavor. The first letter in L.E.M.P. stands for “Linux” – so before we begin configuring anything, we first must choose and install a linux distro. As this tutorial does NOT install any control panels such as cPanel/WHM, I highly recommend Ubuntu* as …

Enable Root User ( Super User ) in Ubuntu

Question: I’m unable to do su – on Ubuntu. It says “su: Authentication failure”. How do I fix it? Also, is it possible for me to login to Ubuntu using root account directly? Answer: Let us address these two question one by one.   Warning: Enabling …

Backup and Restore MySQL Database Using mysqldump

mysqldump is an effective tool to backup MySQL database. It creates a *.sql file with DROP table, CREATE table and INSERT into sql-statements of the source database. To restore the database,  execute the *.sql file on destination database. Using mysqldump, you can backup a local database …

Mysqladmin Command For Administering MySQL Server

In all the 15 mysqladmin command-line examples below, tmppassword is used as the MySQL root user password. Please change this to your MySQL root password. 1. How to change the MySQL root user password? # mysqladmin -u root -ptmppassword password 'newpassword' # mysql -u root -pnewpassword …

Change MySQL Root Password

These methods can be used on both Windows and Unix Environment including Ubuntu, Debian, CentOS, Fedora, RedHat, Arch Linux, SUSE etc., Method 1. How to Change MySQL Root Password Using mysqladmin Command? You can change the mySQL root password using mysqladmin command as shown below. Please …

Forgot MySQL Root Password – How To Reset It

Forgot your MySQL root user password? Don’t worry. We are here for rescue. When you tried to login to root without entering a password, you may get ‘Access Denied’ message, as MySQL is expecting a password. This article explains how to recover mysql root password by …

Install MySQL on Linux

Most of the Linux distro comes with MySQL.  If you want use MySQL, my recommendation is that you download the latest version of MySQL and install it yourself. Later you can upgrade it to the latest version when it becomes available. In this article, I will …

Repair Corrupted MySQL Tables Using myisamchk

MyISAM is the default storage engine for MySQL database. MyISAM table gets corrupted very easily. In this article, I’ll explain how to use myisamchk to identify and fix table corruption in MyISAM. When a table is created under MySQL, it creates three different files: *.frm file …

Migrate Microsoft SQL Server to MySQL Database

If you are using mostly open source in your enterprise, and have few MS SQL server database around, you might want to consider migrating those to MySQL database. The following are few reasons why you might want to consider migrating Microsoft SQL Server to MySQL database: …

Install Apache 2 from Source on Linux

All Linux distributions comes with Apache. However, it is recommended to download latest Apache source code, compile and install on Linux. This will make it easier to upgrade Apache on a ongoing basis immediately after a new patch or release is available for download from Apache. …