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

          Hide
          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
          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
          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
          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: