MySQL Forums
Forum List  »  Newbie

Re: password not working on mySQL server instance
Posted by: Mark johnson
Date: December 04, 2022 10:33PM

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';

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

Options: ReplyQuote

Written By
Re: password not working on mySQL server instance
December 04, 2022 10:33PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.