MySQL: How do I install MySQL 4.1 on Debian Etch / Debian 4.0? Answer: Hi Folks,I ran into that problem and here is a quite easy solution, thanks to www.mytso.net: edit /etc/apt/sources.list add the following line: deb http://debian.mytso.net/etch / edit /etc/apt/preferences add the following ...
MySQL: How to recover the MySQL root password? Answer: Well, this happens from time to time and is actually easy to fix, so here you are:
/etc/init.d/mysql stopmysqld_safe --skip-grant-tables &
mysql -u root
you should now be ...
Nagios: How to monitor MySQL replication with Nagios? Answer: Well, I wrote that script quite a while ago, it worked for me, so here you are:
$host = $argv;
$user = $argv;
$pass = $argv;
$link = ...
MySQL: How to change MySQL user password? Answer: Connect to your database and run the following command:
update mysql.user set password=PASSWORD("ENTER-PASSWORD-HERE") where User='ENTER-USERNAME';
After that you might want to run:
Linux: How to edit a very large file? Answer: I had to remove one line of a 20GB MySQL dump file and was wondering how I could do this.
Actually there are a few ways, ...
dovecot: How to fix “Unknown database driver ‘mysql'"? Answer: If you didn´t compile dovecot from source, you need to install the dovecot-mysql package:
yum install dovecot-mysql
apt-get install dovecot-mysql
If you compiled dovecot from source, you need ...