Resolved Login as admin to mysql remotely

[VojinP]

I have dozens of databases on server and need to configure one by one in DataGrip to get access, and this works. Is there ANY way to configure remote access as admin and see all databases at once?

 

[IgorG]

https://support.plesk.com/hc/en-us/articles/360010318753-How-to-connect-to-MySQL-database-hosted-on-Plesk-server-from-remote-machine-

 

[VojinP]

I'm not sure you understand my question. I can successfully access each database remotely with database user. But instead of creating separate accounts in any program (like sqlyog or data grip) I want to login as admin to mysql and have all databases in the list.

 

[VojinP]

I have tried to connect with plain admin pass, with encrypted admin pass, to 3306 and 8306, but no combination worked.

 

[Bitpalast]

Actually, when you use the "Tools & Settings" > "Database" menu, you can access all databases through phpMyAdmin at once as you are logged in as admin. Simply click on the phpMyAdmin/maintenance icon at the right edge of the list of database servers (where normally only one or two will be shown).

And if you want to access all databases at once, you can simply add a suitable user to the "users" table of your database, allowing access to all databases. Build it similar to the admin user, but don't try to call it admin or root.

 

[VojinP]

Thank you Peter, it works!