/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
Find all tables where column name exists oracle
SQL
0 vote109 views2 answers
Uninstall postgresql mac
SQL
1 vote105 views1 answer
Mysql login console
SQL
8 votes152 views6 answers
Insert command in sql
SQL
0 vote110 views1 answer
Get clob size oracle
SQL
0 vote113 views1 answer
SQL get max per id
SQL
0 vote127 views2 answers
Call to undefined function mysql_query()
SQL
0 vote127 views1 answer
Dual in db2
SQL
1 vote109 views1 answer
Xampp import sql file command line
SQL
0 vote114 views1 answer
Amount of entries in a table psql
SQL