Linux Tutorials on the topic “mysql”

• Ubuntu 15.10 LAMP server tutorial with Apache 2.4, PHP 5 and MariaDB (instead of MySQL)

  Author: Till Brehm • Tags: apache, linux, mysql, php, ubuntu, web server • Comments: 22

  LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache 2.4 web server on an Ubuntu 15.10 server with PHP 5 support (mod_php) and MySQL / MariaDB. Additionally, I will install PHPMyAdmin to make MySQL administration easier. A LAMP setup is the perfect basis for CMS systems like Joomla, Wordpress or Drupal.

  read more... | view as pdf

• Setting up Master-Master Replication with MySQL on Debian 8 (Jessie)

  Author: Till Brehm • Tags: debian, high-availability, mysql • Comments: 10

  This tutorial describes a replicated MySQL setup (Mater/Master replication) with 2 nodes where data can be read and written to both nodes at the same time. MySQL takes care to replicate the data to the other node and ensures that primary auto increment keys don't collide.

  read more... | view as pdf

• Debian 8 Jessie LAMP server tutorial with Apache 2, PHP 5 and MariaDB (instead of MySQL)

  Author: Till Brehm • Tags: apache, debian, mysql, php, web server • Comments: 32

  LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache webserver on a Debian 8 (Jessie) server with PHP (mod_php) and MySQL / MariaDB support. A LAMP setup is a perfect basis for CMS systems like Joomla, Wordpress or Drupal.

  read more... | view as pdf

• How to install a wireless hotspot with captive page on Linux using CoovaChilli

  Author: Joseph Zikusooka • Tags: fedora, linux, mysql, networking, security • Comments: 11

  The purpose of this article is to demonstrate how you can turn a Linux based computer or laptop into a wireless hotspot where users can be authenticated via a captive portal page. For this task, the primary controller software will be CoovaChilli. This software is an ideal hotspot management solution for hotels, restaurants, supermarkets, parks, and any place offering WiFi Internet.

  read more... | view as pdf

• Ubuntu 15.04 LAMP server tutorial with Apache 2, PHP 5 and MariaDB (instead of MySQL)

  Author: Till Brehm • Tags: apache, linux, mysql, php, ubuntu, web server • Comments: 5

  LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache 2 webserver on an Ubuntu 15.04 server with PHP 5 support (mod_php) and MySQL / MariaDB. Additionally, I will install PHPMyAdmin to make MySQL administration easier. A LAMP setup is the perfect basis for CMS systems like Joomla, Wordpress or Drupal.

  read more... | view as pdf

• How to install Wordpress with Nginx, MariaDB and HHVM on Debian 8

  Author: Till Brehm • Tags: debian, mysql, nginx, server, web server • Comments: 9

  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. This tutorial describes the installation of Nginx, MariaDB, HHVM and Wordpress on Debian 8 (Jessie).

  read more... | view as pdf

• The Perfect Server - Ubuntu 15.04 (nginx, BIND, Dovecot and ISPConfig 3)

  Author: Till Brehm • Tags: bind, control panels, dns, email, ftp, ispconfig, linux, mysql, nginx, php, postfix, ubuntu, web server • Comments: 8

  This tutorial shows the steps to install an Ubuntu 15.04 (Vivid Vervet) server with Nginx, PHP, MariaDB, Postfix, pure-ftpd, BIND, Dovecot and ISPConfig 3. ISPConfig 3 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... | view as pdf

• How to install Wordpress with Nginx, MariaDB and HHVM in Ubuntu 15.04

  Author: Muhammad Arul • Tags: mysql, nginx, server, ubuntu, web server • Comments: 9

  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. This tutorial describes the steps to install WordPress with Nginx, MariaDB and HHVM on Ubuntu 15.04 Server.

  read more... | view as pdf

• ISPConfig 3: Automated installation on Debian

  Author: Matteo Temporini • Tags: apache, bind, control panels, debian, dns, dovecot, ispconfig, linux, mysql, nginx, php, postfix, server, ubuntu, web server • Comments: 69

  As you might know, ISPConfig is one of the best free opensource hosting control panels available to manage linux servers in single and multi server environments. This tutorial explains how to deploy and install this amazing contol panel with ispconfig_setup script.

  read more... | view as pdf

• How do I restore a MySQL database from an sql dump?

  Author: Falko Timme • Tags: mysql • Comments: 5

  If your MySQL user has a password: mysql -h localhost -u [MySQL user, e.g. root] -p[database password] [name of the database] < [name of your sql dump, e.g. sqldump.sql] Please note:  there's no space between -p and the password!If there's no password: mysql -h localhost -u [MySQL user, e.g. root] [name of the database] < [name of your sql dump, e.g. sqldump.sql]

  read more... | view as pdf