mysql connection error

Hi

when I try to use phpmyadmin through my browser I get the following error message;

'Welcome to phpMyAdmin 2.5.4

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.

Error

MySQL said:


#1045 - Access denied for user: 'root@localhost' (Using password: YES)'



I configuered the config.in.php with using 'localhost' as the HOST, 'root' as USER and 'my_password' as PASSWORD.

I tried changing host and user to specify those in my mysql.ini but this still didn't work, I just go a slightly differerent error saying;

#1130 - Host 'host_name' is not allowed to connect to this MySQL server.

Also when I try to create a database through the mysql monitor using the 'create database dbname;'
command I get;

Error 1044: Access denied for user: '@locahost'


I think I must have something configured incorrectly, any ideas what it could be?

Thanks

Izzy

Man database is a big problem.. but i think you can try this.. go to you config.inc.php and then make these changes
$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = ''; //remember leave it '' dont type in anything inside

copy that replace the old one.. and it will work..