viernes, 9 de octubre de 2009

Error Access phpMyAdmin from Plesk | Plesk + phpMyAdmin

ERROR:

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

SOLUCION:


/usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/config.inc.php
Dentro de este archivo se encuentra los siguientes datos:
$cfg['Servers'][$i]['controluser'] = 'yourUSER';
$cfg['Servers'][$i]['controlpass'] = 'yourPASSWORD';
$cfg['Servers'][$i]['pmadb'] = 'yourDATABASE';

Para solucionar esto hacemos lo siguiente:
  1. mysql -uadmin -p`cat /etc/psa/.psa.shadow`
  2. use mysql;
  3. insert into user values
    ('localhost','yourUSER',password('yourPASSWORD'),
    'N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N',
    '','','','',0,0,0,0);
  4. INSERT INTO `db` VALUES
    ('localhost','yourDATABASE','yourPASSWORD',
    'Y','Y','Y','Y','N','N','N','N','N','N','N','N','N','N','N','N','N');
  5. FLUSH PRIVILEGES;
  6. EXIT