Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4510

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Incomplete
        • Affects Version/s: 5.5.30
        • Fix Version/s: None
        • Component/s: None
        • Labels:
          None

          Gliffy Diagrams

            Attachments

              Activity

              Ascending order - Click to sort in descending order
              Hide
              Permalink
              elenst Elena Stepanova added a comment -

              Hi Wlad,

              Could you please take a look at the thread by the link to see if there is any useful information in German, before I start asking questions?

              Show
              elenst Elena Stepanova added a comment - Hi Wlad, Could you please take a look at the thread by the link to see if there is any useful information in German, before I start asking questions?
              Hide
              Permalink
              serg Sergei Golubchik added a comment -

              First, MySQL exhibit exactly the same behavior.

              Second, the reason probably is — you've migrated from 5.1, and 5.5 adds new privileges, may be you didn't upgrade properly. Either way — your 'root' user does not have ALL privileges, so it cannot grant them to anyone. Verify with SHOW GRANTS or with SELECT * FROM mysql.user and fix that with UPDATE mysql.user

              Show
              serg Sergei Golubchik added a comment - First, MySQL exhibit exactly the same behavior. Second, the reason probably is — you've migrated from 5.1, and 5.5 adds new privileges, may be you didn't upgrade properly. Either way — your 'root' user does not have ALL privileges, so it cannot grant them to anyone. Verify with SHOW GRANTS or with SELECT * FROM mysql.user and fix that with UPDATE mysql.user
              Hide
              Permalink
              elenst Elena Stepanova added a comment -

              Hi Olaf,

              Was the comment above a sufficient explanation? Did you manage to resolve the problem?

              Thanks.

              Show
              elenst Elena Stepanova added a comment - Hi Olaf, Was the comment above a sufficient explanation? Did you manage to resolve the problem? Thanks.
              Hide
              Permalink
              elenst Elena Stepanova added a comment -

              Closing as Incomplete for now. Please comment to re-open if you still have questions.

              Show
              elenst Elena Stepanova added a comment - Closing as Incomplete for now. Please comment to re-open if you still have questions.

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  flammenflitzer Olaf Seebe
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Due:
                    Created:
                    Updated:
                    Resolved: