Question Plesk 17.8 - Deny DB Plesk Access

[Frank.P]

In Plesk 17.5 I can access to plesk db like admin user, but now I upgrade to 17.8 and mysql said Acess Denied

How can I get the new password for user admin?

 

[MarkM]

Can you provide more information as far as what your actual use purpose is? Typically, using the admin user to access the PSA database isn't a smart idea... especially if you are storing these credentials in a script. It is a much safer option to add a new user to the PSA database and provide it the minimum permissions necessary.

 

[Frank.P]

No script. I acces using MySql Cliente.

I need to check certificate table because, one subdomain not show the certificate of main domain and I want to check If references are OK.

 

[Igor Losev]

Hello @Javier P.
Try "plesk db" command from your command prompt or power shell.

 

[Frank.P]

Hello @Javier P.
Try "plesk db" command from your command prompt or power shell.

I need password to search all tablename and see all fields and value

 

[Frank.P]

I go to plesk/bin and run command :
mysql db
use psa
CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypass.';
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;