Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.8(EOL)
-
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?