Linux Tutorials on the topic “mysql”

• How to Enable SSL and Remote Connections for MySQL on CentOS 7

  Author: Muhammad Arul • Tags: centos, linux, mysql • Comments: 4 • Published: May 22, 2017

  In this tutorial, I will show you step by step to configure MySQL securely for remote connections with SSL. MySQL is an open source relational database system that works on many Operating Systems including Windows, Linux, MacOS and FreeBSD. It is probably the most popular OpenSource RDBMS and a central component of the LAMP and LEMP Stacks.

  read more... | add comment | view as pdf | print

• The Perfect Server - Ubuntu 17.04 (Zesty Zapus) with Apache, PHP, MySQL, PureFTPD, BIND, Postfix, Dovecot and ISPConfig 3.1

  Author: Till Brehm • Tags: apache, bind, control panels, dns, email, ftp, ispconfig, linux, mysql, php, postfix, ubuntu, web server • Comments: 22 • Published: May 12, 2017

  This tutorial shows how to install an Ubuntu 17.04 (Zesty Zapus) server (with Apache2, BIND, Dovecot) for the installation of ISPConfig 3.1, and how to install ISPConfig. ISPConfig 3 is a web hosting control panel that allows you to configure the following services through a web browser: Apache or nginx web server, Postfix mail server, Courier or Dovecot IMAP/POP3 server, MySQL, BIND or MyDNS nameserver, PureFTPd, SpamAssassin, ClamAV, and many more. This setup covers the installation of Apache (instead of nginx), BIND (instead of MyDNS), and Dovecot (instead of Courier).

  read more... | add comment | view as pdf | print

• How to install Percona XtraDB Cluster for MySQL on Debian 8

  Author: Matteo Temporini • Tags: debian, linux, mysql, server • Comments: 0 • Published: Apr 10, 2017

  In this article, I will show you how to configure a MySQL database cluster with three nodes in a multi-master replication. Multi-master replication allows writing of records in each node, so if a node will fail, we can work on the other as if nothing happened. This tutorial describes how to install and configure three Percona XtraDB Cluster nodes on Debian 8 servers, we will be using the packages from the Percona repositories.

  read more... | add comment | view as pdf | print

• How to install Apache, PHP 7.1 and MySQL on CentOS 7.3 (LAMP)

  Author: Till Brehm • Tags: apache, centos, linux, mysql, php, server, web server • Comments: 23 • Published: Mar 17, 2017

  This tutorial shows how you can install an Apache webserver on a CentOS 7 server with PHP (mod_php with PHP 5.4, PHP 7.0, or PHP 7.1) and MySQL support. This setup is often referred to as LAMP which stands for Linux - Apache - MySQL - PHP.

  read more... | add comment | view as pdf | print

• The Perfect Server CentOS 7.3 with Apache, Postfix, Dovecot, Pure-FTPD, BIND and ISPConfig 3.1

  Author: Till Brehm • Tags: anti-spam/virus, apache, bind, centos, control panels, dns, email, ftp, ispconfig, linux, mysql, php, postfix, web server • Comments: 29 • Published: Feb 22, 2017

  This tutorial shows how to install ISPConfig 3.1 on a CentOS 7.3 (64Bit) server. ISPConfig 3 is a web hosting control panel that allows you to configure the following services through a web browser: Apache web server, Postfix mail server, MySQL, BIND nameserver, PureFTPd, SpamAssassin, ClamAV, Mailman, and many more.

  read more... | add comment | view as pdf | print

• The Perfect Server - Ubuntu 16.04 (Nginx, MySQL, PHP, Postfix, BIND, Dovecot, Pure-FTPD and ISPConfig 3.1)

  Author: Till Brehm • Tags: bind, control panels, dns, email, ftp, ispconfig, linux, mysql, nginx, php, postfix, ubuntu, web server • Comments: 63 • Published: Jan 24, 2017

  This tutorial shows the steps to install an Ubuntu 16.04 (Xenial Xerus) server with Nginx, PHP, MariaDB, Postfix, pure-ftpd, BIND, Dovecot and ISPConfig 3.1. ISPConfig is a web hosting control panel that allows you to configure the installed services through a web browser. This setup provides a full hosting server with web, email (inc. spam and antivirus filter), Database, FTP and DNS services.

  read more... | add comment | view as pdf | print

• The Perfect Server - Ubuntu 16.04 (Xenial Xerus) with Apache, PHP, MySQL, PureFTPD, BIND, Postfix, Dovecot and ISPConfig 3.1

  Author: Till Brehm • Tags: apache, bind, control panels, dns, email, ftp, ispconfig, linux, mysql, php, postfix, ubuntu, web server • Comments: 267 • Updated: Jan 05, 2017

  This tutorial shows how to install an Ubuntu 16.04 (Xenial Xerus) server (with Apache2, BIND, Dovecot) for the installation of ISPConfig 3.1, and how to install ISPConfig. ISPConfig 3 is a web hosting control panel that allows you to configure the following services through a web browser: Apache or nginx web server, Postfix mail server, Courier or Dovecot IMAP/POP3 server, MySQL, BIND or MyDNS nameserver, PureFTPd, SpamAssassin, ClamAV, and many more. This setup covers the installation of Apache (instead of nginx), BIND (instead of MyDNS), and Dovecot (instead of Courier).

  read more... | add comment | view as pdf | print

• The Perfect Server - Ubuntu 16.10 (Yakkety Yak) with Apache, PHP, MySQL, PureFTPD, BIND, Postfix, Dovecot and ISPConfig 3.1

  Author: Till Brehm • Tags: apache, bind, control panels, dns, email, ftp, ispconfig, linux, mysql, php, postfix, ubuntu, web server • Comments: 33 • Published: Oct 24, 2016

  This tutorial shows how to install an Ubuntu 16.10 (Yakkety Yak) server (with Apache2, BIND, Dovecot) for the installation of ISPConfig 3.1, and how to install ISPConfig. ISPConfig 3 is a web hosting control panel that allows you to configure the following services through a web browser: Apache or nginx web server, Postfix mail server, Courier or Dovecot IMAP/POP3 server, MySQL, BIND or MyDNS nameserver, PureFTPd, SpamAssassin, ClamAV, and many more. This setup covers the installation of Apache (instead of nginx), BIND (instead of MyDNS), and Dovecot (instead of Courier).

  read more... | add comment | view as pdf | print

• How to install Wordpress with Nginx, MariaDB and HHVM on Ubuntu 16.04 LTS

  Author: Muhammad Arul • Tags: linux, mysql, nginx, server, ubuntu, web server • Comments: 10 • Published: Oct 21, 2016

  This tutorial describes the steps to install WordPress with Nginx, MariaDB and HHVM on Ubuntu 16.04 Server. HHVM (Hip Hop Virtual Machine) is a just-in-time compiler developed by Facebook to run applications that are written in PHP and Hack language. HHVM is faster than the traditional PHP engine from ZEND and is used by Facebook to serve billions of web requests per day.

  read more... | add comment | view as pdf | print

• How to Install a MySQL Cluster on Ubuntu 16.04

  Author: Muhammad Arul • Tags: linux, mysql, ubuntu • Comments: 23 • Published: Oct 13, 2016

  In this tutorial, I will show you how to install a 'MySQL Cluster' on Ubuntu 16.04 LTS (Xenial Xerus). MySQL Cluster is a technology to provide high availability for MySQL Databases. It uses NDB (Network DataBase) or NDBCLUSTER as the database storage engine. MySQL Cluster is designed as multi-master ACID architecture with no single point of failure, it uses automatic sharding (partitioning) to scale out read and write processes.

  read more... | add comment | view as pdf | print

It's teamwork, but simpler, more pleasant and more productive.