In my Ubuntu VM, I kept getting
SQLSTATE[HY000] [1045] Access denied for user 'username'@'localhost' (using password: YES)
update
I have configured my database like this in my .env file
DB_HOST=45.55.88.57
DB_DATABASE=b-prod
DB_USERNAME=root
DB_PASSWORD=*********
UNIX_SOCKET=/var/run/mysqld/mysqld.sock
It works perfectly.
But when I use
DB_HOST=45.55.88.57
DB_DATABASE=b-prod
DB_USERNAME=b <----------------------------------------------
DB_PASSWORD=*********
UNIX_SOCKET=/var/run/mysqld/mysqld.sock
I didn't work.
What else I should look into to prevent this ?
I have a feeling that I have the wrong password.
How do I test my database password ? DB_PASSWORD=********* ?
This is all user I have
mysql> SELECT User,Host FROM mysql.user;
+------------------+-------------+
| User | Host |
+------------------+-------------+
| root | % |
| root | 127.0.0.1 |
| root | 45.55.88.57 |
| root | ::1 |
| root | b |
| b | localhost |
| debian-sys-maint | localhost |
| root | localhost |
+------------------+-------------+
8 rows in set (0.00 sec)
via ihue
