How to disable MySQL replication on master/master andmaster/slave setups

The following guide shows how to disable and remove mysql replication from two or more mysql servers. These steps can be used for master/slave and master/master mysql setups. The following SQL commands have to be be executed in phpmyadmin or with the mysql commandline program. It is just important that you are logged in as ... Read more

How to solve the too many connections error in MySQL

If you get the error message "connect to mysql server 127.0.0.1: Too many connections" in a log file, e.g. the mail.log file, then the max. number of mysql database connections on your server is reached. To increase the max. number of simultaneous connections, edit the MySQL my.cnf file: vi /etc/mysql/my.cnf and add or change the ... Read more

Optimize MySQL performance with mysqltuner

The following tutorial describes the steps to optimize the performance of a MySQL database with the mysqltuner script. Login to your server on the shell, then execute the following commands: Download the MySQL tuner script: cd /usr/local/bin wget http://mysqltuner.pl/mysqltuner.pl chmod +x mysqltuner.pl Run mysqltuner: /usr/local/bin/mysqltuner.pl Then enter root as the username and the MySQL root ... Read more

How to reset the MySQL root password

The following steps describe the procedure to reset the mysql root password on Linux. 1) Stop the mysql server /etc/init.d/mysql stop 2) Start the mysql server manually without permission tables which allows us to login as root user without password: mysqld_safe --skip-grant-tables & 3) Login into mysql as root user without a password and switch ... Read more

Install postfix with MySQL support on CentOS 5.3 (64Bit)

The following article explains the steps to compile postfix MTA with MySQL support on CentOS 5.3 as e.g. needed for ISPConfig 3. Remove the postfix package from CentOS which does not has MySQL support: /etc/init.d/postfix stop rpm -e --nodeps postfix Download the postfix source RPM and install it: cd /tmp wget http://mirror.rackspace.com/CentOS/5.3/os/SRPMS/postfix-2.3.3-2.1.el5_2.src.rpm rpm -i postfix-2.3.3-2.1.el5_2.src.rpm ... Read more