Plesk is accessible but error sometimes is shown: Access denied for user 'admin'@'localhost' (using password: YES)

Follow

Comments

4 comments

  • Avatar
    iamkingsleyf

    Not working for me, destination server is still showing this error.

     

     Failed to copy content of database 'coupondig'
    Migration tools tried to perform operation in 3 attempts: Command execution failed on the source server 'source' (158.69.247.123) with non-zero exit code.
    command: MYSQL_PWD="$(cat)" mysqldump --no-defaults -h localhost -P 3306 -uadmin --quick --quote-names --add-drop-table --default-character-set=utf8 --set-charset --routines coupondig > /root/plesk_migrator/plesk_migrator-twks464nc88wp9kvxljp749p2mppndcx/db-dumps/coupondig.sql
    exit code: 2
    stdout:
    stderr: mysqldump: Got error: 1045: "Access denied for user 'admin'@'localhost' (using password: YES)" when trying to connect

  • Avatar
    Lev Iurev

    Hi @iamkingsleyf this article is not related to your issue. This is a bug in Plesk Migrator Tool #PMT-3778 and will be fixed in future. In order to fix it perform the following actions on the source server:

     

    1. Create a backup of PSA database:

      # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin psa > psa`date +%F_%H.%M`.sql

    2. Open the database:

      # plesk db

    3. Update psa.DatabaseServers table admin_password for MySQL server localhost on the source server in the psa database:

      mysql> UPDATE DatabaseServers SET admin_password = '********' WHERE host = 'localhost' AND type = 'mysql'; 

    Note: Asterisks in admin_password it is directly asterisks, not another symbols.

  • Avatar
    iamkingsleyf

    Is this a password or i should just use it like that? ********

  • Avatar
    Lev Iurev

    @iamkingsleyf, it is just asterisks

Please sign in to leave a comment.