How to create a new user for MySQL with Java?

Question

I want to create a new user for a MySQL database from NetBeans but I don't know the core code for it.

I've tried:

try {

    String query = "CREATE USER = '?' @'localhost' IDENTIFIED BY = '?'; ";

    con = DriverManager.getConnection(url, uname, pwd);
    PreparedStatement pstmnt = con.prepareStatement(query);

    pstmnt.setString(1, newUser[0]);
    pstmnt.setString(2, newUser[3]);

    pstmnt.execute();
    pstmnt.close();

} catch (SQLException ex) {
    ex.printStackTrace();
}

The output is:

java.sql.SQLException: 
Parameter index out of range (1 > number of parameters, which is 0).

I know in MySQL you can create a new user using:

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';

What is your question exactly? Based on this, your prepared statement syntax is wrong: docs.oracle.com/javase/7/docs/api/java/sql/… — Aluan Haddad
– Aluan Haddad, Commented May 19, 2017 at 7:16

Community · Accepted Answer · 2017-05-23 12:34:47Z

0

TimSolo How To have Dynamic SQL in MySQL Stored Procedure states that After 5.0.13, in stored procedures, you can use

dynamic sql

Omesh MySQL CREATE USER with a variable? uses dynamic SQL to create a new user and grant privileges

my concoction uses

stored procedures + dynamic sql

to produce the following answer for creating a new user:

CREATE DEFINER=`root`@`localhost` PROCEDURE `new_procedure`(IN username VARCHAR(250), IN pwd VARCHAR (100))
BEGIN

SET @s = CONCAT('CREATE USER "',username,'"@"localhost" IDENTIFIED BY "',pwd,'"');
PREPARE stmt FROM @s;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
END

edited May 23, 2017 at 12:34

CommunityBot

11 silver badge

answered May 19, 2017 at 9:02

Yeezus

4021 gold badge5 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

How to create a new user for MySQL with Java?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related