CODEWITHSUNDEEP
mysql
Walter
Walter

Reputation: 11

Cannot alter user in MySQL database

I have an issue with connection to MySQL database.

Internet says that error Unable to load authentication plugin 'caching_sha2_password' can be fixed with ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123';.

The issue is that this command doesn't work. ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123'; also doesn't work.

First command affects 0 rows and has an error 1 factor authentication method does not match against authentication policy. Please refer @@authentication_policy system variable., second one returns an error Operation ALTER USER failed. Of course I'm replacing 123 with my real admin password.

I'm absolutely out of ideas, I hope I can get some clues why this command doesn't work.

Edit

I think the only solution is to uninstall newest MySQL version and install an older one that actually works. Topic closed.

Upvotes: 1

Views: 1176

Answers (1)

psykx
psykx

Reputation: 293

You need to FLUSH PRIVILEGES after a user update command.

Upvotes: 1

Related Questions