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
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
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
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", it has to be executed in the ISPConfig mysql database, e.g. with phpmyadmin. If you dont ... Read more
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
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 This command creates a backup of the database with the name "mydatabase" in the file /tmp/backup_mydatabase.sql ... Read more
Comment out the option: skip-networking in the file: my.cnf which typically lies in the directory /etc or /etc/mysql. Then restart your MySQL server: service mysql restart or /etc/init.d/mysql restart with the command: netstat -ta you can check if MySQL is reachable via TCP.