Resolved How to access Plesk mysql database (psa) on port 8306

[testttt]

I am using Windows Server 2012 R2 and Plesk Onyx 17.8.11

How can I access to plesk database (not other user databases)

I know that it works on port 8306.

What is the username and password?

 

[IgorG]

What about just

plesk db

command in CLI?

 

[testttt]

What about just

plesk db

command in CLI?

But I want to access database from another tool. Such as HeidiSQL.

 

[IgorG]

Please read this blog article All about MySQL Remote Access Under Plesk - Full Guide

 

[testttt]

Please read this blog article All about MySQL Remote Access Under Plesk - Full Guide

Thanks for your reply
I don't need to remote connection. I can connect mySQL databases from remote desktop successfully.
Until the last update I could access the psa database also. (on port 8306)

But now I can not access. Password is changed randomly. In order to connect to psa database on port 8306, I must enter the root password.

So, I have to get this password.

 

[IgorG]

You can use Plesk admin username and corresponding password for connections.

 

[testttt]

You can use Plesk admin username and corresponding password for connections.

Unfortunately, it doesnt work.
Unable to access Plesk database using admin's password in Plesk Onyx 17.8 on Windows
It says that root password of psa database changed randomly since 17.8.11

 

[MarkM]

Have you seen this?

How to retrieve administrator's Plesk database password on Plesk 17.8 for Windows?

 

[testttt]

Have you seen this?

How to retrieve administrator's Plesk database password on Plesk 17.8 for Windows?

Yes it worked. In fact, I tried it yesterday, but it just entered to command line like that

Administrator> plesk sbin psadb --get-admin-password
->

But today it worked and gave me the root password. Thanks very much!