Cannot change MySQL root password












0















I have run the following commands found here.



shell> mysql
mysql> FLUSH PRIVILEGES;
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass'


But when I go to login as root, I can type any string as a password, and it will still let me login.



How can I enforce a password for root, and not allow anonymous users by simply typing mysql










share|improve this question
















bumped to the homepage by Community 11 mins ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
















  • Do you have authentication methods other than password enabled for root?

    – Joe W
    Oct 7 '18 at 17:25











  • I am not sure. Just installed MySQL on a virtual machine. I'm not sure how to enable authentication methods with this DBMS.

    – crayden
    Oct 7 '18 at 19:39
















0















I have run the following commands found here.



shell> mysql
mysql> FLUSH PRIVILEGES;
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass'


But when I go to login as root, I can type any string as a password, and it will still let me login.



How can I enforce a password for root, and not allow anonymous users by simply typing mysql










share|improve this question
















bumped to the homepage by Community 11 mins ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
















  • Do you have authentication methods other than password enabled for root?

    – Joe W
    Oct 7 '18 at 17:25











  • I am not sure. Just installed MySQL on a virtual machine. I'm not sure how to enable authentication methods with this DBMS.

    – crayden
    Oct 7 '18 at 19:39














0












0








0








I have run the following commands found here.



shell> mysql
mysql> FLUSH PRIVILEGES;
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass'


But when I go to login as root, I can type any string as a password, and it will still let me login.



How can I enforce a password for root, and not allow anonymous users by simply typing mysql










share|improve this question
















I have run the following commands found here.



shell> mysql
mysql> FLUSH PRIVILEGES;
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass'


But when I go to login as root, I can type any string as a password, and it will still let me login.



How can I enforce a password for root, and not allow anonymous users by simply typing mysql







mysql password






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Oct 7 '18 at 20:14









Evan Carroll

33.3k1076229




33.3k1076229










asked Oct 7 '18 at 16:44









craydencrayden

1011




1011





bumped to the homepage by Community 11 mins ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.







bumped to the homepage by Community 11 mins ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.















  • Do you have authentication methods other than password enabled for root?

    – Joe W
    Oct 7 '18 at 17:25











  • I am not sure. Just installed MySQL on a virtual machine. I'm not sure how to enable authentication methods with this DBMS.

    – crayden
    Oct 7 '18 at 19:39



















  • Do you have authentication methods other than password enabled for root?

    – Joe W
    Oct 7 '18 at 17:25











  • I am not sure. Just installed MySQL on a virtual machine. I'm not sure how to enable authentication methods with this DBMS.

    – crayden
    Oct 7 '18 at 19:39

















Do you have authentication methods other than password enabled for root?

– Joe W
Oct 7 '18 at 17:25





Do you have authentication methods other than password enabled for root?

– Joe W
Oct 7 '18 at 17:25













I am not sure. Just installed MySQL on a virtual machine. I'm not sure how to enable authentication methods with this DBMS.

– crayden
Oct 7 '18 at 19:39





I am not sure. Just installed MySQL on a virtual machine. I'm not sure how to enable authentication methods with this DBMS.

– crayden
Oct 7 '18 at 19:39










1 Answer
1






active

oldest

votes


















0














The following worked for me:



I ran through the command line wizard to set this up:
shell> mysql_secure_installation



Then entered the following:
shell> mysql
ALTER USER 'root'@'localhost' IDENTIFIED with mysql_native_password;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;



Credit goes to this question/answer.






share|improve this answer
























    Your Answer








    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "182"
    };
    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: false,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: null,
    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%2fdba.stackexchange.com%2fquestions%2f219476%2fcannot-change-mysql-root-password%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    The following worked for me:



    I ran through the command line wizard to set this up:
    shell> mysql_secure_installation



    Then entered the following:
    shell> mysql
    ALTER USER 'root'@'localhost' IDENTIFIED with mysql_native_password;
    ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';
    FLUSH PRIVILEGES;



    Credit goes to this question/answer.






    share|improve this answer




























      0














      The following worked for me:



      I ran through the command line wizard to set this up:
      shell> mysql_secure_installation



      Then entered the following:
      shell> mysql
      ALTER USER 'root'@'localhost' IDENTIFIED with mysql_native_password;
      ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';
      FLUSH PRIVILEGES;



      Credit goes to this question/answer.






      share|improve this answer


























        0












        0








        0







        The following worked for me:



        I ran through the command line wizard to set this up:
        shell> mysql_secure_installation



        Then entered the following:
        shell> mysql
        ALTER USER 'root'@'localhost' IDENTIFIED with mysql_native_password;
        ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';
        FLUSH PRIVILEGES;



        Credit goes to this question/answer.






        share|improve this answer













        The following worked for me:



        I ran through the command line wizard to set this up:
        shell> mysql_secure_installation



        Then entered the following:
        shell> mysql
        ALTER USER 'root'@'localhost' IDENTIFIED with mysql_native_password;
        ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';
        FLUSH PRIVILEGES;



        Credit goes to this question/answer.







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Oct 7 '18 at 20:01









        craydencrayden

        1011




        1011






























            draft saved

            draft discarded




















































            Thanks for contributing an answer to Database Administrators Stack Exchange!


            • 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%2fdba.stackexchange.com%2fquestions%2f219476%2fcannot-change-mysql-root-password%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

            Liste der Baudenkmale in Friedland (Mecklenburg)

            Single-Malt-Whisky

            Czorneboh