Access denied for user'root' @'localhost' (using password: YES) and gave up

Overview

It is a story that I was addicted to trying to develop by migrating from H2DB to local MySQL. image.png

environment

error contents

My password is angry at me lol

image.png

What i did

Reset password in WorkBench

It was bad. ..

Rebuild MySQL server

It was bad. ..

Erase the password setting

It's done. .. .. .. !!

image.png

Conclusion

For the time being, the default password is not set, so you should access without entering the password at first. If you can access it, you should set a password! !!

Recommended Posts

Access denied for user'root' @'localhost' (using password: YES) and gave up
Mysql2 :: Error :: ConnectionError: Access denied for user'root' @'localhost' (using password: YES)
Access denied for user'root' @'localhost' (using password: NO) Corrective action for error
Building a Docker environment on EC2 (ArgumentError: Missing `secret_key_base`, Mysql2 :: Error :: ConnectionError: Access denied for user'root'@ '172.18.0.4' (using password: NO) solution)
Password hashing and authentication using JBcrypt