Plesk using outdated password for MYSQL5.7

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP












5















I'm unable to login to my Plesk control panel, or even pull up the page.



Plesk's repair utilities fail to work, so web/GUI methods seem to be entirely unavailable.



The only way I can login is via command:



mysql -u admin -p [entering correct password]


But Plesk itself cannot connect to MYSQL 5.7, because it's using whatever the old password was.



How do I update the password that Plesk uses to connect to MySQL?










share|improve this question




























    5















    I'm unable to login to my Plesk control panel, or even pull up the page.



    Plesk's repair utilities fail to work, so web/GUI methods seem to be entirely unavailable.



    The only way I can login is via command:



    mysql -u admin -p [entering correct password]


    But Plesk itself cannot connect to MYSQL 5.7, because it's using whatever the old password was.



    How do I update the password that Plesk uses to connect to MySQL?










    share|improve this question


























      5












      5








      5








      I'm unable to login to my Plesk control panel, or even pull up the page.



      Plesk's repair utilities fail to work, so web/GUI methods seem to be entirely unavailable.



      The only way I can login is via command:



      mysql -u admin -p [entering correct password]


      But Plesk itself cannot connect to MYSQL 5.7, because it's using whatever the old password was.



      How do I update the password that Plesk uses to connect to MySQL?










      share|improve this question
















      I'm unable to login to my Plesk control panel, or even pull up the page.



      Plesk's repair utilities fail to work, so web/GUI methods seem to be entirely unavailable.



      The only way I can login is via command:



      mysql -u admin -p [entering correct password]


      But Plesk itself cannot connect to MYSQL 5.7, because it's using whatever the old password was.



      How do I update the password that Plesk uses to connect to MySQL?







      windows mysql plesk mysql5






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Jan 11 at 22:43









      Pimp Juice IT

      23.9k113973




      23.9k113973










      asked Jan 11 at 20:42









      user10902472user10902472

      585




      585




















          2 Answers
          2






          active

          oldest

          votes


















          4














          Pointers for updating the Plesk MySQL password



          1. According to the "The Plesk shows the error: Cannot connect to MySQL 4.1+ using the old insecure authentication" post, you can go to Plesk > Domains > example.com > Databases > User Management > database_name and in the the new window submit the new password.


          2. Additionally, according to the "Plesk is not accessible: Access denied for user 'username' @'localhost' (using password YES)" post, you can run plesk sbin psadb -u --password="password" with the new password from command line.



          Additional Resources & References



          • Updating MySQL Pre-4.1 Password Hashes to be MySQL 5.6 Compatible

          • The Plesk shows the error: Cannot connect to MySQL 4.1+ using the old insecure authentication

          • Plesk is not accessible: Access denied for user 'username' @'localhost' (using password YES)





          share|improve this answer

























          • I have some feedback in my own answer, but thanks for giving me the route to the right track. Your first option though was unavailable to me because I couldn't access the plesk website to begin with.

            – user10902472
            Jan 11 at 21:18











          • @user10902472 I'm glad I could help and that you were able to get it resolved. Thanks for sharing the updated and explicit detail from your answer too. This may save others a headache or two in the future which we helped contribute to.

            – Pimp Juice IT
            Jan 11 at 21:20



















          3














          Following the instructions on a link shared by Pimp Juice's answer, Typing plesk db gave me the error: ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)



          The solution was to combine the two, as I can't find a documented way that plesk db allows username and password options



          1. Run mysql: mysql -u admin -p MyMySQLAdminPassword, which is what plesk db was trying to do with the credentials it knows.

          2. Paste the command UPDATE mysql.user SET authentication_string=PASSWORD("MyMySQLAdminPassword") WHERE user='admin';


          3. quit MYSQL

          4. Run the command: plesk sbin psadb -u --password="MyMySQLAdminPassword", quotes included.





          share|improve this answer






















            Your Answer








            StackExchange.ready(function()
            var channelOptions =
            tags: "".split(" "),
            id: "3"
            ;
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function()
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled)
            StackExchange.using("snippets", function()
            createEditor();
            );

            else
            createEditor();

            );

            function createEditor()
            StackExchange.prepareEditor(
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader:
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            ,
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            );



            );













            draft saved

            draft discarded


















            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1393326%2fplesk-using-outdated-password-for-mysql5-7%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown

























            2 Answers
            2






            active

            oldest

            votes








            2 Answers
            2






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            4














            Pointers for updating the Plesk MySQL password



            1. According to the "The Plesk shows the error: Cannot connect to MySQL 4.1+ using the old insecure authentication" post, you can go to Plesk > Domains > example.com > Databases > User Management > database_name and in the the new window submit the new password.


            2. Additionally, according to the "Plesk is not accessible: Access denied for user 'username' @'localhost' (using password YES)" post, you can run plesk sbin psadb -u --password="password" with the new password from command line.



            Additional Resources & References



            • Updating MySQL Pre-4.1 Password Hashes to be MySQL 5.6 Compatible

            • The Plesk shows the error: Cannot connect to MySQL 4.1+ using the old insecure authentication

            • Plesk is not accessible: Access denied for user 'username' @'localhost' (using password YES)





            share|improve this answer

























            • I have some feedback in my own answer, but thanks for giving me the route to the right track. Your first option though was unavailable to me because I couldn't access the plesk website to begin with.

              – user10902472
              Jan 11 at 21:18











            • @user10902472 I'm glad I could help and that you were able to get it resolved. Thanks for sharing the updated and explicit detail from your answer too. This may save others a headache or two in the future which we helped contribute to.

              – Pimp Juice IT
              Jan 11 at 21:20
















            4














            Pointers for updating the Plesk MySQL password



            1. According to the "The Plesk shows the error: Cannot connect to MySQL 4.1+ using the old insecure authentication" post, you can go to Plesk > Domains > example.com > Databases > User Management > database_name and in the the new window submit the new password.


            2. Additionally, according to the "Plesk is not accessible: Access denied for user 'username' @'localhost' (using password YES)" post, you can run plesk sbin psadb -u --password="password" with the new password from command line.



            Additional Resources & References



            • Updating MySQL Pre-4.1 Password Hashes to be MySQL 5.6 Compatible

            • The Plesk shows the error: Cannot connect to MySQL 4.1+ using the old insecure authentication

            • Plesk is not accessible: Access denied for user 'username' @'localhost' (using password YES)





            share|improve this answer

























            • I have some feedback in my own answer, but thanks for giving me the route to the right track. Your first option though was unavailable to me because I couldn't access the plesk website to begin with.

              – user10902472
              Jan 11 at 21:18











            • @user10902472 I'm glad I could help and that you were able to get it resolved. Thanks for sharing the updated and explicit detail from your answer too. This may save others a headache or two in the future which we helped contribute to.

              – Pimp Juice IT
              Jan 11 at 21:20














            4












            4








            4







            Pointers for updating the Plesk MySQL password



            1. According to the "The Plesk shows the error: Cannot connect to MySQL 4.1+ using the old insecure authentication" post, you can go to Plesk > Domains > example.com > Databases > User Management > database_name and in the the new window submit the new password.


            2. Additionally, according to the "Plesk is not accessible: Access denied for user 'username' @'localhost' (using password YES)" post, you can run plesk sbin psadb -u --password="password" with the new password from command line.



            Additional Resources & References



            • Updating MySQL Pre-4.1 Password Hashes to be MySQL 5.6 Compatible

            • The Plesk shows the error: Cannot connect to MySQL 4.1+ using the old insecure authentication

            • Plesk is not accessible: Access denied for user 'username' @'localhost' (using password YES)





            share|improve this answer















            Pointers for updating the Plesk MySQL password



            1. According to the "The Plesk shows the error: Cannot connect to MySQL 4.1+ using the old insecure authentication" post, you can go to Plesk > Domains > example.com > Databases > User Management > database_name and in the the new window submit the new password.


            2. Additionally, according to the "Plesk is not accessible: Access denied for user 'username' @'localhost' (using password YES)" post, you can run plesk sbin psadb -u --password="password" with the new password from command line.



            Additional Resources & References



            • Updating MySQL Pre-4.1 Password Hashes to be MySQL 5.6 Compatible

            • The Plesk shows the error: Cannot connect to MySQL 4.1+ using the old insecure authentication

            • Plesk is not accessible: Access denied for user 'username' @'localhost' (using password YES)






            share|improve this answer














            share|improve this answer



            share|improve this answer








            edited Jan 12 at 3:30

























            answered Jan 11 at 20:58









            Pimp Juice ITPimp Juice IT

            23.9k113973




            23.9k113973












            • I have some feedback in my own answer, but thanks for giving me the route to the right track. Your first option though was unavailable to me because I couldn't access the plesk website to begin with.

              – user10902472
              Jan 11 at 21:18











            • @user10902472 I'm glad I could help and that you were able to get it resolved. Thanks for sharing the updated and explicit detail from your answer too. This may save others a headache or two in the future which we helped contribute to.

              – Pimp Juice IT
              Jan 11 at 21:20


















            • I have some feedback in my own answer, but thanks for giving me the route to the right track. Your first option though was unavailable to me because I couldn't access the plesk website to begin with.

              – user10902472
              Jan 11 at 21:18











            • @user10902472 I'm glad I could help and that you were able to get it resolved. Thanks for sharing the updated and explicit detail from your answer too. This may save others a headache or two in the future which we helped contribute to.

              – Pimp Juice IT
              Jan 11 at 21:20

















            I have some feedback in my own answer, but thanks for giving me the route to the right track. Your first option though was unavailable to me because I couldn't access the plesk website to begin with.

            – user10902472
            Jan 11 at 21:18





            I have some feedback in my own answer, but thanks for giving me the route to the right track. Your first option though was unavailable to me because I couldn't access the plesk website to begin with.

            – user10902472
            Jan 11 at 21:18













            @user10902472 I'm glad I could help and that you were able to get it resolved. Thanks for sharing the updated and explicit detail from your answer too. This may save others a headache or two in the future which we helped contribute to.

            – Pimp Juice IT
            Jan 11 at 21:20






            @user10902472 I'm glad I could help and that you were able to get it resolved. Thanks for sharing the updated and explicit detail from your answer too. This may save others a headache or two in the future which we helped contribute to.

            – Pimp Juice IT
            Jan 11 at 21:20














            3














            Following the instructions on a link shared by Pimp Juice's answer, Typing plesk db gave me the error: ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)



            The solution was to combine the two, as I can't find a documented way that plesk db allows username and password options



            1. Run mysql: mysql -u admin -p MyMySQLAdminPassword, which is what plesk db was trying to do with the credentials it knows.

            2. Paste the command UPDATE mysql.user SET authentication_string=PASSWORD("MyMySQLAdminPassword") WHERE user='admin';


            3. quit MYSQL

            4. Run the command: plesk sbin psadb -u --password="MyMySQLAdminPassword", quotes included.





            share|improve this answer



























              3














              Following the instructions on a link shared by Pimp Juice's answer, Typing plesk db gave me the error: ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)



              The solution was to combine the two, as I can't find a documented way that plesk db allows username and password options



              1. Run mysql: mysql -u admin -p MyMySQLAdminPassword, which is what plesk db was trying to do with the credentials it knows.

              2. Paste the command UPDATE mysql.user SET authentication_string=PASSWORD("MyMySQLAdminPassword") WHERE user='admin';


              3. quit MYSQL

              4. Run the command: plesk sbin psadb -u --password="MyMySQLAdminPassword", quotes included.





              share|improve this answer

























                3












                3








                3







                Following the instructions on a link shared by Pimp Juice's answer, Typing plesk db gave me the error: ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)



                The solution was to combine the two, as I can't find a documented way that plesk db allows username and password options



                1. Run mysql: mysql -u admin -p MyMySQLAdminPassword, which is what plesk db was trying to do with the credentials it knows.

                2. Paste the command UPDATE mysql.user SET authentication_string=PASSWORD("MyMySQLAdminPassword") WHERE user='admin';


                3. quit MYSQL

                4. Run the command: plesk sbin psadb -u --password="MyMySQLAdminPassword", quotes included.





                share|improve this answer













                Following the instructions on a link shared by Pimp Juice's answer, Typing plesk db gave me the error: ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)



                The solution was to combine the two, as I can't find a documented way that plesk db allows username and password options



                1. Run mysql: mysql -u admin -p MyMySQLAdminPassword, which is what plesk db was trying to do with the credentials it knows.

                2. Paste the command UPDATE mysql.user SET authentication_string=PASSWORD("MyMySQLAdminPassword") WHERE user='admin';


                3. quit MYSQL

                4. Run the command: plesk sbin psadb -u --password="MyMySQLAdminPassword", quotes included.






                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Jan 11 at 21:16









                user10902472user10902472

                585




                585



























                    draft saved

                    draft discarded
















































                    Thanks for contributing an answer to Super User!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid


                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.

                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function ()
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1393326%2fplesk-using-outdated-password-for-mysql5-7%23new-answer', 'question_page');

                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown






                    Popular posts from this blog

                    How to check contact read email or not when send email to Individual?

                    Displaying single band from multi-band raster using QGIS

                    How many registers does an x86_64 CPU actually have?