G
G
greatazazan2021-07-09 13:22:07
MySQL
greatazazan, 2021-07-09 13:22:07

Authorization to the database at 127.0.0.1 as root gives an access error. How to fix?

Greetings. Faced the following problem: the application is trying to connect to a database running on the computer (Win 10, after the problem I tried even on a VM with Win 7), but cannot access, gives an error:

Authentication to host '127.0.0.1' for user ' root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'localhost' (using password: YES)

Used different versions of MySQL and MariaDB, didn't help. Firewall turned off. There's not much in the MySQL logs, just this:
2021-07-09T10:21:29.942249Z 63 Connect [email protected] on cicadadb using TCP/IP
2021-07-09T10:21:29.942613Z 63 Connect Access denied for user 'root' @'localhost' (using password: YES)

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question