Re: password not working on mySQL server instance

[Mark johnson]

I used this in cmmd prompt as admin.

"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe" --defaults-file="C:\\ProgramData\\MySQL\\MySQL Server 8.0\\my.ini" --init-file="C:\Documents\\mysql-init.txt" --console


i`ve used this in the mysql-init.txt file (with a new password).

USE mysql;
UPDATE mysql.user SET authentication_string=PASSWORD('newpassword')WHERE user = 'root';
FLUSH PRIVILEGES;

but I think I got what was a bunch of errors.