1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

DBWebadmin in Plesk control panel error#1045

Discussion in 'Plesk for Linux - 8.x and Older' started by karen.pertierra, Feb 16, 2007.

  1. karen.pertierra

    karen.pertierra Guest

    0
     
    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.
     
  2. karen.pertierra

    karen.pertierra Guest

    0
     
    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. :)
     
Loading...