DBWebadmin in Plesk control panel error#1045

[karen.pertierra]

Hello Guys,

I had a long and terrible upgrade process from plesk 7.5.4 to 8.0 version. I have several domains but all cannot get into their database. Whenever they click the DB WebAdmin icon, it says,

#1045 - Access denied for user 'pma_dx349rmSH4Ji'@'localhost' (using password: YES)

Could anybody tell me what can I do? I have full access to the servers shell.

 

[karen.pertierra]

Now I got the solution! I set the following settings:

---------------------------------------------------------
$cfg['Servers'][$i]['controluser'] = '';
if ($db_host != 'localhost') $cfg['Servers'][1]['controluser'] = '';

$cfg['Servers'][$i]['controlpass'] = '';
if ($db_host != 'localhost') $cfg['Servers'][1]['controluser'] = '';

$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = "$db_user";
$cfg['Servers'][$i]['password'] = "$db_pass";
$cfg['Servers'][$i]['only_db'] = "$db_name";
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['pmadb'] = '';
---------------------------------------------------------

Originally, i have the following values for the following:

controluser pma_dx349rmSH4Ji
controlpass dx349rmSH4Ji7
pmadb phpmyadmin_dx349rmSH4Ji

I just set the values to nothing.

Hope this helps.