i have a remote database setup. and my database is connected with my web server through private network.
so i created 2 users with following command
GRANT ALL ON wordpress.* TO 'wordpressuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL ON wordpress.* TO 'wordpressuser'@'Private_IP' IDENTIFIED BY 'password';
now i need to change password, does the following command is enough to change? or i need to take any extra step to ensure previous access is revoked.
SET PASSWORD FOR 'wordpressuser'@'localhost' = PASSWORD('new-password');
SET PASSWORD FOR 'wordpressuser'@'Private_IP' = PASSWORD('new-password');
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
That is enough, but this query will give you a warning and if you read it you see that you do not need to use the PASSWPRD function and instead use plain text password, like this:
SET PASSWORD FOR 'wordpressuser'@'Private_IP' = 'new-password';
Hi @newbie Since it’s WordPress, meaning PHP, it doesn’t have an idle connection kept alive, so every time it shows a page, it actually does a connection to the database and authenticates every time. So that means you’re all good - no reason to restart the database or anything like that. To do a test, you can simply change the MySQL password to something different and WordPress will give you a database error instantly on reload of a page.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.