Join 1M+ other developers and:
- Get help and share knowledge in Q&A
- Subscribe to topics of interest
- Get courses & tools that help you grow as a developer or small business owner
change mysql user & pass
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');
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×