/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 vote118 views1 answer
Excute raw query
SQL
2 votes132 views1 answer
Sql find not in list
SQL
0 vote116 views1 answer
Check if a word appears at the end sql query
SQL
0 vote132 views1 answer
Ansi sql count duplicate rows
SQL
4 votes141 views3 answers
Mysql get column names from table
SQL
1 vote154 views1 answer
Drop column if exists sql server
SQL
1 vote128 views1 answer
Sql select where id not exists in another table
SQL
2 votes121 views1 answer
Select * from table where name like
SQL
22 votes138 views3 answers
Year format in date mysql
SQL
4 votes119 views2 answers
Insert current date in mysql
SQL