{"id":2553,"date":"2015-08-14T03:54:51","date_gmt":"2015-08-14T03:54:51","guid":{"rendered":"https:\/\/qbytes.cloud\/?p=2553"},"modified":"2015-08-14T03:54:51","modified_gmt":"2015-08-14T03:54:51","slug":"shortcuts","status":"publish","type":"post","link":"https:\/\/www.qbytes.cloud\/index.php\/2015\/08\/14\/shortcuts\/","title":{"rendered":"Mysql Shortcuts"},"content":{"rendered":"<p>Linux Shortcuts<\/p>\n<p>Find Plesk Password on older plesk versions. Login via ssh as root and run the following command:<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n\n# \/usr\/local\/psa\/bin\/admin --show-password\n\n<\/pre>\n<p>Show encrypted admin password:<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n\n# cat \/etc\/psa\/.psa.shadow\n\n<\/pre>\n<p>Show Plesk MySQL password<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n\n# mysql -uadmin -p`cat \/etc\/psa\/.psa.shadow`\n\n<\/pre>\n<p>Show processlist<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n\n# mysqladmin -u admin -p`cat \/etc\/psa\/.psa.shadow` processlist\n\n<\/pre>\n<p>Export Plesk database<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n\n# mysqldump  -u admin -p`cat \/etc\/psa\/.psa.shadow` database &gt; \/tmp\/database.sql\n<\/pre>\n<p>Import Plesk database<br \/>\n# mysql  -u admin -p`cat \/etc\/psa\/.psa.shadow` database < \/tmp\/database.sql\n\n\n\t\n\nEmail Commands\n[bash]\n\n\/usr\/local\/psa\/admin\/bin\/mailqueuemng -s\ntail -50 \/usr\/local\/psa\/var\/log\/maillog\ntail -50 \/var\/log\/maillog\ntail -50 \/var\/log\/exim_mainlog\n\n[\/bash]\n\nRAM\n[bash]\n\n# curl -s http:\/\/dev.patlathem.com\/mem.txt | python\n\n[\/bash]\n\nWindows Shortcuts\n[bash]\n\ncd %plesk_bin%\nplesksrvclient -get\n\n[\/bash]\n\n\t\n[bash]\n\nrdesktop -g 1024x768 -P IPaddress -u administrator\nrdesktop ipaddress -g 1024x768\n\n[\/bash]\n[bash]\n# mysql -uroot -p status\nUptime: 68730 Threads: 378 Questions: 459474 Slow queries: 0 Opens: 17283 Flush tables: 15 Open tables: 201 Queries per second avg: 6.685\n[\/bash]\n\n[bash]\n# mysqladmin -uroot -p processlist\nEnter password: \n+----+------+-----------+----+---------+------+-------+------------------+\n| Id | User | Host      | db | Command | Time | State | Info             |\n+----+------+-----------+----+---------+------+-------+------------------+\n| 13 | root | localhost |    | Query   | 0    | init  | show processlist |\n+----+------+-----------+----+---------+------+-------+------------------+\n\n[\/bash]\n\n<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Linux Shortcuts Find Plesk Password on older plesk versions. Login via ssh as root and run the following command: # \/usr\/local\/psa\/bin\/admin &#8211;show-password Show encrypted admin password: # cat \/etc\/psa\/.psa.shadow Show Plesk MySQL password # mysql -uadmin -p`cat \/etc\/psa\/.psa.shadow` Show processlist # mysqladmin -u admin -p`cat \/etc\/psa\/.psa.shadow` processlist Export Plesk database # mysqldump -u admin -p`cat &#8230; <a title=\"Mysql Shortcuts\" class=\"read-more\" href=\"https:\/\/www.qbytes.cloud\/index.php\/2015\/08\/14\/shortcuts\/\" aria-label=\"Read more about Mysql Shortcuts\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[70],"tags":[],"class_list":["post-2553","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/posts\/2553","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/comments?post=2553"}],"version-history":[{"count":0,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/posts\/2553\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/media?parent=2553"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/categories?post=2553"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/tags?post=2553"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}