MySQL Query/Connect to eximstats? I'm trying to run a report for my clients in real-time. I created a new eximstats user (renamed the old one) with:

update mysql.user set password=password("XXXXXXXXX") where user="eximstats";


In mysql.db I'm showing eximstats user and DB. 

My connection:

  $exim_connect = new mysqli($exim-&gt;host, $exim-&gt;user, $exim-&gt;password, $exim-&gt;db);


This is my result with and without a password:


  EXIM Connection failed: Access denied for user 'eximstats'@'localhost'
  (using password: YES)


Is this even possible? If yes, what I'm I missing?


cpsrvd 11.52.0.22
Database client version: libmysql - 5.1.73
PHP extension: mysqli
Few reasons could be:


one of them - 'eximstats' has other host than @'localhost' in user table
more than 1 user with same name but different host could also give
error


try to manual connect to the database with this user credentials and check errors if it will be.