MySQL access denied - even if the user has all privileges

[eluser]Rey Philip Regis[/eluser]
The default user and the most powerful user in MYSQL is the root user, and in a fresh install I know it has no password. Just like in my local server right now..So what you do is open your config.php and dont specify a password.

Code:

$db['default']['hostname'] = "localhost";
$db['default']['username'] = "root";
$db['default']['password'] = ""; // no password
$db['default']['database'] = "Db_Name";
$db['default']['dbdriver'] = "mysql";
$db['default']['dbprefix'] = "";
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_general_ci";

Good day..