/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 vote240 views1 answer
Add timestamp column to existing table ms sql server
SQL
0 vote240 views1 answer
Mysql in clausule string array
SQL
5 votes248 views2 answers
Sql server port number
SQL
1 vote250 views1 answer
Table infromation in sql server
SQL
1 vote239 views1 answer
How to update date add hours in postgresql
SQL
5 votes248 views6 answers
Sql foreign key
SQL
2 votes234 views1 answer
Sql alchemy or
SQL
5 votes222 views3 answers
Truncate function in sql oracle
SQL
8 votes235 views2 answers
Change name of colum in sql table
SQL
1 vote226 views1 answer
Oracle first row
SQL