How to fix SQLSTATE[HY000] [10 45] Access denied for user ''@'localhost' (using password: NO)?

Question

MySQL

I'm trying to connect to the database via phinx for migration, I get the error
SQLSTATE[HY000] [10
45] Access denied for user ''@'localhost' (using password: NO)
everything is written in the configs, mysql -u -p works. What could be the problem?

Answer 1

The reason is trite that you did not configure phinx without setting the data for connecting to the database.
https://book.cakephp.org/phinx/0/en/configuration.html

mysql -u -p works

Because there socket authentication is used for root.