Elastic Compute Service:Deploy an LNMP stack on a CentOS 7 instance

Install MySQL

1. Run the following command to update the YUM repository:

   sudo rpm -Uvh  http://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm

2. Run the following command to install MySQL.

   Note

   If the "No match for argument" error message is returned, run the sudo yum module disable mysql command to disable the MySQL module in the YUM package manager. Then, install MySQL.

   sudo yum -y install mysql-community-server --nogpgcheck

3. Run the following command to check the version of MySQL:

   mysql -V

   The following command output indicates that MySQL is installed:

   mysql  Ver 14.14 Distrib 5.7.42, for Linux (x86_64) using  EditLine wrapper

4. Run the following command to start MySQL:

   sudo systemctl start mysqld

5. Run the following commands in sequence to configure MySQL to automatically start on instance startup:

   sudo systemctl enable mysqld
   sudo systemctl daemon-reload

Configure MySQL

1. Run the following command to view the /var/log/mysqld.log file and obtain and record the initial password of the root user:

   sudo grep 'temporary password' /var/log/mysqld.log

   The following command output indicates thatARQTRy3+**** is the initial password of the root user. You will use this initial password when you reset the password of the root user.

   2021-11-10T07:01:26.595215Z 1 [Note] A temporary password is generated for root@localhost: ARQTRy3+****

2. Run the following command to configure the security settings of MySQL:

   sudo mysql_secure_installation

   1. Enter the initial password of MySQL.

      Note When you enter a password, no command output is returned to maximize data security. You need only to enter the correct password and then press the Enter key.

      Securing the MySQL server deployment.
      
      Enter password for user root: # Enter the initial password that you obtained in the previous step.

   2. Enter a new password for MySQL.

      The existing password for the user account root has expired. Please set a new password.
      
      New password: # Enter a new password. The password must be 8 to 30 characters in length, and must contain uppercase letters, lowercase letters, digits, and special characters. Special characters include ( ) ` ~ ! @ # $ % ^ & * - + = | { } [ ] : ; ' < > , . ? /
      
      Re-enter new password: # Re-enter the new password. 
      The 'validate_password' plugin is installed on the server.
      The subsequent steps will run with the existing configuration
      of the plugin.
      Using existing password for root.
      
      Estimated strength of the password: 100 # The strength of the new password is contained in the command output. 
      Change the password for root ? (Press y|Y for Yes, any other key for No) :Y # Enter Y to confirm the new password. 
      
      # After the new password is set, you must verify the password. 
      New password:# Enter the new password. 
      
      Re-enter new password: # Re-enter the new password. 
      
      Estimated strength of the password: 100
      Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) :Y # Enter Y to use the new password.

   3. Enter Y to delete the anonymous user account.

      Remove anonymous users? (Press y|Y for Yes, any other key for No) :Y
      Success.

   4. Enter Y to deny access from the root user to MySQL.

      Disallow root login remotely? (Press y|Y for Yes, any other key for No) :Y
      Success.

   5. Enter Y to delete the test database and the access permissions on the database.

      Remove test database and access to it? (Press y|Y for Yes, any other key for No) :Y
       - Dropping test database...
      Success.
      
       - Removing privileges on test database...
      Success.

   6. Enter Y to reload privilege tables.

      Reload privilege tables now? (Press y|Y for Yes, any other key for No) :Y
      Success.
      
      All done!

For more information, see the official MySQL documentation.

Install PHP

1. Update the YUM repository.

   1. Run the following commands to add the Extra Packages for Enterprise Linux (EPEL) repository:

      sudo yum install \
      https://repo.ius.io/ius-release-el7.rpm \
      https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm

   2. Run the following command to add the Webtatic repository:

      sudo rpm -Uvh https://mirror.webtatic.com/yum/el7/webtatic-release.rpm

2. Run the following command to install PHP:

   sudo yum -y install php70w-devel php70w.x86_64 php70w-cli.x86_64 php70w-common.x86_64 php70w-gd.x86_64 php70w-ldap.x86_64 php70w-mbstring.x86_64 php70w-mcrypt.x86_64  php70w-pdo.x86_64   php70w-mysqlnd  php70w-fpm php70w-opcache php70w-pecl-redis php70w-pecl-mongodb

3. Run the following command to check the version of PHP:

   php -v

   The following command output indicates that PHP is installed:

   PHP 7.0.33 (cli) (built: Dec  6 2018 22:30:44) ( NTS )
   Copyright (c) 1997-2017 The PHP Group
   Zend Engine v3.0.0, Copyright (c) 1998-2017 Zend Technologies
       with Zend OPcache v7.0.33, Copyright (c) 1999-2017, by Zend Technologies                

Modify the NGINX configuration file to enable PHP

1. Run the following command to back up the NGINX configuration file:

   sudo cp /etc/nginx/nginx.conf /etc/nginx/nginx.conf.bak

2. Modify the NGINX configuration file to add NGINX support for PHP.

   Important

   If you do not add NGINX support for PHP, PHP pages cannot be displayed when you access the pages by using a browser.

   1. Run the following command to open the NGINX configuration file:

      sudo vim /etc/nginx/nginx.conf

   2. Press the I key to enter Insert mode.

   3. Modify or add the following information enclosed inside the server braces.

      Retain the default values for all settings except the following settings:

      • Modify or add the following information enclosed inside the location / braces.

                location / {
                    index index.php index.html index.htm;
                }

      • Modify or add the following information enclosed inside the location ~ .php$ braces.

                # Add the following information to make NGINX use Fast Common Gateway Interface (FastCGI) to process your PHP requests: 
                location ~ .php$ {
                    root /usr/share/nginx/html;    # Replace /usr/share/nginx/html with your website root directory. In this example, /usr/share/nginx/html is used as the website root directory. 
                    fastcgi_pass 127.0.0.1:9000;   # NGINX forwards your PHP requests to PHP FastCGI Process Manager (PHP-FPM) by using port 9000 of the ECS instance. 
                    fastcgi_index index.php;
                    fastcgi_param  SCRIPT_FILENAME  $document_root$fastcgi_script_name;
                    include fastcgi_params;   # NGINX uses FastCGI to process the PHP requests. 
                }

      The following figure shows the added or modified configuration information.

   4. Press the Esc key, enter :wq, and then press the Enter key to save and close the configuration file.

3. Run the following command to start NGINX:

   sudo systemctl start nginx 

4. Run the following command to configure NGINX to automatically start on instance startup:

   sudo systemctl enable nginx