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 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 chmod +x Run mysqltuner: /usr/local/bin/ 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