Installing a LAMP Web Server on Amazon Linux

The following procedures help you install the Apache web server with PHP and MySQL support on your Amazon Linux instance (sometimes called a LAMP web server or LAMP stack). You can use this server to host a static website or deploy a dynamic PHP application that reads and writes information to a database.

Prerequisites

This tutorial assumes that you have already launched an instance with a public DNS name that is reachable from the Internet. For more information, see Step 1: Launch an Instance. You must also have configured your security group to allow SSH (port 22), HTTP (port 80), and HTTPS (port 443) connections. For more information about these prerequisites, see Setting Up with Amazon EC2.

Important

These procedures are intended for use with Amazon Linux. For more information about other distributions, see their specific documentation. If you are trying to set up a LAMP web server on an Ubuntu instance, this tutorial will not work for you. For information about LAMP web servers on Ubuntu, go to the Ubuntu community documentation ApacheMySQLPHP topic.

To install and start the LAMP web server on Amazon Linux

Connect to your instance.
To ensure that all of your software packages are up to date, perform a quick software update on your instance. This process may take a few minutes, but it is important to make sure you have the latest security updates and bug fixes.

Note

The -y option installs the updates without asking for confirmation. If you would like to examine the updates before installing, you can omit this option.
```
[ec2-user ~]$ sudo yum update -y
```
Now that your instance is current, you can install the Apache web server, MySQL, and PHP software packages. Use the yum install command to install multiple software packages and all related dependencies at the same time.
```
[ec2-user ~]$ sudo yum install -y httpd24 php56 mysql55-server php56-mysqlnd
```

Start the Apache web server.

[ec2-user ~]$ sudo service httpd start
Starting httpd:                                            [  OK  ]

Use the chkconfig command to configure the Apache web server to start at each system boot.
```
[ec2-user ~]$ sudo chkconfig httpd on
```
Tip

The chkconfig command does not provide any confirmation message when you successfully enable a service. You can verify that httpd is on by running the following command.
```
[ec2-user ~]$ chkconfig --list httpd
httpd           0:off   1:off   2:on    3:on    4:on    5:on    6:off
```
Here, httpd is on in runlevels 2, 3, 4, and 5 (which is what you want to see).
Test your web server. In a web browser, enter the public DNS address (or the public IP address) of your instance; you should see the Apache test page. You can get the public DNS for your instance using the Amazon EC2 console (check the Public DNS column; if this column is hidden, click the Show/Hide icon and select Public DNS).

Tip

If you are unable to see the Apache test page, check that the security group you are using contains a rule to allow HTTP (port 80) traffic. For information about adding an HTTP rule to your security group, see Adding Rules to a Security Group.

Important

If you are not using Amazon Linux, you may also need to configure the firewall on your instance to allow these connections. For more information about how to configure the firewall, see the documentation for your specific distribution.

Note

This test page appears only when there is no content in /var/www/html. When you add content to the document root, your content appears at the public DNS address of your instance instead of this test page.

Apache httpd serves files that are kept in a directory called the Apache document root. The Amazon Linux Apache document root is /var/www/html, which is owned by root by default.

[ec2-user ~]$ ls -l /var/www
total 16
drwxr-xr-x 2 root root 4096 Jul 12 01:00 cgi-bin
drwxr-xr-x 3 root root 4096 Aug  7 00:02 error
drwxr-xr-x 2 root root 4096 Jan  6  2012 html
drwxr-xr-x 3 root root 4096 Aug  7 00:02 icons

To allow ec2-user to manipulate files in this directory, you need to modify the ownership and permissions of the directory. There are many ways to accomplish this task; in this tutorial, you add a www group to your instance, and you give that group ownership of the /var/www directory and add write permissions for the group. Any members of that group will then be able to add, delete, and modify files for the web server.

To set file permissions

Add the www group to your instance.
```
[ec2-user ~]$ sudo groupadd www
```
Add your user (in this case, ec2-user) to the www group.
```
[ec2-user ~]$ sudo usermod -a -G www ec2-user
```
Important

You need to log out and log back in to pick up the new group. You can use the exitcommand, or close the terminal window.
Log out and then log back in again, and verify your membership in the www group.
1. Log out.
```
[ec2-user ~]$ exit
```
2. Reconnect to your instance, and then run the following command to verify your membership in the www group.
```
[ec2-user ~]$ groups
ec2-user wheel www
```
Change the group ownership of /var/www and its contents to the www group.
```
[ec2-user ~]$ sudo chown -R root:www /var/www
```
Change the directory permissions of /var/www and its subdirectories to add group write permissions and to set the group ID on future subdirectories.
```
[ec2-user ~]$ sudo chmod 2775 /var/www
[ec2-user ~]$ find /var/www -type d -exec sudo chmod 2775 {} \;
```
Recursively change the file permissions of /var/www and its subdirectories to add group write permissions.
```
[ec2-user ~]$ find /var/www -type f -exec sudo chmod 0664 {} \;
```

Now ec2_user (and any future members of the www group) can add, delete, and edit files in the Apache document root. Now you are ready to add content, such as a static website or a PHP application.

To test your LAMP web server

If your server is installed and running, and your file permissions are set correctly, your ec2-useraccount should be able to create a simple PHP file in the /var/www/html directory that will be available from the Internet.

Create a simple PHP file in the Apache document root.
```
[ec2-user ~]$ echo "<?php phpinfo(); ?>" > /var/www/html/phpinfo.php
```
Tip

If you get a "Permission denied" error when trying to run this command, try logging out and logging back in again to pick up the proper group permissions that you configured in To set file permissions.
In a web browser, enter the URL of the file you just created. This URL is the public DNS address of your instance followed by a forward slash and the file name. For example:
```
http://my.public.dns.amazonaws.com/phpinfo.php
```
You should see the PHP information page.
Note

If you do not see this page, verify that the /var/www/html/phpinfo.php file was created properly in the previous step. You can also verify that all of the required packages were installed with the following command (the package versions in the second column do not need to match this example output):
```
[ec2-user ~]$ sudo yum list installed httpd24 php56 mysql55-server php56-mysqlnd
Loaded plugins: priorities, update-motd, upgrade-helper
959 packages excluded due to repository priority protections
Installed Packages
httpd24.x86_64                          2.4.16-1.62.amzn1                    @amzn-main
mysql55-server.x86_64                   5.5.45-1.9.amzn1                     @amzn-main
php56.x86_64                            5.6.13-1.118.amzn1                   @amzn-main
php56-mysqlnd.x86_64                    5.6.13-1.118.amzn1                   @amzn-main
```
If any of the required packages are not listed in your output, install them with the sudo yum install package command.
Delete the phpinfo.php file. Although this can be useful information to you, it should not be broadcast to the Internet for security reasons.
```
[ec2-user ~]$ rm /var/www/html/phpinfo.php
```

To secure the MySQL server

The default installation of the MySQL server has several features that are great for testing and development, but they should be disabled or removed for production servers. Themysql_secure_installation command walks you through the process of setting a root password and removing the insecure features from your installation. Even if you are not planning on using the MySQL server, performing this procedure is a good idea.

Start the MySQL server.

[ec2-user ~]$ sudo service mysqld start
Initializing MySQL database:  Installing MySQL system tables...
OK
Filling help tables...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
...

Starting mysqld:                                           [  OK  ]

Run mysql_secure_installation.
```
[ec2-user ~]$ sudo mysql_secure_installation
```
1. When prompted, enter a password for the root account.
  1. Enter the current root password. By default, the root account does not have a password set, so press Enter.
  2. Type Y to set a password, and enter a secure password twice. For more information about creating a secure password, go tohttp://www.pctools.com/guides/password/. Make sure to store this password in a safe place.
2. Type Y to remove the anonymous user accounts.
3. Type Y to disable remote root login.
4. Type Y to remove the test database.
5. Type Y to reload the privilege tables and save your changes.
(Optional) Stop the MySQL server if you do not plan to use it right away. You can restart the server when you need it again.
```
[ec2-user ~]$ sudo service mysqld stop
Stopping mysqld:                                           [  OK  ]
```
(Optional) If you want the MySQL server to start at every boot, enter the following command.
```
[ec2-user ~]$ sudo chkconfig mysqld on
```

You should now have a fully functional LAMP web server. If you add content to the Apache document root at /var/www/html, you should be able to view that content at the public DNS address for your instance.

(Optional) Install phpMyAdmin

phpMyAdmin is a web-based database management tool that you can use to view and edit the MySQL databases on your EC2 instance. Follow the steps below to install and configure phpMyAdmin on your Amazon Linux instance.

Enable the Extra Packages for Enterprise Linux (EPEL) repository from the Fedora project on your instance.
```
[ec2-user ~]$ sudo yum-config-manager --enable epel
```
Install the phpMyAdmin package.
```
[ec2-user ~]$ sudo yum install -y phpMyAdmin
```
Note

Answer y to import the GPG key for the EPEL repository when prompted.
Configure your phpMyAdmin installation to allow access from your local machine. By default, phpMyAdmin only allows access from the server that it is running on, which is not very useful because Amazon Linux does not include a web browser.
1. Find your local IP address by visiting a service such as whatismyip.com.
2. Edit the /etc/httpd/conf.d/phpMyAdmin.conf file and replace the server IP address (127.0.0.1) with your local IP address with the following command, replacingyour_ip_address with the local IP address you identified in the previous step.
```
[ec2-user ~]$ sudo sed -i -e 's/127.0.0.1/your_ip_address/g' /etc/httpd/conf.d/phpMyAdmin.conf
```

Restart the Apache web server to pick up the new configuration.

[ec2-user ~]$ sudo service httpd restart
Stopping httpd:                                            [  OK  ]
Starting httpd:                                            [  OK  ]

In a web browser, enter the URL of your phpMyAdmin installation. This URL is the public DNS address of your instance followed by a forward slash and phpmyadmin. For example:
```
http://my.public.dns.amazonaws.com/phpmyadmin
```
You should see the phpMyAdmin login page.
Note

If you get a 403 Forbidden error, verify that you have set the correct IP address in the/etc/httpd/conf.d/phpMyAdmin.conf file. You can view the Apache access log to see what IP address the Apache server is actually getting your requests from with the following command:
```
[ec2-user ~]$ sudo tail -n 1 /var/log/httpd/access_log | awk '{ print $1 }'
205.251.233.48
```
Repeat Step 3.b with the IP address returned here and restart the httpd service with Step 4.
Log into your phpMyAdmin installation with the root user name the MySQL root password you created earlier. For more information and help using phpMyAdmin, see thephpMyAdmin User Guide.

You can also follow the original link

http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/install-LAMP.html

Tech Help

Saturday, 28 May 2016

Table ‘phpmyadmin.pma_table_uiprefs’ doesn’t exist mysql

Error: #1146 – Table ‘phpmyadmin.pma_table_uiprefs’ doesn’t exist mysql

How to fix #1146 – Table ‘phpmyadmin.pma_table_uiprefs’ doesn’t exist mysql

How to fix #1146 – Table ‘phpmyadmin.pma_recent’ doesn’t exist

Installing a LAMP Web Server on Amazon Linux (AMI)

Installing a LAMP Web Server on Amazon Linux

http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/install-LAMP.html