Support #179

Installing MySQL Database Server for ISPConfig on Debian 7

Added by Daniel Curtis over 8 years ago. Updated almost 7 years ago.

Database Server
Target version:
Start date:
Due date:
% Done:


Estimated time:
0.50 h
Spent time:


Installing the MySQL Database Server

It is a good idea to synchronize the system clock with an NTP (network time protocol) server over the Internet. Simply run:

apt-get -y install ntp ntpdate

Install MySQL client and server:

apt-get -y install mysql-client mysql-server

Enter the new password for MySQL when requested by the installer.

We want MySQL to listen on all interfaces, not just localhost, therefore we edit /etc/mysql/my.cnf and comment out the line bind-address =

vi /etc/mysql/my.cnf

  1. Instead of skip-networking the default is now to listen only on
  2. localhost which is more compatible and is not less secure.
    #bind-address =

Then restart MySQL:

service mysql restart

Then install the commandline version of PHP to be able to run PHP-based shell scripts for ISPConfig:

apt-get -y install php5-cli php5-mysql php5-mcrypt mcrypt

Install fail2ban: This is optional but recommended, because the ISPConfig monitor tries to show the log:

apt-get install fail2ban

Install ISPConfig 3 on this server.

To get the download URL of the latest ISPConfig 3 stable release, please visit the ISPConfig website:

Download the latest ISPConfig 3 stable release:

cd /tmp
tar xfz ISPConfig-3-stable.tar.gz
cd ispconfig3_install/install/

Then start the install script:

php -q install.php

Select language (en,de) [en]: <-- en
Installation mode (standard,expert) [standard]: <-- expert
Full qualified hostname (FQDN) of the server, eg []: <--
MySQL server hostname [localhost]: <-- localhost
MySQL root username [root]: <-- *root

> MySQL root password []: <-- Enter your *MySQL root password here

MySQL database to create [dbispconfig]: <-- dbispconfig
MySQL charset [utf8]: <-- utf8
Shall this server join an existing ISPConfig multiserver setup (y,n) [n]: <-- y
MySQL master server hostname []: <--
MySQL master server root username [root]: <-- root
MySQL master server root password []: <-- Enter the root password of the master server here
MySQL master server database name [dbispconfig]: <-- dbispconfig
Configure Mail (y,n) [y]: <-- n
Configure Jailkit (y,n) [y]: <-- n
Configure FTP Server (y,n) [y]: <-- n
Configure DNS Server (y,n) [y]: <-- n
Configure Apache Server (y,n) [y]: <-- n
Configure Firewall Server (y,n) [y]: <-- y
Install ISPConfig Web-Interface (y,n) [y]: <-- n

Remove the ISPConfig interface link in the /var/www directory:

rm -f /var/www/ispconfig

Clean up the install directories:

rm -rf /tmp/ispconfig3_install/install
rm -f /tmp/ISPConfig-3-stable.tar.gz

Related issues

Related to GNU/Linux Administration - Support #177: Installing Web Server For ISPConfig on Debian 7ClosedDaniel Curtis08/20/2013


Updated by Daniel Curtis almost 7 years ago

  • Project changed from 21 to GNU/Linux Administration
  • Category set to Database Server

Also available in: Atom PDF