{"id":2293,"date":"2015-06-08T13:05:44","date_gmt":"2015-06-08T13:05:44","guid":{"rendered":"https:\/\/qbytes.cloud\/?p=2293"},"modified":"2015-06-08T13:05:44","modified_gmt":"2015-06-08T13:05:44","slug":"reset-root-password-on-plesk-mysql","status":"publish","type":"post","link":"https:\/\/www.qbytes.cloud\/index.php\/2015\/06\/08\/reset-root-password-on-plesk-mysql\/","title":{"rendered":"Reset root password on plesk mysql"},"content":{"rendered":"<p>Errors in plesk:<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n# \/usr\/local\/psa\/bin\/admin --show-password\nSQLSTATE&#x5B;HY000] &#x5B;1045] Access denied for user &#039;admin&#039;@&#039;localhost&#039; (using password: YES)\n\n<\/pre>\n<p>Accessing the plesk panel:<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n\nERROR: Zend_Db_Adapter_Exception: SQLSTATE&#x5B;HY000] &#x5B;1045] Access denied for user &#039;admin&#039;@&#039;localhost&#039; (using password: YES) (Abstract.php:144)\n\n<\/pre>\n<p>Reset the root password <\/p>\n<p>UPDATE &#8211; See this for cool script to reset the password &#8211; https:\/\/support.plesk.com\/hc\/en-us\/articles\/213364309-Unable-to-access-Plesk-on-Linux-Access-denied-for-user-admin-localhost-using-password-YES-<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n\n# service mysqld stop\n\n<\/pre>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n# mysqld_safe --skip-grant-tables\n<\/pre>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n# service mysqld start\n<\/pre>\n<p>Login:<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n# mysql -uadmin -p`cat \/etc\/psa\/.psa.shadow`\n<\/pre>\n<p>Or,<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n\n# mysql -u root\n\n<\/pre>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n# mysql&gt; use mysql;\n# mysql&gt; update user set password=PASSWORD(&quot;NEW-ROOT-PASSWORD&quot;) where User=&#039;root&#039;;\n# mysql&gt; flush privileges;\n# mysql&gt; quit\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Errors in plesk: # \/usr\/local\/psa\/bin\/admin &#8211;show-password SQLSTATE&#x5B;HY000] &#x5B;1045] Access denied for user &#039;admin&#039;@&#039;localhost&#039; (using password: YES) Accessing the plesk panel: ERROR: Zend_Db_Adapter_Exception: SQLSTATE&#x5B;HY000] &#x5B;1045] Access denied for user &#039;admin&#039;@&#039;localhost&#039; (using password: YES) (Abstract.php:144) Reset the root password UPDATE &#8211; See this for cool script to reset the password &#8211; https:\/\/support.plesk.com\/hc\/en-us\/articles\/213364309-Unable-to-access-Plesk-on-Linux-Access-denied-for-user-admin-localhost-using-password-YES- # service mysqld stop # &#8230; <a title=\"Reset root password on plesk mysql\" class=\"read-more\" href=\"https:\/\/www.qbytes.cloud\/index.php\/2015\/06\/08\/reset-root-password-on-plesk-mysql\/\" aria-label=\"Read more about Reset root password on plesk mysql\">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":[86],"tags":[],"class_list":["post-2293","post","type-post","status-publish","format-standard","hentry","category-plesk"],"_links":{"self":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/posts\/2293","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=2293"}],"version-history":[{"count":0,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/posts\/2293\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/media?parent=2293"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/categories?post=2293"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/tags?post=2293"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}