java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

Question

The following code:

Class.forName("com.mysql.jdbc.Driver");
Connection m_connection = DriverManager.getConnection("jdbc:mysql://localhost","root","root");

Throws this exception on getConnection():

java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919)
    at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1694)
    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1244)
    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2397)
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2430)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2215)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:813)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:334)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at db.Database.<init>(Database.java:91)
    at db.Main.main(Main.java:10)

How is this caused and how can I solve it?

EDIT:

    public static void main(String[] args) throws ClassNotFoundException, ServletException, SQLException 
    {

        try
        {
            Connection conn = (Connection) DriverManager.getConnection("jdbc:mysql://localhost/?user=root&password=rootpassword"); 
            Statement   s = (Statement) conn.createStatement();
            int result = s.executeUpdate("CREATE DATABASE databasename");
        }


        catch ( Exception e)
        {
            e.printStackTrace();
        }
}

Produces :

java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919)
    at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1694)
    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1244)
    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2397)
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2430)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2215)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:813)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:334)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at db.Main.main(Main.java:19)

are you able to connect using mysql GUI client like SqlYog or PhpMyAdmin? — Tomer, Aug 12 '12 at 12:56
Are you sure the **Username** and the **Password** so provided is right ? Seesm to me there is no such user as **root** :( Not sure though, but don't you have to provide the **Database Name** too like `Connection con = DriverManager.getConnection("jdbc:mysql://localhost;database=mywebsitedb;user=sa;password=thatstrue;");` — nIcE cOw, Aug 12 '12 at 13:02
@GagandeepBali: think once again about it: If the login was wrong, how would the OP be able to access it by phpmyadmin then? — BalusC, Aug 12 '12 at 13:03
@BalusC : Actually never used `phpmyadmin`, though I had used `SQLServer` sometimes, those fields are autofilled by default, and we forget them. That's why that guess was as comments, else it could become an answer, if I thought that is really the case (which it may or may not be the case). Though since you are offended by that comment, I would be very much wrong in asking the same , my bad :-) — nIcE cOw, Aug 12 '12 at 13:08
There are 2 things you need to establish - are you a valid user, do you have the authority (privileges) to perform the action. Authority takes the form of a specific privilege from a specified host. It is possible to answer both questions before introducing any Java. Personally, I'd use the command line to connect to my sql as the user specified, e.g. 'mysql -uroot -prootpassword', then execute the command 'create database mydb'. If this works you can drop the database and head over to your Java code. — Romski, Aug 12 '12 at 13:50

evg · Answer 1 · 2016-07-05T21:57:24.500

66

This can help you:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY '%password%' WITH GRANT OPTION;

Execute it with command line or some GUI tool.

Don't forget to replace %password% with real password.

edited Jul 05 '16 at 21:57

answered Aug 12 '12 at 13:23

evg

1,308
1
7
12

1

@evg I have successfully executed this query but still not getting rid from this error – palak sharma Aug 24 '16 at 10:54
@evg Whether the above solution works for the below one also. Here instead of localhost, IP address is mentioned as below **java.sql.SQLException: Access denied for user ''@'1.1.22.85' (using password: YES).** – Ashok kumar Ganesan Jun 08 '20 at 05:26
If anyone facing Access Denied problem after applying this solution then you can apply [link](https://stackoverflow.com/a/12670234/9340694) solution for life easy. Thanks – Nazmul81 Dec 21 '21 at 03:06

score 28 · Answer 2 · answered Sep 23 '18 at 04:41

This is specific to Ubuntu 18.04 LTS and MySQL 5.x Followed this link Follow everything from here onwards:

sudo mysql_secure_installation

sudo mysql

Once logged into MySQL then from the MySQL prompt execute these commands:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
FLUSH PRIVILEGES;

Now verify that the table has the password for the root

SELECT user,authentication_string,plugin,host FROM mysql.user;

This solved my issue and now i am able to login.

"Now verify that the table has the password for the root" - and what if it does not? ;) — Line, Jan 11 '21 at 22:30

Reimeus · Accepted Answer · 2015-12-09T18:59:55.677

23

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();

Here is an identical scenario.

edited Dec 09 '15 at 18:59

answered Aug 12 '12 at 13:04

Reimeus

158,255
15
216
276

If I don't have any database at all ? and I want to create the database using java code , and NOT manually in `phpmyadmin` , then `databaseName` is not relevant ? – JAN Aug 12 '12 at 13:06
I was working on one of my application, the connectivity between the code and the database was fine. I started getting this error suddenly, dont know why and what to do. – viveksinghggits Feb 09 '17 at 04:35

score 9 · Answer 4 · answered Jun 20 '15 at 18:16

I had a similar problem, but the differemce was: I didn't executed my JavaApp from localhost, but from a remote PC. So I got something like java.sql.SQLException: Access denied for user 'root'@'a.remote.ip.adress' (using password: YES) To solve this, you can simply login to phpMyAdmin, go to Users, click add user and enter the host from which you want to execute your JavaApp (or choose Any Host)

score 8 · Answer 5 · answered Oct 13 '15 at 13:43

you can use this

   static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";  
   static final String DB_URL = "jdbc:mysql://localhost:3306/YOUR_DB_NAME";


   static final String USER = "root";
   static final String PASS = "YOUR_ROOT_PASSWORD"; 

  Connection conn = DriverManager.getConnection(DB_URL,USER,PASS);

you have to give the right root password .

score 6 · Answer 6 · edited Jun 08 '20 at 07:23

6

I had the same issue like below

"java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)". Problem was "WRONG PASSWORD".

Copy and paste the query as-it-is in the shell to check whether it gives the desired output or not. Small errors consumes more time.

edited Jun 08 '20 at 07:23

Ashok kumar Ganesan

1,098
5
20
48

answered Sep 08 '16 at 20:41

Pratyush Raunak

61
1
3

I had same problem. I was wrong with the password specified in the application.properties. It should be same as your local database password. – Muhittin Kaya Dec 08 '21 at 14:03

score 5 · Answer 7 · edited May 29 '18 at 14:45

5

This appears to mostly happens when the MySQL username and password are not correct. Check your MySQL username and password.

edited May 29 '18 at 14:45

Sam

7,252
16
46
65

answered May 29 '18 at 13:17

Sarjita Konjengbam

51
1
2

Thanks for this. My issue had to do with an incorrect password. I was deploying an app to a Kubernetes cluster, and the password was encrypted in Kubernetes secrets. All I had to do was view the Kubernetes secret in the cluster, de-encrypt the password from base64 to json, which revealed the incorrect password, and then I corrected the password and deployed. This time it worked fine. – Promise Preston Jun 24 '23 at 17:11

score 2 · Answer 8 · edited Jun 03 '14 at 16:05

2

You should specify the db you are connecting to:

jdbc:mysql://localhost:3306/mydb

edited Jun 03 '14 at 16:05

vbence

20,084
9
69
118

answered Aug 12 '12 at 13:00

evg

1,308
1
7
12

score 1 · Answer 9 · edited Nov 06 '15 at 09:55

1

Try it like this....

public static Connection getConnection() throws SQLException{

    String driver = "com.mysql.jdbc.Driver";
    String url    = "jdbc:mysql://localhost:3306/test";
    String username = "root";
    String password = "vicky";            // Change it to your Password
    System.setProperty(driver,"");

    return DriverManager.getConnection(url,username,password);
}

edited Nov 06 '15 at 09:55

ROMANIA_engineer

54,432
29
203
199

answered Aug 12 '12 at 13:00

Kumar Vivek Mitra

33,294
6
48
75

4

Why exactly would it solve the concrete problem? You are not explaining the cause in any way. – BalusC Aug 12 '12 at 13:02

score 1 · Answer 10 · edited Jul 05 '13 at 11:39

1

I was hitting the same issue. Added mysql service port number(3307), resolved the issue.

conn = DriverManager.getConnection("jdbc:mysql://localhost:3307/?" + "user=root&password=password");

edited Jul 05 '13 at 11:39

Alexis Pigeon

7,423
11
39
44

answered Jul 05 '13 at 11:21

Satish Hunasikatti

11
1

score 1 · Answer 11 · answered Jun 21 '16 at 20:00

1

Although this may not be the cause of your issue, you'll get the same error if there are two MySQL services running on the same port. You can check on windows by looking at the list of services in the services tab of Task Manager.

answered Jun 21 '16 at 20:00

dave

9
3

1

This is a comment, not an answer. – Mad Physicist Jun 21 '16 at 20:22

Gani · Answer 12 · 2017-11-03T05:20:50.467

This Exception is also caused due to version mismatch of mysql db and your pom.xml/jar.

Make sure your pom.xml/jar version is higher than your mysql db version. Because higher versions are compatible with lower version's, but the same is not true for the inverse.

Solution's for java project

Replace the Jar with suitable version.

Solution for maven based

Change the dependency Version in pom.xml

Solution for spring boot - Override the spring boot dependency by adding 5.1.5.Final

score 1 · Answer 13 · answered Apr 16 '20 at 06:39

I am using Spring Boot 2.2.6(Windows) and faced the same issue when I tried the run the application: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

What solved my problem:

Create a new user (from the MySQL workbench or a similar GUI which you might be using)
Grant DBA priviledges (Tick the DBA checkbox) also from the GUI
Run the spring boot application.

Or follow the @evg solution to grant privilegdes from command line in Linux env.

I am using Spring Boot 2.6.2(Windows) and faced the same issue when I tried your solution but not able to resolve my issue: — Devendra Singraul, Jan 17 '22 at 13:20

score 1 · Answer 14 · edited Sep 09 '20 at 06:09

1

My application.properties looked something like this

spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/mydb

spring.datasource.username=root

spring.datasource.password=root

The only thing worked for me is to maven clean and then maven install.

edited Sep 09 '20 at 06:09

shreyasm-dev

2,711
5
16
34

answered Sep 08 '20 at 16:37

Anum Shaikh

11
1

score 1 · Answer 15 · answered Feb 13 '21 at 13:49

When I'm running a springboot project, the application.yml configuration is like this：

server:
  port: 8080
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/lof?serverTimezone=GMT
    username: root
    password: root
    driver-class-name: com.mysql.cj.jdbc.Driver

Notice that there isn't quotation marks around the password. And I can run this project in my windows System.

But when I try to deploy to the server, I have the problem and I fix it by changing the application.yml to:

server:
  port: 8080
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/lof?serverTimezone=GMT
    username: root
    password: "root"
    driver-class-name: com.mysql.cj.jdbc.Driver

score 1 · Answer 16 · edited Feb 14 '21 at 14:31

1

Add port number (something like 3306) in:

Connection c = DriverManager.getConnection("jdbc:mysql://localhost:urport","root","root");

edited Feb 14 '21 at 14:31

סטנלי גרונן

2,917
23
46
68

answered Feb 14 '21 at 13:38

Ashutosh Sharda

11
1

score 1 · Answer 17 · answered Jul 09 '22 at 08:10

In my case, I created a new user with name admin and used it...

CREATE USER 'admin'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost'
WITH GRANT OPTION;

CREATE USER 'admin'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%'
WITH GRANT OPTION;

score 0 · Answer 18 · answered Nov 16 '17 at 02:18

0

I had to change my SQL setup (in my host, Dreamhost in my case) to allow the username to access the database from other hosts, not just Dreamhost since I'm running a program from the IDE on my computer. I did that for now by adding % to the list of Allowable Hosts. It now works!

answered Nov 16 '17 at 02:18

Chris Appleby

1
2

I should add that this is similar to #munchkins approach but from the SQL control panel end. – Chris Appleby Nov 16 '17 at 02:32

score 0 · Answer 19 · answered Jun 02 '19 at 00:58

0

The order of declaring:

Driver
Connection string
username
password

If we declaring in order

Connection string
username
password
Driver

the application will fail

answered Jun 02 '19 at 00:58

Vy Do

46,709
59
215
313

score 0 · Answer 20 · answered Dec 30 '19 at 19:31

0

use correct jar (with correct version)
give root user host-independent access or create a user

answered Dec 30 '19 at 19:31

drdrej

904
8
14

score 0 · Answer 21 · answered Mar 13 '20 at 18:23

For me the solution worked as by changing the url format to: con=DriverManager.getConnection("jdbc:mysql://localhost/w3schools?user=###&password=###"); make sure to add proper jar to class path and use the driver Class.forName("com.mysql.jdbc.Driver");

score 0 · Answer 22 · edited Jun 04 '20 at 09:39

0

This resolved issue for me.

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'password';

GRANT ALL PRIVILEGES ON *.cfe TO 'root'@'%' IDENTIFIED BY 'password';

FLUSH PRIVILEGES;

edited Jun 04 '20 at 09:39

Matt Ke

3,599
12
30
49

answered Jun 04 '20 at 08:24

Deepesh Rajpal

71
1
1

Kinjal Akhani · Answer 23 · 2020-06-13T13:29:33.453

I was also facing the same issue, My connection string is valid and username and password also valid, even user has sufficient privileges to access database.

I solved this issue by deleting temporary folder created by MySQL(Please take backup before deleting any folders so in case if it not works then you can place that files again).

Default folder location for temp and connection files of MySQL in Windows is:

C:\ProgramData\MySQL

I deleted(taken backup) of below folder:

C:\ProgramData\MySQL\MySQL Server \Data\sys

Note: Before deleting any items make sure that MySQL service is not started or else it would not allow to delete any files

And It works for me.

score 0 · Answer 24 · edited Sep 05 '21 at 20:53

0

It's working fine for me while using same password after executing the following statement:

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';

edited Sep 05 '21 at 20:53

LW001

2,452
6
27
36

answered Sep 05 '21 at 12:02

Ajay Kumar

5
3

score 0 · Answer 25 · answered Dec 05 '21 at 13:20

spring.jpa.generate-ddl=true
spring.jpa.show-sql=true
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
spring.jpa.hibernate.ddl-auto=create-drop
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.username=root
spring.datasource.password=
spring.datasource.url=jdbc:mysql://localhost:3306/DATABASE_NAME? useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC

Go to your phpmyadmin database

Create a database called DATABASE_NAME and go to priviledges and check the users who have priviledges in the database and use them the default is "root"

score 0 · Answer 26 · answered Aug 04 '22 at 11:38

Due to below reason I created new user and password for mysql, now I am able to connect successfully. if your password is in encoded format please create new password

https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql#:~:text=There%20is%20a,mysql_native_password%20plugin%20instead%3A

There is a known issue with some versions of PHP that causes problems with caching_sha2_password. If you plan to use this database with a PHP application — phpMyAdmin, for example — you may want to create a user that will authenticate with the older, though still secure, mysql_native_password plugin instead:

score 0 · Answer 27 · edited Mar 29 '23 at 16:57

0

Solved! change localhost by 127.1.1.1 in your java code, with localhost not connect and throws this exception.

edited Mar 29 '23 at 16:57

helvete

2,455
13
33
37

answered Mar 26 '23 at 22:30

nokiajavi

21
3

score 0 · Answer 28 · answered Jul 11 '23 at 05:46

Sometimes MySQL server, while creating the user, sets the authentication type other than 'Standard'. The user I was using had the authentication type set to 'caching_sha_password'. Because of this, the connection was failing.

I created a new user via MySQL Workbench with all the privileges and set the authentication type to 'Standard', and the exception was gone.

score -1 · Answer 29 · edited Dec 18 '17 at 04:49

-1

I encountered this error. The problem was that I had the wrong database name.

edited Dec 18 '17 at 04:49

Robert Columbia

6,313
15
32
40

answered Dec 18 '17 at 03:42

nong thieu

1

score -1 · Answer 30 · answered Nov 18 '18 at 16:32

If you are connecting a remote mysql server from your local machine using java see the below steps. Error : "java.sql.SQLException: Access denied for user 'xxxxx'@'101.123.163.141' (using password: YES) "

for remote access may be cpanel or others grant the remote access for your local ip address.

In the above error message: "101.123.163.141" is my local machine ip. So First we have to give remote access in the Cpanel-> Remote MySQL®. Then run your application to connect.

Class.forName("com.mysql.jdbc.Driver");  
Connection con=DriverManager.getConnection(  
    "jdbc:mysql://www.xyz.com/abc","def","ghi");  
//here abc is database name, def is username and ghi        
Statement stmt=con.createStatement();  
ResultSet rs=stmt.executeQuery("select * from employee");  
    while(rs.next())  
        System.out.println(rs.getInt(1)+" "+rs.getString(2)+"  
                          "+rs.getString(3));  
con.close();

Hope it will resolve your issue.

Thanks

Blake7000 · Answer 31 · 2019-09-17T05:33:30.577

-1

I also have this problem, this solved it.

Change the:

Sring url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC&user=root&password=password";

Set:

"serverTimezone=UTC" is "Unified standard world time". "useUnicode=true&characterEncoding=UTF-8" is "Solve Chinese garbled".

Although my database have not any Chinese words. But it is working. Reference from https://www.cnblogs.com/EasonJim/p/6906713.html

edited Sep 17 '19 at 05:33

answered Sep 16 '19 at 07:23

Blake7000

1
2

Please format your code and do not deliver a link to an external page here if possible. Sum up everything directly into your post. Thanks. – kwoxer Sep 16 '19 at 07:42

score -1 · Answer 32 · edited Jan 03 '20 at 20:43

-1

If you are using a MySql workbench, go to the home page of workbench, right click on your database, copy the JDBC connection string, and paste it into the Java program.

edited Jan 03 '20 at 20:43

loadedion

2,217
19
41

answered Jan 03 '20 at 18:04

sree

51
1
3

score -2 · Answer 33 · edited Jul 07 '22 at 08:21

-2

be sure that the port you are using in:

spring.datasource.url=jdbc:mysql://localhost:8000/database

is the same that MySQL uses on your machine: check for it with this command in MySQL CLI:

SHOW VARIABLES WHERE Variable_name = 'port';

edited Jul 07 '22 at 08:21

Saeed Zhiany

2,051
9
30
41

answered Jul 06 '22 at 04:48

Nadjah KARA

1

1

The OP (from 10 years ago, I suspect they've moved on by now) shows `access denied` and not some sort of failed connection. So the port number is not likely the problem, since they must have been able to connect in order to have the credentials rejected. – Z4-tier Jul 07 '22 at 05:55
This does not provide an answer to the question. Once you have sufficient [reputation](https://stackoverflow.com/help/whats-reputation) you will be able to [comment on any post](https://stackoverflow.com/help/privileges/comment); instead, [provide answers that don't require clarification from the asker](https://meta.stackexchange.com/questions/214173/why-do-i-need-50-reputation-to-comment-what-can-i-do-instead). - [From Review](/review/late-answers/32182452) – Japhei Jul 09 '22 at 19:56

java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

33 Answers33

Linked

Related