MySQL Forums
Forum List  »  Newbie

Re: 'root' is denied access to all databases/connections
Posted by: Barry Galbraith
Date: April 17, 2023 12:42AM


mysqld --init-file="path/to/file.txt" --console
The refman says you should also provide the --defaults-file option.
C:\> mysqld
         --defaults-file="C:\\ProgramData\\MySQL\\MySQL Server 8.0\\my.ini"


ALTER USER ALTER USER 'root'@'localhost' IDENTIFIED BY '[my password]'

The refman shows
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
replacing MyNewPass with your new password.
You have ALTER USER ALTER USER which will give an error, and not change your password.

You need to follow the refman more closely.

Good luck,

Options: ReplyQuote

Written By
Re: 'root' is denied access to all databases/connections
April 17, 2023 12:42AM

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.