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

Cannot Reset MariaDB Root password

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.8(EOL)
    • N/A
    • N/A
    • win 10 pro 21H2 on i9 with 32gb RAM & 2x2TB ssds

    Description

      Somehow I've buggered up my password into the MariaDB database I was last working in back in August when I described a potential auto increment bug,
      see MDEV-29416

      So I'm trying to reset the password following the instructions I found here:
      https://mariadbtips.com/mariadb-reset-root-password/

      but it fails at my attempt to login as root. The command window script shows the full sequence:

      *****************************
      C:\Program Files\MariaDB 10.8\bin>net stop mariadb
      The MariaDB service is stopping..
      The MariaDB service was stopped successfully.

      C:\Program Files\MariaDB 10.8\bin>mysqld --skip-grant-tables --skip-networking --shared-memory
      2022-10-05 15:51:36 0 [Note] mysqld (server 10.8.3-MariaDB) starting as process 7916 ...

      C:\Program Files\MariaDB 10.8\bin>mysql -u root
      ERROR 2002 (HY000): Can't connect to server on 'localhost' (10061)

      [my comment: I've seen this error many time before and its always been because the MariaDB service hasn't started, so I start it manually thus:]

      C:\Program Files\MariaDB 10.8\bin>net start mariadb
      The MariaDB service is starting..
      The MariaDB service was started successfully.

      C:\Program Files\MariaDB 10.8\bin>mysql -u root
      ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

      *****************************

      obviously, at that point I can't go any further, so I'm out of options.

      What am I missing?

      Attachments

        Activity

          People

            Unassigned Unassigned
            MikeJacobs Mike Jacobs
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.