How To Install Nginx, MySQL, PHP, PhpMyAdmin, .NET Core in Ubuntu 18.04 [Music no 8]

I wrote this post because I tried to have on one Linux server .NET Core app and MySQL with PhpMyAdmin tool. On the Internet I found how to do it on 16.04, but it doesn’t work as ease as it is written on 18.04.

I wrote that post base on articles: https://www.digitalocean.com/community/tutorials/how-to-install-linux-nginx-mysql-php-lemp-stack-in-ubuntu-16-04 and https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-with-nginx-on-ubuntu-16-04.

Login to linux as root. First add a new user with sudo permissions:

You may log to the new one which you’ve just created and get all available updates to your Linux:

Then install server www and proxy server:

Install MySql Server:

Install PHP. Currently, by default, php version 7.2 is installed. To run phpmyadmin it is required to have mcrypt installed. It is currently not available for 7.2. We need to get mcrpyt from php 7.1 and copy that file to 7.2. Additionally, the actual version of phpMyAdmin (4.6.6) needs also mbstring package.

Change PHP configuration /etc/php/7.2/fpm/php.ini.
Change ;cgi.fix_pathinfo=1 to cgi.fix_pathinfo=0 (line 778)
Add line extension=mcrypt.so (line 893)

Restart PHP service

Change your nginx configuration/etc/nginx/sites-available/default

Add to /var/www/html/index.php with following piece of code

First check if nginx is propely configured then run nginx service and check if PHP works fine under address: <your-server-name.com>

Install PhpMyAdmin

During installation you will be promnt about web server. Skip it: TAB -> Enter. Later you will be asked if you like to configure dbconfig-common. Select yes and write twice password to a default user. Login to default user is phpmyadmin.

After installation make phpmyadmin visible your under address: <your-server-name.com>/phpmyadmin.

Create admin user in mysql server

For my own purposes I create different databases and different users with restricted access to that databases

Install git

Install .net core (https://dotnet.microsoft.com/download/linux-package-manager/ubuntu18-04/sdk-current)

Powered by: Wordpress