Tweet 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
Tweet 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.
Tweet 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
Tweet If you lost your ISPConfig 3 administrator password, you can reset it with the following SQL query. UPDATE sys_user SET passwort = md5('admin') WHERE username = 'admin'; The SQL query sets the password to "admin" for the user "admin",
Tweet 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
Tweet To debug applications which use a mysql database, it comes in handy to enable the query log to get all SQL queries that were sent to the database. Open the MySQL configuration file (my.cnf) vi /etc/mysql/my.cnf and add the
Tweet 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
Tweet One way to create a backup of a mysql database on the shell is to use the mysqldump command. Mysqldump creates a dump of the database in form of sql commands. Backup mysqldump -u root -p mydatabase > /tmp/backup_mydatabase.sql