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

Accessing psa mysql database

Discussion in 'Plesk 10.x for Linux Issues, Fixes, How-To' started by RihadG, Jul 10, 2012.

  1. RihadG

    RihadG Basic Pleskian

    11
    85%
    Joined:
    Jul 10, 2012
    Messages:
    28
    Likes Received:
    0
    Hi, folks. I wanted to upgrade Plesk 10 to 11 but saw this error first:
    So I followed that link and it said IP in the database might be missing. So I wanted to check what's there, but I can't access it.

    root@ns4:/home/rihad# mysql -uadmin -p psa
    Enter password: (here I type in the output of /usr/local/psa/bin/admin --show-password)
    ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)


    What's going on?
     
    Last edited: Jul 10, 2012
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,547
    Likes Received:
    1,241
    Location:
    Novosibirsk, Russia
    What about

    ?
     
  3. RihadG

    RihadG Basic Pleskian

    11
    85%
    Joined:
    Jul 10, 2012
    Messages:
    28
    Likes Received:
    0
    Thanks, it worked. How bizarre that you used encrypted password as cleartext... You guys probably left it like that so that this longstanding idiom still kept working:
     
  4. abdi

    abdi Platinum Pleskian

    31
    18%
    Joined:
    May 14, 2006
    Messages:
    2,913
    Likes Received:
    60
    You can also access the database server using phpmyadmin through which you can manage psa database by:

    Control Panel -> Tools & Settings -> Database Servers -> Manage Server (small icon on the right)
     
  5. RihadG

    RihadG Basic Pleskian

    11
    85%
    Joined:
    Jul 10, 2012
    Messages:
    28
    Likes Received:
    0
    Good point, thanks.
     
  6. abdi

    abdi Platinum Pleskian

    31
    18%
    Joined:
    May 14, 2006
    Messages:
    2,913
    Likes Received:
    60
    Your welcome :)
     
  7. DemonLee

    DemonLee Basic Pleskian

    11
    85%
    Joined:
    Aug 7, 2012
    Messages:
    42
    Likes Received:
    1
    Access PSA MySQL Database

    Query

    If I want to access the psa database from another server, using something like Navicat, can it be done? If it can, it will permit me to copy the whole structure and content onto another server....!
     
Loading...