Lanka Developers Community

    Lanka Developers

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Shop

    mysql: ERROR 1524 (HY000): Plugin 'mysql-native-password' is not loaded

    Mac OSX
    mysq mac error524
    2
    8
    2318
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Kasun Rathnayake
      Kasun Rathnayake Web Development last edited by

      ERROR 1524 (HY000): Plugin 'mysql_native_(Password)' is not loaded

      I wasn't prompted to set a root password during the installation and so whenever I tried to use mysql via the mysql -u root -p command. I got this error => Access denied for user 'root'@'localhost'.

      So I searched stack overflow and found an answer that involved setting the authentication plugin to mysql_native_password. the query looked something like this...

      UPDATE user SET plugin="mysql_native_password";
      However, for some reason I typed the command manually instead of copying it and I seem to have written mysql-native-password instead of mysql_native_password (stupid me!!!)

      now I tried to access the mysql shell in various ways but I always get the following error!

      ERROR 1524 (HY000): Plugin 'mysql-native-password' is not loaded

      Tried with safe mode : sudo mysqld_safe --skip-grant-tables &
      also happens to be the same problem ,

      Screenshot 2021-03-07 at 1.04.51 PM.png

      1 Reply Last reply Reply Quote 0
      • root
        root Linux Help last edited by root

        is this on linux ?

        if you in linux .

        sudo su -
        mysql -uroot
        
        Kasun Rathnayake 1 Reply Last reply Reply Quote 0
        • Kasun Rathnayake
          Kasun Rathnayake Web Development @root last edited by

          @root brother on mac ..

          this is not working when i use this command the above comment comes ...
          this error

          ERROR 1524 (HY000): Plugin 'mysql-native-password' is not loaded
          
          1 Reply Last reply Reply Quote 0
          • root
            root Linux Help last edited by

            how did you install mysql ? from brew ?

            Kasun Rathnayake 1 Reply Last reply Reply Quote 0
            • Kasun Rathnayake
              Kasun Rathnayake Web Development @root last edited by

              @root yes ,
              i tried to remove it and install back but error comes again

              same error

              root 1 Reply Last reply Reply Quote 0
              • root
                root Linux Help @Kasun Rathnayake last edited by

                @kasun-rathnayake

                brew remove mysql
                
                brew cleanup
                
                launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
                
                rm ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
                
                sudo rm -rf /usr/local/var/mysql
                

                Then install again

                brew install mysql
                
                Kasun Rathnayake 1 Reply Last reply Reply Quote 0
                • Kasun Rathnayake
                  Kasun Rathnayake Web Development @root last edited by

                  @root this worked brother

                  thank you so much

                  root 1 Reply Last reply Reply Quote 1
                  • root
                    root Linux Help @Kasun Rathnayake last edited by

                    @kasun-rathnayake

                    your welcome

                    1 Reply Last reply Reply Quote 0
                    • 1 / 1
                    • First post
                      Last post

                    0
                    Online

                    3.6k
                    Users

                    1.3k
                    Topics

                    5.3k
                    Posts

                    • Privacy
                    • Terms & Conditions
                    • Donate

                    © Copyrights and All right reserved Lanka Developers Community

                    Powered by Axis Technologies (PVT) Ltd

                    Made with in Sri Lanka

                    | |