{"id":2736,"date":"2015-10-07T01:16:46","date_gmt":"2015-10-07T01:16:46","guid":{"rendered":"https:\/\/qbytes.cloud\/?p=2736"},"modified":"2015-10-07T01:16:46","modified_gmt":"2015-10-07T01:16:46","slug":"how-can-i-access-mysql-databases-in-plesk","status":"publish","type":"post","link":"https:\/\/www.qbytes.cloud\/index.php\/2015\/10\/07\/how-can-i-access-mysql-databases-in-plesk\/","title":{"rendered":"How can I access MySQL databases in Plesk?"},"content":{"rendered":"<p>Linux:<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n\n# mysql -uadmin -p`cat \/etc\/psa\/.psa.shadow` DATABASE_NAME\n\n<\/pre>\n<p>Windows:<br \/>\nThis will retrieve admin password<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n\ncd %plesk_bin%\nplesksrvclient -get\n<\/pre>\n<p>Login to mysql<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n\ncd %plesk_dir%\\mysql\\bin\nmysql -uadmin -pPassword -P8306 \n\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Linux: # mysql -uadmin -p`cat \/etc\/psa\/.psa.shadow` DATABASE_NAME Windows: This will retrieve admin password cd %plesk_bin% plesksrvclient -get Login to mysql cd %plesk_dir%\\mysql\\bin mysql -uadmin -pPassword -P8306<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[70,86,127],"tags":[],"class_list":["post-2736","post","type-post","status-publish","format-standard","hentry","category-mysql","category-plesk","category-winserv"],"_links":{"self":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/posts\/2736","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=2736"}],"version-history":[{"count":0,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/posts\/2736\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/media?parent=2736"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/categories?post=2736"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/tags?post=2736"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}