How to change MySQL database password?

Are you interested for monthly server support with Unlimited tickets, 24×7 monitoring, Security Audit and lot more ? please check our Monthly server support plans

For changing mysql database password from server end, follow the steps below,

Step 1)

Login to mysql server and select the mysql database.

[[email protected] ~]#mysql
> use mysql

2) Execute the following query:-

mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') WHERE Host = 'some_host' AND User = 'some_user'; mysql> FLUSH PRIVILEGES;

eg:-


mysql>UPDATE mysql.user SET Password = OLD_PASSWORD(‘oldpassword’)

WHERE Host = ‘localhost’ AND User = ‘iserversupport′;

mysql> FLUSH PRIVILEGES;

Need our help to fix the issue ? Submit Support Ticket Now

View Server Administration Packages

Leave a Reply

Your email address will not be published. Required fields are marked *