changing mysql password via java

Question

I'm trying to change a user's password on mysql using java, i successfully changed it on phpmyadmin but same command doesnt work on java

SET PASSWORD = PASSWORD('12345')

this command will change the current logged in user, i have tried it on java like this

statement = connect.createStatement();
statement.executeUpdate("SET PASSWORD = PASSWORD('12345')");

but nothing happened

i also tried this with root logged in

statement = connect.createStatement();
statement.executeUpdate("SET PASSWORD FOR 'username'@'localhost' = PASSWORD('123456')");

and nothing work,, any help please

Brad Larson · Accepted Answer · 2013-11-16 16:27:44Z

1

you should use executeQuery() method not executeUpdate()

statement = connect.createStatement();
statement.executeQuery("SET PASSWORD FOR 'username'@'localhost' = PASSWORD('123456')");

Note only known password can be changed using the above query.

for example if root password is example then for creating connection we use

Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "example");

So using this connection we can only change present password.

The following is an example based on this code at roseindia.net:

import java.sql.*;
class ChangeRootPassword
{
        public static void main(String[] args) 
        {
                try{
                        Class.forName("com.mysql.jdbc.Driver");
                        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "example");
                        String sql = "SET PASSWORD FOR 'root'@'localhost' = PASSWORD('test')";
                        Statement stmt = conn.createStatement();
                        stmt.executeQuery(sql);
                        stmt.close();
                        conn.close();
                        System.out.println("Password is changed successfully!");
                        }
                catch(Exception ex){
                        ex.printStackTrace();
                        }
        }
}

So the new mysql root password now is test

edited Nov 16, 2013 at 16:27

Brad Larson

170k45 gold badges401 silver badges574 bronze badges

answered Nov 2, 2013 at 9:34

SpringLearner

13.9k20 gold badges82 silver badges117 bronze badges

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

14 Comments

Rahul Over a year ago

You need to use executeUpdate() only for any Insert, Update or Delete query.

SpringLearner Over a year ago

@R.J yes true but for this case executeQuery should be used

Arjan Over a year ago

Credit is required; plagiarism not allowed! Why did you rollback my edit?

Arjan Over a year ago

Again, why did you remove the attribution?

Brad Larson Over a year ago

Do not roll back the attribution of the source of your code. This is your last warning.

|

Collectives™ on Stack Overflow

changing mysql password via java

1 Answer 1

14 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

14 Comments

Your Answer

Sign up or log in

Post as a guest

Related