• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.

psa DB Access ?

RodStr

Basic Pleskian
Have read the article that says to use:
mysql -u admin -p password -P8306

I get an "unknown database 'psa' " error.

Yet I can access the tables just fine using the dbclient tool.


eliminating the "psa" from the command line then returns:
ERROR 1035 (28000): Aceess denied for user 'admin'@'localhost' (using password: YES)


Now if I eliminate the -P8306 it logs in fine, but I see no 'psa' database in the database list.


Also, I'm finding I am NOT able to use my Plesk Administrator password, instead I tracked down
the password listed in one of the mysql dumps. That passwords gets me into mySQL but I
don't see the 'psa' DB anywhere. (databaseservers table, and it says port 3306)... am thinking
this may be the communication password for the "client" databases.

Still can't figure out why my panel password won't work to access the mysql psa database though.

Yes, I am in the proper db area
Program Files (x86)\Parallels\Plesk\MySQL\bin


Ideas ?


Rod
 
Last edited:
Was able to circumvent the issue (not resolved, but got around it) by creating a new full access user through the dbclient.exe tool.

dbclient.exe --direct-sql --sql="grant all privileges on *.* to 'username'@'localhost' identified by 'password' with grant option"

I can now see/modify the tables as necessary.

Not the ideal solution, but it should work.

Thanks.

Rod
 
Have you ever changed your panel password after the initial installation? I believe that access to the psa database is not changed after the initial install without manual intervention.
 
That's a possibility. We had a consultant do the initial database configuration and
Plesk install/setup as we are migrating from an OLD IIS5 server running no Control Panel.

Not sure if he changed passwords since the initial install or not.
Will check.

Thanks for the idea!

Rod
 
Back
Top