/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 vote324 views1 answer
Delete from IN subquery
SQL
0 vote270 views1 answer
Formatting code with SQL Developer
SQL
2 votes318 views1 answer
Mysql select true or false
SQL
0 vote263 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote264 views1 answer
Alter table name including schema
SQL
1 vote285 views1 answer
Vagrant mysql downgrade version
SQL
9 votes278 views4 answers
SQL Date Format
SQL
2 votes297 views1 answer
Query to check cpu utilization in oracle database
SQL
2 votes275 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote278 views2 answers
Disadvantages of stored procedures sql
SQL