{"id":217,"date":"2011-06-22T07:48:00","date_gmt":"2011-06-22T07:48:00","guid":{"rendered":"http:\/\/pheonixsolutions.com\/?p=217"},"modified":"2026-04-15T18:39:12","modified_gmt":"2026-04-15T13:09:12","slug":"plesk-and-mysql","status":"publish","type":"post","link":"https:\/\/pheonixsolutions.com\/blog\/plesk-and-mysql\/","title":{"rendered":"Plesk CLI Administration Guide: Managing Domains, Emails, and Databases"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Introduction<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Plesk provides a powerful command-line interface (CLI) and database structure that allows administrators to manage domains, users, email accounts, and databases efficiently. This guide outlines useful commands and queries to retrieve account details and perform common administrative tasks directly from the server.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Prerequisites<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Before proceeding, ensure the following:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Root or sudo access to the Plesk server<\/li>\n\n\n\n<li>Access to the Plesk internal database (<code>psa<\/code>)<\/li>\n\n\n\n<li>Basic knowledge of Linux command line<\/li>\n\n\n\n<li>MySQL\/MariaDB client installed<\/li>\n\n\n\n<li>Proper permissions to execute Plesk CLI utilities located in <code>\/usr\/local\/psa\/bin\/<\/code><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Implementation<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>1. Retrieve Domain Account Information<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql -uadmin -p`cat \/etc\/psa\/.psa.shadow` -D psa -e \"<br>SELECT login, password, home <br>FROM sys_users <br>INNER JOIN accounts ON accounts.id = sys_users.account_id;\"<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>2. Get Client Login Details<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql -uadmin -p`cat \/etc\/psa\/.psa.shadow` -D psa -e \"<br>SELECT login, password <br>FROM clients <br>INNER JOIN accounts ON accounts.id = clients.account_id;\"<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>3. Retrieve Mail Account Information<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql -uadmin -p`cat \/etc\/psa\/.psa.shadow` -D psa -e \"<br>SELECT CONCAT_WS('@', mail.mail_name, domains.name) AS email,<br>accounts.password <br>FROM domains, mail, accounts <br>WHERE domains.id = mail.dom_id <br>AND accounts.id = mail.account_id <br>ORDER BY domains.name ASC, mail.mail_name ASC;\"<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>4. Manage Mail Accounts via CLI<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Create Mail Account<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">\/usr\/local\/psa\/bin\/mail -c USER@DOMAIN.COM -passwd PASSWORD -mailbox true -cp-access true<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Update Mail Account<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">\/usr\/local\/psa\/bin\/mail -u USER@DOMAIN.COM -passwd NEWPASS<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Remove Mail Account<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">\/usr\/local\/psa\/bin\/mail --remove USER@DOMAIN.COM<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>5. Mailing List Management<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Create Mailing List<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">\/usr\/local\/psa\/bin\/maillist --create MYLIST -domain DOMAIN.COM \\<br>-passwd_type plain -passwd PASS -notify false -email LISTADMIN@DOMAIN.COM<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Add Member<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">\/usr\/local\/psa\/bin\/maillist -u MYLIST -domain DOMAIN.COM -members add:NEW@DOMAIN.COM<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Remove Member<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">\/usr\/local\/psa\/bin\/maillist -u MYLIST -domain DOMAIN.COM -members del:NEW@DOMAIN.COM<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>View Members<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">\/usr\/local\/psa\/bin\/maillist -i MYLIST -domain DOMAIN.COM<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Delete Mailing List<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">\/usr\/local\/psa\/bin\/maillist -r MYLIST -domain DOMAIN.COM<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>6. Database Management<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Create Database<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">\/usr\/local\/psa\/bin\/database --create DBNAME -domain DOMAIN.COM \\<br>-server localhost:3306 -add_user DBUSER -passwd PASS<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Remove Database<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">\/usr\/local\/psa\/bin\/database -r DBNAME<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Conclusion<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Using Plesk\u2019s CLI tools and direct database queries can significantly streamline server administration tasks. These commands allow administrators to efficiently manage users, domains, email accounts, mailing lists, and databases without relying solely on the web interface. Proper usage can improve automation, reduce manual effort, and enhance overall server management efficiency.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction Plesk provides a powerful command-line interface (CLI) and database structure that allows administrators to manage domains, users, email accounts, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[1019],"tags":[],"class_list":["post-217","post","type-post","status-publish","format-standard","hentry","category-cloud-aws","psol-cat-cloud-aws"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/phn2x7-3v","jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/217","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=217"}],"version-history":[{"count":2,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/217\/revisions"}],"predecessor-version":[{"id":9958,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/217\/revisions\/9958"}],"wp:attachment":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=217"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=217"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=217"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}