public marks

PUBLIC MARKS from falko with tag mysql

August 2012

Installing Apache2 With PHP5 And MySQL Support On CentOS 6.3 (LAMP) | HowtoForge - Linux Howtos and Tutorials

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.

July 2012

The Perfect Server - CentOS 6.3 x86_64 (nginx, Courier, ISPConfig 3) | HowtoForge - Linux Howtos and Tutorials

This tutorial shows how to prepare a CentOS 6.3 x86_64 server for the installation of ISPConfig 3, and how to install ISPConfig 3. ISPConfig 3 is a webhosting control panel that allows you to configure the following services through a web browser: nginx web server, Postfix mail server, MySQL, BIND nameserver, PureFTPd, SpamAssassin, ClamAV, Mailman, and many more. Since version 3.0.4, ISPConfig comes with full support for the nginx web server in addition to Apache; this tutorial covers the setup of a server that uses nginx, not Apache.

How To Benchmark Your System (CPU, File IO, MySQL) With sysbench | HowtoForge - Linux Howtos and Tutorials

sysbench is a benchmark suite which allows you to quickly get an impression about system performance which is important if you plan to run a database under intensive load. This article explains how to benchmark your CPU, file IO, and MySQL performance with sysbench.

The Perfect Server - CentOS 6.3 x86_64 (Apache2, Courier, ISPConfig 3) | HowtoForge - Linux Howtos and Tutorials

This tutorial shows how to prepare a CentOS 6.3 x86_64 server for the installation of ISPConfig 3, and how to install ISPConfig 3. ISPConfig 3 is a webhosting 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. Since version 3.0.4, ISPConfig comes with full support for the nginx web server in addition to Apache; this tutorial covers the setup of a server that uses Apache, not nginx.

Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support On CentOS 6.3 | HowtoForge - Linux Howtos and Tutorials

Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on a CentOS 6.3 server with PHP5 support (through PHP-FPM) and MySQL support.

The Perfect Server - CentOS 6.3 x86_64 (Apache2, Dovecot, ISPConfig 3) | HowtoForge - Linux Howtos and Tutorials

This tutorial shows how to prepare a CentOS 6.3 x86_64 server for the installation of ISPConfig 3, and how to install ISPConfig 3. ISPConfig 3 is a webhosting 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. Since version 3.0.4, ISPConfig comes with full support for the nginx web server in addition to Apache; this tutorial covers the setup of a server that uses Apache, not nginx.

June 2012

Using PHP5-FPM With Apache2 On Fedora 17 | HowtoForge - Linux Howtos and Tutorials

This tutorial shows how you can install an Apache2 webserver on a Fedora 17 server with PHP5 (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.

Installing Cherokee With PHP5 And MySQL Support On Ubuntu 12.04 | HowtoForge - Linux Howtos and Tutorials

Cherokee is a very fast, flexible and easy to configure Web Server. It supports the widespread technologies nowadays: FastCGI, SCGI, PHP, CGI, TLS and SSL encrypted connections, virtual hosts, authentication, on the fly encoding, load balancing, Apache compatible log files, and much more. This tutorial shows how you can install Cherokee on an Ubuntu 12.04 server with PHP5 support (through FastCGI) and MySQL support.

Installing Apache2 With PHP5 And MySQL Support On Fedora 17 (LAMP) | HowtoForge - Linux Howtos and Tutorials

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

Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support On Fedora 17 | HowtoForge - Linux Howtos and Tutorials

Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on a Fedora 17 server with PHP5 support (through PHP-FPM) and MySQL support.

Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Fedora 17 x86_64) | HowtoForge - Linux Howtos and Tutorials

This document describes how to install a Postfix mail server that is based on virtual users and domains, i.e. users and domains that are in a MySQL database. I'll also demonstrate the installation and configuration of Courier, so that Courier can authenticate against the same MySQL database Postfix uses. The resulting Postfix server is capable of SMTP-AUTH and TLS and quota. Passwords are stored in encrypted form in the database. In addition to that, this tutorial covers the installation of Amavisd, SpamAssassin and ClamAV so that emails will be scanned for spam and viruses. I will also show how to install SquirrelMail as a webmail interface so that users can read and send emails and change their passwords.

May 2012

HowtoForge - Linux Howtos and Tutorials

by 38 others
Lighttpd is a secure, fast, standards-compliant web server designed for speed-critical environments. This tutorial shows how you can install Lighttpd on an Ubuntu 12.04 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.

Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support (LEMP) On Ubuntu 12.04 LTS | HowtoForge - Linux Howtos and Tutorials

Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on an Ubuntu 12.04 LTS server with PHP5 support (through PHP-FPM) and MySQL support (LEMP = Linux + nginx (pronounced "engine x") + MySQL + PHP).

Installing Apache2 With PHP5 And MySQL Support On Ubuntu 12.04 LTS (LAMP) | HowtoForge - Linux Howtos and Tutorials

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.

Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 12.04 LTS) | HowtoForge - Linux Howtos and Tutorials

This document describes how to install a Postfix mail server that is based on virtual users and domains, i.e. users and domains that are in a MySQL database. I'll also demonstrate the installation and configuration of Courier, so that Courier can authenticate against the same MySQL database Postfix uses. The resulting Postfix server is capable of SMTP-AUTH and TLS and quota. Passwords are stored in encrypted form in the database. In addition to that, this tutorial covers the installation of Amavisd, SpamAssassin and ClamAV. I will also show how to install SquirrelMail as a webmail interface.

The Perfect Server - Ubuntu 12.04 LTS (nginx, BIND, Dovecot, ISPConfig 3) | HowtoForge - Linux Howtos and Tutorials

This tutorial shows how to prepare an Ubuntu 12.04 LTS (Precise Pangolin) server (with nginx, BIND, Dovecot) for the installation of ISPConfig 3, and how to install ISPConfig 3. ISPConfig 3 is a webhosting 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 nginx (instead of Apache), BIND (instead of MyDNS), and Dovecot (instead of Courier).

The Perfect Server - Ubuntu 12.04 LTS (Apache2, BIND, Dovecot, ISPConfig 3) | HowtoForge - Linux Howtos and Tutorials

This tutorial shows how to prepare an Ubuntu 12.04 LTS (Precise Pangolin) server (with Apache2, BIND, Dovecot) for the installation of ISPConfig 3, and how to install ISPConfig 3. ISPConfig 3 is a webhosting 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 Apache (instead of nginx), BIND (instead of MyDNS), and Dovecot (instead of Courier).

April 2012

Installing MySQL-Frontend Chive (A phpMyAdmin Alternative) | HowtoForge - Linux Howtos and Tutorials

This guide explains how to install the phpMyAdmin alternative Chive. Chive is a free, open source, web-based database management tool with easy administration, super fast UI and state of the art web technologies. It takes advantage of the capabilities of modern browsers. Features include an SQL editor with syntax highlighting and built-in profiling of SQL queries.

March 2012

The Perfect Server - Debian Squeeze (Debian 6.0) With BIND, Dovecot & Nginx [ISPConfig 3] | HowtoForge - Linux Howtos and Tutorials

This tutorial shows how to prepare a Debian Squeeze (Debian 6.0) server for the installation of ISPConfig 3, and how to install ISPConfig 3. ISPConfig 3 is a webhosting control panel that allows you to configure the following services through a web browser: nginx or Apache web server, Postfix mail server, MySQL, BIND nameserver, PureFTPd, SpamAssassin, ClamAV, and many more. The idea is to use the fast and memory efficient nginx web server and Dovecot which is also said to be more memory efficient. You will need to use the Dotdeb repository for nginx.

Installing Apache2 With PHP5 And MySQL Support On CentOS 6.2 (LAMP) | HowtoForge - Linux Howtos and Tutorials

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

Installing Cherokee With PHP5 And MySQL Support On Ubuntu 11.10 | HowtoForge - Linux Howtos and Tutorials

Cherokee is a very fast, flexible and easy to configure Web Server. It supports the widespread technologies nowadays: FastCGI, SCGI, PHP, CGI, TLS and SSL encrypted connections, virtual hosts, authentication, on the fly encoding, load balancing, Apache compatible log files, and much more. This tutorial shows how you can install Cherokee on an Ubuntu 11.10 server with PHP5 support (through FastCGI) and MySQL support.

February 2012

Using PHP5-FPM With Apache2 On CentOS 6.2 | HowtoForge - Linux Howtos and Tutorials

This tutorial shows how you can install an Apache2 webserver on a CentOS 6.2 server with PHP5 (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.

Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support On Fedora 16 | HowtoForge - Linux Howtos and Tutorials

Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on a Fedora 16 server with PHP5 support (through PHP-FPM) and MySQL support.

Installing A Web, Email & MySQL Database Cluster On Debian 6.0 With ISPConfig 3 | HowtoForge - Linux Howtos and Tutorials

This tutorial describes the installation of a clustered web, email, database and DNS server to be used for redundancy, high availability and load balancing on Debian 6 with the ISPConfig 3 control panel. MySQL Master/Master replication will be used to replicate the MySQL client databases between the servers and Unison will be used to Sync the /var/www (websites) and /var/vmail (email account data) folders.

Using PHP5-FPM With Apache2 On Ubuntu 11.10 | HowtoForge - Linux Howtos and Tutorials

This tutorial shows how you can install an Apache2 webserver on an Ubuntu 11.10 server with PHP5 (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.