Ubuntu - Install a complete web server with Apache, PHP, MySQL and phpMyAdmin

Page 1 / 1
  • Published on : 08 March 2014 at 19:32 UTC
  • By Lionel Eppe

In this tutorial, we will install a full server web development including :
- Apache : The web server itself.
- PHP : to create dynamic websites.
- MySQL : The server database (which is the most used in the world of web).
- phpMyAdmin : The database tool management known worldwide, written in PHP.

 

1. Apache installation

Begin by installing Apache web server.

Code : Bash

apt-get install apache2

Once the server is installed, we will prevent the display of information about the server, displayed (for example) in a 404 error :
Apache/x.x.xx (Ubuntu) Server at 192.168.1.xx Port 80

To do this, add the following lines at the bottom of "/etc/apache2/apache2.conf" file :

Code : Apache

# Prevents display information from the server
ServerSignature Off
ServerTokens Prod

You can then give a name to your Apache server by adding the line below.

Code : Apache

# Server name
ServerName www.mon_domaine.com

Then restart the apache configuration to reflect the changes :

Code : Bash

/etc/init.d/apache2 reload

 

2. PHP installation

Then, install the "PHP" module in order to create dynamic websites.
Note: PHP will be automatically linked to your Apache web server.

Code : Bash

apt-get install libapache2-mod-php5 php5 php5-common php5-curl php5-dev php5-gd php5-idn php-pear php5-imagick php5-imap php5-json php5-mcrypt php5-memcache php5-mhash php5-ming php5-mysql php5-ps php5-pspell php5-recode php5-snmp php5-sqlite php5-tidy php5-xmlrpc php5-xsl

Then edit the following informations in the "/etc/php5/apache2/php.ini" file like this :

Code : PHP

# Super global variable (disable for security reasons)
register_globals = Off
# Cache PHP (PHP mask information about the header of the web server).
# Because hackers will not know the php version used on the server, you will be more protected against attacks.
expose_php = Off
# The "display_errors" directive to display the errors generated by PHP.
# Activate it when developing a website but disable it at the start of production thereof to prevent hackers from falling on "sensitive" informations.
display_errors = On
# short_open_tag allows you to use short tags <? ?> instead of <?php ?>
short_open_tag = Off
# magic_quotes_gpc can "protect" the "GET" data "POST" ... in adding / before '
# It is recommended to disable and protect their PHP code correctly. Moreover, this feature set deprecated since version "5.3.0" PHP and disappear from the version "5.4.0".
magic_quotes_gpc = Off
# Sets a list of dangerous turn on your server functions. You will also notice a list of functions "pcntl_" is already entered in the latest version of PHP5. In this case, simply add them to the list.
disable_functions = symlink,shell_exec,exec,proc_close,proc_open,popen,system,dl,passthru,escapeshellarg,escapeshellcmd

Then restart the apache configuration to reflect the changes.
Note : PHP is a module that is linked to the Apache web server. So that web server must be restarted.

Code : Bash

/etc/init.d/apache2 reload

 

3. MySQL installation and securing

Now install the server MySQL database.

Code : Bash

apt-get install mysql-server mysql-client mysql-common

Then edit the "/etc/mysql/my.cnf" file like this :

Code : Plain Text

[mysqld]
# Configure the server to work with the default UTF8.
# So when creating a database via phpMyAdmin (for example),
# the collation will be automatically set to "utf8_general_ci".
character-set-server = utf8
collation-server=utf8_general_ci

Then restart the MySQL configuration to reflect the changes :

Code : Bash

/etc/init.d/mysql reload

Then secure your MySQL server using the command :

Code : Bash

mysql_secure_installation

The following questions will be asked :

Code : Bash

# The password for the MySQL root user
Enter current password for root : ****
# No need to change the password because we just configure
Change the root password? : n
# Finally, answer yes (Y) for the rest of the questions by pressing the "Enter" key (since the default is Y (yes)).
# Removes anonymous users
Remove anonymous users? : y 
# Disable root access to the MySQL server for obvious safety reasons
Disallow root login remotely? : y
# Database "test" created during the installation and is accessible by default deletes everyone.
Remove test database and access to it? : y
# Updating server rights (in particular to take into account the new root password if you have changed it)
Reload privilege tables now? : y
# Your MySQL server is now secure
All done!  If you've completed all of the above steps, your MySQL installation should now be secure.

 

4. phpMyAdmin installation

Now install the tool database management known worldwide data written in PHP phpMyAdmin

Code : Bash

apt-get install phpmyadmin

During the installation of phpMyAdmin, a window will appear for you to select which web server phpMyAdmin is installed. Check the "apache2" box by pressing the space bar and press "Enter" to confirm.
Note : If you confirm the selection without having checked the box, simply type the command "dpkg-reconfigure phpmyadmin" to restart the configuration of this package.

Then answer "Yes" to the question : "Should we configure the database phpmyadmin with dbconfig-common."

Then, type the password for the MySQL server (password of the administrator of the database) when the wizard prompted.

And finally, enter a password (2x) for phpmyadmin account will be automatically created on the MySQL server.

Finally, you can a little more secure your phpmyadmin, changing his alias in the apache configuration file.
To do this, edit the "/etc/apache2/conf.d/phpmyadmin.conf" file like this :

Code : Apache

# Phpmyadmin address (choose a personal address so that hackers can not find it easily)
Alias /my_super_admin /usr/share/phpmyadmin