MySQL

Setting up a LAMP (Apache, MySQL, PHP) development environment on Ubuntu 14.04 (Trusty) LTS for local Drupal/Wordpress development

This is how I normally set up my local Drupal development machines after a fresh Ubuntu 14.04 LTS (desktop/MATE edition) install.

1. Install required packages

From Terminal, execute the following command to update the repository information and to get the system up-to-date:

sudo apt-get update
sudo apt-get upgrade

Next, install some basic necessities:

[SOLVED] How to Fix on Ubuntu/Debian linux - MySQL/MariaDB: Out of resources when opening file (Errcode: 24)

This is an issue which occurs due to the maximum number of open files allowed for a process (mysql in this case) being very less that what is required - something that happens because you have lots of large tables / a large DB. To fix this, you just have to increase the limits in a few places.

Here is how you do it:

Step 1: Identify the issue
as limit on the max number of open files (1024) for a single process (mysql) by doing these as root user:
ulimit -a | grep open

Setting up a LAMP (Apache, MySQL, PHP) development environment on Ubuntu 13.04 (Raring) / 12.10 (Quantal) / 12.04 (Precise) for Drupal/Wordpress development

Setting up a LAMP (Apache, MySQL, PHP) development environment on Ubuntu 11.04 (Natty) / 11.10 (Oneiric) for Drupal/Wordpress development

 
Package Installation
From Terminal, execute the following command to install the required packages:

sudo apt-get install apache2 mysql-server mysql-client php5 libapache2-mod-php5 php5-gd php5-mysql php5-cli  php5-curl kcachegrind  php5-ffmpeg php5-mcrypt php5-imagick php5-xdebug phpmyadmin

Additional Configuration

1. To fix the Fully Qualified Domain Name issue for Apache

Setting up a LAMP (Apache, MySQL, PHP) development environment on Ubuntu 11.04 (Natty) / 11.10 (Oneiric) for Drupal/Wordpress development

Setting up a LAMP (Apache, MySQL, PHP) development environment on Ubuntu 11.04 (Natty) / 11.10 (Oneiric) for Drupal/Wordpress development

 
Package Installation
From Terminal, execute the following command to install the required packages:

sudo apt-get install apache2 mysql-server mysql-admin mysql-query-browser mysql-client mysql-navigator php5 libapache2-mod-php5 php5-gd php5-mysql php5-cli  php5-curl kcachegrind  php5-ffmpeg php5-mcrypt php5-imagick php5-xdebug phpmyadmin

Additional Configuration

1. To fix the Fully Qualified Domain Name issue for Apache

Services

Advantages

  • Excellent Programming Skills
  • Level 4 Administration Skills
  • Excellent Research Skills
  • Smooth Communication
  • Flexible Work Hours
  • Reliable Support

Services

  • System Administration

    • Operating Systems:
      • Linux - CentOS / Ubuntu / FreeBSD / Mandriva
      • UNIX
      • Windows
    • Web Servers:
      • Apache
      • nginx
      • lighthttpd
    • Databases:
      • MySQL
      • PostgreSQL
Subscribe to RSS - MySQL