How To Install Phpmyadmin Nginx

In this tutorial nosotros are going to provide you with stride-by-step instructions on how to install phpMyAdmin with HHVM, Nginx and MariaDB on an Ubuntu 14.04 VPS. PhpMyAdmin is an open source application, written in PHP, intended to handle the administration of MySQL / MadiaDB databases over the intuitive spider web interface.

Brand certain your package list and the OS packages are up to date by running the following commands:

apt-go update  apt-go upgrade

End the Apache service and disable it to commencement on kicking:

service apache2 stop update-rc.d -f apache2 remove

Install and configure Nginx:

apt-get install python-software-properties software-properties-mutual add-apt-repository ppa:nginx/stable apt-go install nginx

Create a new nginx server block for your website:

half dozen /etc/nginx/sites-available/your-domain.com

server {   server_name your-domain.com;   heed 80;   root /var/www/your-domain.com;   access_log /var/www/your-domain.com/logs/access.log;   error_log /var/www/your-domain.com/logs/error.log;   index index.php;   location / {     try_files $uri $uri/ /index.php?$args;   }    location ~* \.(jpg|jpeg|gif|css|png|js|ico|html)$ {     access_log off;     expires max;   }    location ~ /\.ht {     deny  all;   }    location ~ \.php$ {     fastcgi_index index.php;     fastcgi_keep_conn on;     include /etc/nginx/fastcgi_params;     fastcgi_pass 127.0.0.ane:9000;     fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;   } }

Install HHVM
Create a new 'hhvm.list' file and add the HHVM source to it:

vi /etc/apt/sources.listing.d/hhvm.list

deb http://dl.hhvm.com/ubuntu trusty main

Then, add the HHVM central and install the hhvm packet:

wget -O - http://dl.hhvm.com/conf/hhvm.gpg.key | sudo apt-fundamental add - apt-go update apt-get install hhvm /usr/share/hhvm/install_fastcgi.sh

vi /etc/hhvm/php.ini

; php options ; session.save_handler = files ; session.save_path = /var/lib/hhvm/sessions ; session.gc_maxlifetime = 1440  ; hhvm specific hhvm.log.level = Warning hhvm.log.always_log_unhandled_exceptions = true hhvm.log.runtime_error_reporting_level = 8191 hhvm.mysql.typed_results = false

vi /etc/hhvm/server.ini

; php options  pid = /var/run/hhvm/pid  ; hhvm specific  hhvm.server.port = 9000 hhvm.server.type = fastcgi hhvm.server.default_document = index.php hhvm.log.use_log_file = true hhvm.log.file = /var/log/hhvm/error.log hhvm.repo.central.path = /var/run/hhvm/hhvm.hhbc

Install MariaDB:

apt-become install mariadb-server

Run the following control:

mysql_secure_installation

Gear up your MariaDB 'root' user countersign (make sure to employ a strong password utilizing at to the lowest degree 8 characters including alphanumeric and grammatical symbols), remove anonymous user accounts, and then type 'Northward' if you similar to enable root login remotely, and blazon 'Y' on the next two questions to remove the test database and access to information technology and reload privilege tables.

Install phpMyAdmin:

apt-get install phpmyadmin ln -sf /usr/share/phpmyadmin/ /var/world wide web/your-domain.com/

In order to access phpMyAdmin over SSL, create an SSL certificate or purchase a new SSL document here.

cd /etc/nginx/ openssl genrsa -des3 -out server.key 1024 openssl req -new -x509 -nodes -sha1 -days 365 -key server.primal -out server.crt  cp server.key server.key.org openssl rsa -in server.key.org -out server.key chmod 400 server.key

So, edit the Nginx configuration and create a new nginx server cake:

half-dozen /etc/nginx/sites-available/your-domain.com

Add together these lines at the end of the file:

server {          listen       443;     ssl on;     ssl_certificate /etc/nginx/server.crt;     ssl_certificate_key /etc/nginx/server.key;    server_name your-domain.com;   root /var/www/your-domain.com;   access_log /var/world wide web/your-domain.com/logs/access.log;   error_log /var/www/your-domain.com/logs/error.log;   index index.php;   location / {     try_files $uri $uri/ /index.php?$args;   }    location ~* \.(jpg|jpeg|gif|css|png|js|ico|html)$ {     access_log off;     expires max;   }    location ~ /\.ht {     deny  all;   }    location ~ \.php$ {     fastcgi_index index.php;     fastcgi_keep_conn on;     include /etc/nginx/fastcgi_params;     fastcgi_pass 127.0.0.1:9000;     fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;   } }

Run these commands:

ln -s /etc/nginx/sites-available/your-domain.com /etc/nginx/sites-enabled/your-domain.com rm /etc/nginx/sites-enabled/default mkdir -p /var/www/your-domain.com/logs/ chown www-information: -R /var/world wide web/your-domain.com/        

Edit the '/usr/share/phpmyadmin/libraries/dbi/mysqli.dbi.lib.php', search for this line:

require_once './libraries/logging.lib.php';

and add together the following line in a higher place it:

$GLOBALS['cfg']['Server']['port']=3306;

Restart HHVM, nginx and MariaDB services and configure them to first on boot:

service hhvm restart service nginx restart service mysql restart  update-rc.d nginx defaults update-rc.d hhvm defaults update-rc.d mysql defaults

Open up https://your-domain.com/phpmyadmin , enter your MariaDB username and its password and commencement managing your MariaDB databases.

Of form you don't accept to do whatever of this if y'all use ane of our Linux VPS Hosting services, in which case you can simply ask our expert Linux admins to install phpMyAdmin with HHVM, Nginx and MariaDB for you. They are available 24×7 and will have care of your request immediately.

PS. If you liked this post please share information technology with your friends on the social networks using the buttons on the left or simply leave a reply beneath. Thanks.

Source: https://www.rosehosting.com/blog/how-to-install-phpmyadmin-with-hhvm-nginx-and-mariadb-on-an-ubuntu-14-04-vps/

Posted by: carrlenct1978.blogspot.com

Share this post