Resolve error 1045 (28000) access denied for user 'root'@'localhost' (using password: YES)?


To fix this error, you need to specify the -p option for password.

The syntax is as follows

mysql -uyourUserName -p

Let us implement it.

First, we need to open CMD using Windows+R shortcut keys. The snapshot is as follows

Type CMD and press OK button. You will get a command prompt.

The snapshot is as follows

Now reach the MySQL bin directory.

The snapshot is as follows

Now use the syntax discussed in the beginning.

The command is as follows

Updated on: 30-Jul-2019

4K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements