Edit history

[SIZE=7][B]INSTALL APACHE2, PHP 7.4, MARIADB (MYSQL) AND PHPMYADMIN ON LINUX[/B][/SIZE]

[LIST=1]
[*]If you have not already done so, download the "[URL='https://www.chiark.greenend.org.uk/~sgtatham/putty/latest.html']PuTTY[/URL]" program.


[*]Use [URL='https://www.chiark.greenend.org.uk/~sgtatham/putty/latest.html']PuTTY[/URL] to connect to your root or vServer via SSH. To do this, open [URL='https://www.chiark.greenend.org.uk/~sgtatham/putty/latest.html']PuTTY[/URL] and enter the domain or IP address of your server in the "Host Name (or IP address)" text field. Then click OK at the bottom.


[*]Now update your package lists with the [COLOR=rgb(184, 49, 47)][B][U]apt update[/U][/B][/COLOR][COLOR=rgb(0, 0, 0)] command[/COLOR]


[*]Install any available updates of the packages already installed on your server with the command [COLOR=rgb(184, 49, 47)][B][U]apt upgrade -y[/U][/B][/COLOR]


[*]Next, install the packages that are required for further installations with the following command: [COLOR=rgb(184, 49, 47)][B][U]apt install ca-certificates apt-transport-https lsb-release gnupg curl nano unzip -y[/U][/B][/COLOR]


[*]Add the package source needed to install PHP 7.4:
[B]          For Debian:[/B]
[LIST=1]
[*]Using the command [B][COLOR=rgb(184, 49, 47)][U]wget -q add https://packages.sury.org/php/apt.gpg -O- | apt-key add -[/U][/COLOR][/B]  the key required for the PHP package source.
[*]Use the command [COLOR=rgb(184, 49, 47)][B][U]echo "deb https://packages.sury.org/php/ $(lsb_release -sc) main" | tee /etc/apt/sources.list.d/php.list[/U][/B][/COLOR] to add the package source.

[B]For Ubuntu:[/B]
[*]Install the package to manage the package sources using the following command: [COLOR=rgb(184, 49, 47)][B][U]apt install software-properties-common -y[/U][/B][/COLOR]
[*]Use the command [COLOR=rgb(184, 49, 47)][B][U]add-apt-repository ppa: ondrej/php[/U][/B][/COLOR] to add the repository now.
[/LIST]
[*]Now update your package lists again using the [COLOR=rgb(184, 49, 47)][B][U]apt update[/U][/B][/COLOR] command.


[*]Install the Apache2 web server and other required packages with the following command: [COLOR=rgb(184, 49, 47)][B][U]apt install apache2 -y[/U][/B][/COLOR]


[*]Then install PHP 7.4 as well as some important PHP modules. The command for this is: [COLOR=rgb(184, 49, 47)][B][U]apt install php7.4 php7.4-cli php7.4-common php7.4-curl php7.4-gd php7.4-intl php7.4-json php7.4-mbstring php7.4-mysql php7.4-opcache php7.4-readline php7.4-xml php7.4-xsl php7.4-zip php7.4-bz2 libapache2-mod-php7.4 -y[/U][/B][/COLOR]


[*]Next, install the MariaDB server and client (MySQL) using the [COLOR=rgb(184, 49, 47)][B][U]apt install mariadb-server mariadb-client -y[/U][/B][/COLOR] command.


[*]Now enter the command [COLOR=rgb(184, 49, 47)][B][U]mysql_secure_installation[/U][/B][/COLOR] to safely complete the configuration of the MariaDB server. The first time you are asked for the current password, you do not have to enter anything, just press the Enter key. Confirm the next question regarding changing the root password with Enter. Now you have to assign a password for the root user of the MariaDB server. No characters appear as you type, but this is normal. Confirm all the following questions (deleting the anonymous user, prohibiting the external root login for security reasons, removing the test database and updating the rights) with Enter. Then the MariaDB server is completely installed and configured.


[*]Change to the directory where phpMyAdmin will be installed with the command [COLOR=rgb(184, 49, 47)][B][U]cd /usr/share[/U][/B][/COLOR]


[*]To download phpMyAdmin, run the command [COLOR=rgb(184, 49, 47)][B][U]wget https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-all-languages.zip -O phpmyadmin.zip[/U][/B][/COLOR]


[*]Unzip the archive you just downloaded with the following command: [COLOR=rgb(184, 49, 47)][U][B]unzip phpmyadmin.zip[/B][/U][/COLOR]


[*]Remove the downloaded archive, which is now already unzipped, with the command [COLOR=rgb(184, 49, 47)][B][U]rm phpmyadmin.zip[/U][/B][/COLOR]


[*]Then you have to rename the name of the extracted directory to "phpmyadmin". You do this with the following command: [COLOR=rgb(184, 49, 47)][B][U]mv phpMyAdmin-*-all-languages phpmyadmin[/U][/B][/COLOR]


[*]Then assign the required rights to the phpMyAdmin directory using the command [COLOR=rgb(184, 49, 47)][B][U]chmod -R 0755 phpmyadmin[/U][/B][/COLOR]


[*]Now create an Apache2 configuration file for phpMyAdmin by running the command [COLOR=rgb(184, 49, 47)][B][U]nano /etc/apache2/conf-available/phpmyadmin.conf[/U][/B][/COLOR]


[*]Now add the following content to this configuration file:

[I]# phpMyAdmin Apache configuration

Alias /phpmyadmin /usr/share/phpmyadmin

<Directory /usr/share/phpmyadmin>
Options SymLinksIfOwnerMatch
DirectoryIndex index.php
</Directory>

# Disallow web access to directories that don't need it
<Directory /usr/share/phpmyadmin/templates>
Require all denied
</Directory>
<Directory /usr/share/phpmyadmin/libraries>
Require all denied
</Directory>
<Directory /usr/share/phpmyadmin/setup/lib>
Require all denied
 </Directory>[/I]


[*]Save your changes to the configuration by pressing [B]CTRL + X, then the "Y" key and then press Enter[/B].


[*]Activate the Apache2 configuration file you just added with the [COLOR=rgb(184, 49, 47)][B][U]a2enconf phpmyadmin[/U][/B][/COLOR] command and then run the [COLOR=rgb(184, 49, 47)][B][U]systemctl reload apache2[/U][/B][/COLOR] command to reload the Apache2 web server.


[*]Create the temporary directory that phpMyAdmin needs by executing the command [COLOR=rgb(184, 49, 47)][B][U]mkdir /usr/share/phpmyadmin/tmp/[/U][/B][/COLOR]


[*]Now give the web server user the required owner rights for this temporary directory using the command [COLOR=rgb(184, 49, 47)][B][U]chown -R www-data:www-data /usr/share/phpmyadmin/tmp/[/U][/B][/COLOR]


[*][B]Note[/B]: For security reasons, you can no longer log into the MariaDB server directly as a root user using the normal password authentication (e.g. via phpMyAdmin). You can either enable this anyway (not recommended on production systems) or, alternatively, create another user with all rights (recommended) if you need this (e.g. for phpMyAdmin). You will find an explanation of these two options in the next two steps.


[*][B]Variant 1[/B] - enable root login via password authentication ([B]not recommended on productive systems[/B]): Log into PuTTY using the command [COLOR=rgb(184, 49, 47)][B][U]mysql -u root[/U][/B][/COLOR] on the MariaDB server and then run the commands [COLOR=rgb(184, 49, 47)][B][U]UPDATE mysql.user SET plugin = 'mysql_native_password 'WHERE user =' root 'AND plugin =' unix_socket ';[/U][/B][/COLOR] and [COLOR=rgb(184, 49, 47)][B][U]FLUSH PRIVILEGES;[/U][/B][/COLOR] the end. This changes the authentication plug-in of the root user from the UNIX socket back to standard authentication. Finally, exit the MariaDB console with the [COLOR=rgb(184, 49, 47)][B][U]exit[/U][/B][/COLOR] command.


[*][B]Variant 2[/B] - Create additional user with all rights ([B]recommended[/B]): Log into PuTTY using the command [COLOR=rgb(184, 49, 47)][B][U]mysql -u root[/U][/B][/COLOR] on the MariaDB server and then execute the commands [COLOR=rgb(184, 49, 47)][B][U]CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';[/U][/B][/COLOR] and [COLOR=rgb(184, 49, 47)][B][U]GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;[/U][/B][/COLOR] the end. Replace "[B]username[/B]" and "[B]password[/B]" with your desired username and password. Finally, exit the MariaDB console with the [COLOR=rgb(184, 49, 47)][B][U]exit[/U][/B][/COLOR] command. You can then log in to the MariaDB server with the newly created user (e.g. via phpMyAdmin).


[*]Your Apache2 web server including PHP 7.4, MariaDB server and phpMyAdmin is now ready for use. By default, the web directory is located under "/var/www/html/". You can reach the phpMyAdmin web interface by adding "[B]/phpmyadmin[/B]" to the IP address or domain of your server in the browser. There you can now log in to the MariaDB server - depending on which variant you selected after step 25, either with the user "root" or with your additionally created user.
[/LIST]
Top Bottom
Search

Search

Edit history
