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.

[root@iserversupport ~]#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

[sep][/sep]

[button size=”large” color=”green” title=”Server Administration Services from Stack Supports” link=”http://iserversupport.com/server-support-products/server-security/”]View Server Administration Packages[/button]