/SQL/Java.sql.sqlexception: access denied for user

Java.sql.sqlexception: access denied for user

You have to grant priviliges to root@localhost
e.g 
GRANT ALL PRIVILIGES ON *.* TO 'root'@'localhost' IDENTIFIED BY password

(*.*: means everything, it can be modified to some specific DB or opertations)

Java.sql.sqlexception: access denied for user

You can flush the root user's priviliges in mysql cli.

> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
> FLUSH PRIVILEGES;

Java.sql.sqlexception: access denied for user

As you are creating a database from scratch, you could use:

Connection connection = DriverManager.getConnection("jdbc:mysql://localhost/?user=root&password=rootpassword"); 
PreparedStatement ps = connection.prepareStatement("CREATE DATABASE databasename");
int result = ps.executeUpdate();

Source: stackoverflow.com

Similar codes

0 vote190 views1 answer
Mysql add comment to column
SQL
0 vote196 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
0 vote204 views1 answer
Find and replace query in wordpress\
SQL
0 vote219 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
7 votes253 views4 answers
Mysql delete older duplicates
SQL
1 vote169 views1 answer
Into sql
SQL
42 votes273 views6 answers
Install beautifulsoup
SQL
1 vote274 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
0 vote203 views1 answer
Bitmap join index
SQL
15 votes189 views4 answers
Mysql where value is null
SQL