Linux Tutorials on the topic “mysql”

• Managing Multiple MySQL Servers From One phpMyAdmin Installation (Using SSL Encryption)

  Author: Falko Timme • Tags: mysql, security, debian, ubuntu • Comments: 7

  Managing Multiple MySQL Servers From One phpMyAdmin Installation (Using SSL Encryption) This tutorial explains how you can manage multiple MySQL servers from one phpMyAdmin installation. For security reasons, communication between phpMyAdmin and any remote MySQL server is using SSL encryption (this is not necessary for a local MySQL server since communication between phpMyAdmin and MySQL is not leaving the server). phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL.

  read more... | view as pdf

• Installing Apache2 With PHP5 And MySQL Support On OpenSUSE 12.2 (LAMP)

  Author: Falko Timme • Tags: apache, mysql, php, suse, web server • Comments: 1

  Installing Apache2 With PHP5 And MySQL Support On OpenSUSE 12.2 (LAMP) LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an OpenSUSE 12.2 server with PHP5 support (mod_php) and MySQL support.

  read more... | view as pdf

• Creating Advanced MySQL-Based Virtual Hosts On Lighttpd (Ubuntu 12.04)

  Author: Falko Timme • Tags: lighttpd, mysql, ubuntu, web server • Comments: 0

  Creating Advanced MySQL-Based Virtual Hosts On Lighttpd (Ubuntu 12.04) This guide explains how you can create advanced virtual hosts on a lighttpd web server on Ubuntu 12.04 that are stored in a MySQL database. The method described here does not use the lighttpd mod_mysql_vhost module, and unlike mod_mysql_vhost (which allows you to store only the hostname and document root of a vhost in a database), this method allows to store individual configuration directives for each vhost in the MySQL database.

  read more... | view as pdf

• Creating Simple Virtual Hosts With mod_mysql_vhost On Lighttpd (Ubuntu 12.04)

  Author: Falko Timme • Tags: lighttpd, mysql, ubuntu, web server • Comments: 0

  This guide explains how you can use mod_mysql_vhost to create simple virtual hosts on a lighttpd web server on Ubuntu 12.04. With mod_mysql_vhost, lighttpd can read the vhost configuration from a MySQL database. Currently, you can store the domain and the document root in the MySQL database which results in very simple virtual hosts. If you need more directives for your vhosts, you'd have to configure them in the global section of lighttpd.conf, which means they'd be valid for all vhosts. Therefore, mod_mysql_vhost is ideal if your vhosts differ only in the domain and document root.

  read more... | view as pdf

• Virtual Hosting With vsftpd And MySQL On Debian Squeeze

  Author: Falko Timme • Tags: debian, ftp, mysql • Comments: 6

  Vsftpd is one of the most secure and fastest FTP servers for Linux. Usually vsftpd is configured to work with system users. This document describes how to install a vsftpd server that uses virtual users from a MySQL database instead of real system users. This is much more performant and allows to have thousands of ftp users on a single machine.

  read more... | view as pdf

• Creating Advanced MySQL-Based Virtual Hosts On Lighttpd (Debian Squeeze)

  Author: Falko Timme • Tags: debian, lighttpd, mysql, web server • Comments: 0

  Creating Advanced MySQL-Based Virtual Hosts On Lighttpd (Debian Squeeze) This guide explains how you can create advanced virtual hosts on a lighttpd web server on Debian Squeeze that are stored in a MySQL database. The method described here does not use the lighttpd mod_mysql_vhost module, and unlike mod_mysql_vhost (which allows you to store only the hostname and document root of a vhost in a database), this method allows to store individual configuration directives for each vhost in the MySQL database.

  read more... | view as pdf

• Installing Lighttpd With PHP5 (PHP-FPM) And MySQL Support On CentOS 6.3

  Author: Falko Timme • Tags: centos, lighttpd, mysql, php, web server • Comments: 0

  Installing Lighttpd With PHP5 (PHP-FPM) And MySQL Support On CentOS 6.3 Lighttpd is a secure, fast, standards-compliant web server designed for speed-critical environments. This tutorial shows how you can install Lighttpd on a Centos 6.3 server with PHP5 support (through PHP-FPM) and MySQL support. PHP-FPM (FastCGI Process Manager) is an alternative PHP FastCGI implementation with some additional features useful for sites of any size, especially busier sites. I use PHP-FPM in this tutorial instead of Lighttpd's spawn-fcgi.

  read more... | view as pdf

• Installing Apache2 With PHP5 And MySQL Support On CentOS 6.3 (LAMP)

  Author: Falko Timme • Tags: apache, centos, mysql, php, web server • Comments: 10

  LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a CentOS 6.3 server with PHP5 support (mod_php) and MySQL support.

  read more... | view as pdf

• Installing Apache2 With PHP5 And MySQL Support On Ubuntu 12.04 LTS (LAMP)

  Author: Falko Timme • Tags: apache, mysql, php, ubuntu, web server • Comments: 52

  Installing Apache2 With PHP5 And MySQL Support On Ubuntu 12.04 LTS (LAMP) LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an Ubuntu 12.04 LTS server with PHP5 support (mod_php) and MySQL support.

  read more... | view as pdf

• How To Back Up MySQL Databases With mylvmbackup On Debian Squeeze

  Author: Falko Timme • Tags: backup, debian, mysql • Comments: 0

  mylvmbackup is a Perl script for quickly creating MySQL backups. It uses LVM's snapshot feature to do so. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, creates a snapshot of the volume containing the MySQL data directory, and unlocks the tables again. This article shows how to use it on a Debian Squeeze server.

  read more... | view as pdf