Answer the question
In order to leave comments, you need to log in
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 questionAsk a Question
731 491 924 answers to any question