DE

↑ ↓ select, Enter open, Esc close

List database servers registered in Plesk

harmless rootPleskdebian, ubuntu
root@server
plesk db "SELECT id, host, port, type, admin_login FROM DatabaseServers"

Reads the list of database servers from the Plesk management database. Besides the local MariaDB server, remote MySQL or PostgreSQL servers connected to Plesk appear as well. Useful when it is unclear on which server a domain’s database actually lives.

Note: The admin password column is deliberately not queried.

Open question before approval: Tabellen- und Spaltennamen (DatabaseServers, admin_login) in der psa-Datenbank von Obsidian 18.0.x bestätigen.

Also searched as

  • which database servers does plesk know
  • remote mysql server in plesk
  • check plesk database server port

Related one-liners

All in Plesk

List all databases with their domain in Plesk

#plesk db "SELECT d.name AS domain, db.name AS datenbank, db.type FROM data_bases db JOIN domains d ON d.id = db.dom_id ORDER BY d.name, db.name"
harmlessPlesk

Open the MySQL console as Plesk admin

#plesk db
harmlessMySQL and MariaDB

Use the Plesk MySQL admin in scripts and one-liners

#MYSQL_PWD=$(cat /etc/psa/.psa.shadow) mysql -u admin -e 'SHOW DATABASES;'
cautionMySQL and MariaDB

Back up a single domain with Plesk tools

#plesk bin pleskbackup --domains-name example.com --output-file=/root/backup-example.com.tar
cautionPlesk

Change the password of a Plesk mailbox

#plesk bin mail --update info@example.com -passwd 'NewSecurePassword'
cautionPlesk

Change the PHP version of a domain from the command line

#plesk bin domain --update example.com -php_handler_id plesk-php83-fpm
cautionPlesk

Read first, then run.

The commands on myline.de act directly on servers, files and databases. A wrong path or placeholder can delete data irreversibly or make a server unreachable.

  • All commands are provided without warranty and are not tested on every system.
  • Understand what a command does before running it, and check every placeholder.
  • Make a backup first and, if possible, try it on a test system.
  • You run commands at your own risk. Liability for damages is excluded to the extent permitted by law.