beta.blog

It’s always a good idea to regularly change the password of your MySQL user accounts. I’ve found several ways showing how to do that, but many of them didn’t work properly at all. It costed me quite a lot of effort and time, the overall solution has took me about a half hour time, even though the solution is really simple.

So here’s how to change the password of a MySQL user:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');

A simple but effective way to change a user’s password, in my case it’s the user root.