/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 vote111 views1 answer
Remove from table where
SQL
0 vote117 views1 answer
Pip install mysqlclient error
SQL
2 votes122 views2 answers
Postgresql get table names
SQL
3 votes183 views1 answer
Mysql group_concat distinct
SQL
4 votes110 views3 answers
Order by value mysql
SQL
1 vote132 views1 answer
Insert pg result of select
SQL
2 votes75 views1 answer
Sql group by different columns
SQL
2 votes115 views1 answer
How to search table name in stored procedure in sql server
SQL
4 votes114 views2 answers
Oracle default date format
SQL
1 vote116 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL