Access Denied root@localhost – Solved – MySQL Server – Windows – Reset Root Password



Access Denied root@localhost – Solved – MySQL Server – Windows – Reset Root Password

Access Denied root@localhost - Solved - MySQL Server - Windows - Reset Root Password

One of the major errors that you get when you newly install mysql server is the access denied for user root@localhost. This can be easily resolved using a simple command.
The command used in the video:
command 1 – ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘root’
command 2 – mysqld –defaults-file=”C:ProgramDataMySQLMySQL Server 8.0\my.ini” –init-file=c:\mysql-init.txt

Hope your issue is resolved now.
Happy Coding.

Comments are closed.