liggyman's blog

Sometimes you need a quick and dirty way of resetting a MySQL root password. Typical scenario is when taking over Administrative duties on a server which has no documentation.

First we need stop MySQL and start it with the –skip-grant-tables option set:

sudo /etc/init.d/mysql stop
sudo mysqld --skip-grant-tables

Then we login to mysql as root:

mysql -u root mysql

Once logged in we can set the new password:

UPDATE user SET Password=PASSWORD('NewPassword') WHERE User='root';
FLUSH PRIVILEGES;
exit;

Warning: This is not the most secure way of doing this. I disconnect the server from the network before doing this, and reconnect after.

I recently setup ISPConfig 3 RC2, on an Ubuntu 8.04 server following the install instructions provided on the ISPConfig site.  I did however experience an issue with inbound mail being rejected for valid mailboxes with the following error:

Action: failed
Status: 5.1.1
Diagnostic-Code: x-unix; ERR: authdaemon: s_connect() failed: Permission denied
Invalid user specified.

This was resolved by changing the ‘maildrop’ line in ‘/etc/postfix/master.cf’ to:

flags=R user=vmail argv=/usr/bin/maildrop -d vmail ${extension} ${recipient} ${user} ${domain} ${sender}

Additional:

The following may also be required to fix this error:

chmod 4755 /var/run/courier/authdaemon