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]
Leave A Comment