resetting the root password
OK, so root password is lost. I have (many times) run through the process described in the MySQL docs:
https://dev.mysql.com/doc/refman/8.4/en/resetting-permissions.html
I am unable to get the server to start.
I have tried running it line by using the generic instructions, also, per Windows instructions, I created defaults and ini files, which seem to be being accepted, set it to used shared memory (a detail hidden at the foot of the above documentation) still can’t get it to start.
So – alternatives suggestion? Or am I missing something. My suspicion is that the issue lies with the server configuration, or possibly with the MySQL configuration.
**my.ini
[mysqld]
skip-grant-tables
datadir=”C:/Program Files/MySQL/MySQL Server 8.0/data”
port=3306
mysql-init.txt
ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘**********‘;
—————
Bud The Robin is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.