Home/ Questions/How to fix: java.sql.sqlexception: access denied for user 'root'@'localhost' (using password: yes)?
Next
Answered
Jaclyn Bogan
  • 3
Asked: 2022-07-12T08:45:53+00:00 In:

How to fix: java.sql.sqlexception: access denied for user ‘root’@’localhost’ (using password: yes)?

  • 3

. Advertisement .

..3..

. Advertisement .

..4..

I got the following error while running my program:

java.sql.sqlexception: access denied for user ‘root’@’localhost’ (using password: yes)

If anyone knows how to fix it, please let me know. Thanks in advance.

Share

1 Answer

  1. Best Answer
    Expert

    The cause: The error java.sql.sqlexception: access denied for user ‘root’@’localhost’ (using password: yes) indicates that you entered the incorrect root password, which is why your database connection ended in failure.

    Solution: You can use this:

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

    Use the command line or a GUI tool to carry it out. Replace %password% with the actual password. When building a database from scratch, you might use:

    Connection connection = DriverManager.getConnection(jdbc:mysql://localhost/?user=root&password=rootpassword);
PreparedStatement ps = connection.prepareStatement(CREATE DATABASE databasename);
int result = ps.executeUpdate();

    Follow the order of the example below:

    sudo mysql_secure_installation

sudo mysql

    Once you’ve logged in to MySQL, run the following instructions from the MySQL prompt:

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

    Check now to see if the root password is stored in the table.

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

    That can solve the problem.

    • 1

Leave an answer

You must login to add an answer.

Need An Account,