Masalah MySQL menjadi lambat karena "unauthenticated user"

Jika suatu ketika server database MySQL Anda menjadi lambat. Coba cek dahulu, buka mysql client :

$> mysql -u root -p

Jalankan perintah :

mysql> show full processlist;


Jika terlihat banyak "unauthenticated user" dalam daftar yang muncul. Maka mungkin Anda perlu merubah konfigurasi mysql Anda.

Tambahkan baris :

skip-name-resolve

pada berkas konfigurasi mysql Anda. Dan re-start mysql server Anda.

WordpressMU with wp-phpmailer and WP e-Commerce plugins

First install WordPressMU from here.
+ Open the package file
+ I placed the files in /var/www/wpmu
+ sudo chown -R www-data:www-data /var/www/wpmu
+ Create/edit /etc/apache2/site-available/wpmu

<virtualhost>
   ServerName wpmu.localhost.localdomain
   DocumentRoot /var/www/wpmu
   <directory>
       Options Indexes MultiViews FollowSymLinks
       AllowOverride None
       Order deny,allow
       Deny from all
       Allow from 127.0.0.0/255.0.0.0 ::1/128
   </directory>
</virtualhost>

+ sudo a2ensite wpmu
+ sudo /etc/init.d/apache2 reload
+ sudo vi /etc/hosts, add wpmu.localhost.localdomain on 127.0.0.1

127.0.0.1 localhost localhost.localdomain wpmu.localhost.localdomain

+ Create MySQL user & database name it both : wpmu
+ open-up http://wpmu.localhost.localdomain
+ just fill-up the fields
+ OK. wpmu should be up and running

I try to create a new blog.
Somehow wpmu send activation/password via email but I don't remember I ever setting some SMTP or else in wpmu. No wonder the email never come.
I search this issue and I got this link .
You need to download this plugin.
After you extract the plugin to /var/www/wpmu/wp-content/plugins/, you need to activate it via plugins menu with admin user.
And set the SMTP server under Options menu.

Other plugin you may have interested as I need to search a shopping cart with multiple store support is WP e-Commerce.

Some issues with wordpress :
- the mail notification didn't report any error even when there is no mailer installed.
- cannot delete user before the user is active. I need to wait until 2 days when automatic removal removed the user that did not confirm the activation.