How To Use Vanilla Forum On MySQL Database Without Password Set

First of all I want to make it clear that having a MySQL database without a password set (on your root account) is a very very bad idea. However I wanted to set it up on my home machine which has XAMPP installed. And XAMPP by default creates a root account for MySQL without any password. I had several applications installed in that configuration. So I tried to do the same with Vanilla. However Vanilla wouldn’t allow me to do so. Actually the setup goes fine but then it refuses to show claiming failure to connect to the database. Here is a simple solution.

Open conf\database.php. Add the line after $Configuration['DATABASE_USER'] = ‘root’; -
$Configuration['DATABASE_PASSWORD'] = ”;

That’s all folks!

BTW: Just so are on the same page; never ever do it (setup a MySQL root account without password) on any server exposed to the internet. I know I am repeating myself but it it very important as you surely understand.