# plesk db "select db.name as 'Database', d.name as 'Related to' from data_bases db, domains d, dom_param p where d.id=p.dom_id and p.val=db.id and p. Please note that this query does not list databases that were created together with applications via the Plesk Applications menu. Specify TCP/IP port different from 3306 as it is used for MySQL/MariaDB server shipped with Plesk. Upgrade MySQL server as described in the the MySQL documentation. If it is not set, database will not appear in the list. Add MySQL/MariaDB server to the installation. I can also access a second database from within Domain1, with this: Select from DBName2.DBTable2 All is good. This SQL query lists all databases that have the option "Related to" defined in Plesk. | wordpress_a | wordpress.tld | Administrator | admin | | joomla_7 | joomla.tld | Administrator | admin | You can update Plesk and third-party components by clicking Tools & Settings > Updates (under Plesk), and then going to the Update Components tab. | Database | Subscription | Owner | Owner Username | Updating Plesk Manually via the User Interface. # plesk db "select db.name as 'Database',d.name as 'Subscription',c.pname as 'Owner',c.login as 'Customer Username' from data_bases db,domains d,clients c where d.cl_id=c.id and db.dom_id=d.id" This SQL query lists all databases with corresponding subscriptions and customers. How to list databases with their subscription/domain/owner using a SQL query in Plesk? Answer The database utility is used to manage databases and database users in Plesk through CLI. The database-server utility is used to manage database server entries in Plesk through CLI. Go to Tools & Settings > Database Servers > Settings > click on the Local MySQL Settings link: Select the Allow local MySQL server to accept external connections checkbox and click OK to apply changes: Allow remote access to MySQL database server in Plesk for Linux and Plesk for Windows for a specific user: Log into Plesk.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |