Cannot reset root

[Gideon Engelbrecht]

After days of trying and following numerous internet posts (by the way Ghatgpt not helpful), I am really desperate.

I am using Mysql 8.3 and also Workbench.

Somehow I stuffed up my root password (root@127.0.0.1:3306). I cannot now connect via Workbench to my database (it asks for a password which I do not know).

So I decided to set it to reset it. These are the steps I followed :

1. Stopped MYSQL80 services. Windows 10 Local services

2. Created a text file (I used Notepad) in my root directory called mysql-init.txt with the following content : alter user 'root'@'localhost' identified by 'New';

3. Opened command prompt in admin mode and entered mysqld -- defaults-file=" C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" --init-file="C:\mysqld -- defaults-file=" C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" --init-file="C:\mysql-init.txt" --console

4. After I hit enter the cmd gives no messages (I was hoping it would with --console)

5. I then restarted the services

6. Deleted the mysql-init.txt in the root folder

7. I then opened Workbench and tried to connect to by database using the password "New". However I get an error Access denied for user 'root'@'localhost' (using password : YES)


Can anyone please free me from the rabbit hole I'm currently in?

Regards