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

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

Options: ReplyQuote


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


Sorry, only registered users may post in this forum.

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.