Mysql2::Error::ConnectionError: Access denied for user 'root'@'localhost' (using password: NO)
Hello, I have problems with my connection to mysql and rails, when I access mysql through the terminal with the root user I have no problem, but when I do a db: create rails but I get the error that is in the title.
If you are using Homebrew and Mac for the MySQL installation, try this : https://stackoverflow.com/a/44147346
Try this on your database.yml:
default: &default
adapter: mysql2
username: root
password:
socket: /tmp/mysql.sock
Mysql usually come with auth_socket as default authentication plugin, if you want to use authentication by password, you must change the user's authentication plugin to caching_sha2_password.
You can try to run this on MySQL terminal:
mysql> CREATE USER ‘username’@‘localhost’ IDENTIFIED BY ‘password’;
mysql> GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';
mysql> FLUSH PRIVILEGES;
Then you should be good to go.
