无法连接到MySQL：（1045）用户'root'@'localhost'拒绝访问（使用密码：YES）[复制]

Question

This question already has an answer here:

• #1045 - Access denied for user 'root'@'localhost' (using password: YES) 21 answers

I am deploying a Wordpress enviroment, and there seems to happen a weird situation.

I did some tweakings and set a new root password like this

mysql -u root –p
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'MyNewPass';
service mysql restart
ufw allow 3306

then I changed the settings of bind from /etc/mysql/mysql.conf.d to from 127.0.0.1 to 0.0.0.0 so that I can access it via mySQL Workbench. Which was successful as I now am able to enter the DB from outside sources.

Once I changed the password, I altered the wp-config.php file and set the new credentials.

However, now, I am getting errors inside the WordPress whenever I log on, I see the following errors, despite the fact that the website runs without any issues and the articles appear.

 Failed to connect to MySQL: (1045) Access denied for user 'root'@'localhost' (using password: YES)

Below is an image of the error I am getting

I tried manny different scenarios on SO, and I am really sorry in advance for posting this again, but non of the solutions provided work.

Any ideas on resolving this?

And while we are at it,

1. what does (using password: YES) or (using password: NO) mean ?
2. What is the difference between root@localhost and root@127.0.0.1

</div>

Answer 1

using password: YES shows that you entered mysql password.

127.0.0.1 and localhost are same