how to change mysql password periodically automatically using JAVA or any script?

Question

I want to change mysql password periodically and want to register the changes password in a Property file.
Can any one suggest as how to achieve the same?

manurajhada · Accepted Answer · 2012-06-02 06:38:16Z

2

Yes, Try to generate a random password with java code and set it as mysql user password by scheduling a cron job or scheduled task by OS and write the same password in property file or mail yourself.. Update the password by java code using this sample code..

String sql = "SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456')";
Statement smt = con.createStatement();
smt.executeQuery(sql);

answered Jun 2, 2012 at 6:38

manurajhada

5,4004 gold badges28 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to change mysql password periodically automatically using JAVA or any script?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related