I am trying to learn and launch my own wordpress server. I was in the process of creating MYSQL database and created a database user, assigned the privileges to that account, set password and still cannot log in with it. I have tried to login through both phpmyadmin and CLI. I am trying to login through localhost, i am not allowing any remote connections as everything is run on my server.
the error i get is:
ERROR 1045 (28000): Access denied for user 'bsadmin'@'localhost' (using password: YES)
+------------------+-----------+
| user | host |
+------------------+-----------+
| bsadmin | % |
| bsadmin | localhost |
| debian-sys-maint | localhost |
| mysql.sys | localhost |
| phpmyadmin | localhost |
| root | localhost |
+------------------+-----------+
+--------------------------------------------------------------------------------+
| Grants for bsadmin@localhost |
+--------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'bsadmin'@'localhost' WITH GRANT OPTION |
| GRANT ALL PRIVILEGES ON `brdgsol`.* TO 'bsadmin'@'localhost' WITH GRANT OPTION |
| GRANT PROXY ON ''@'' TO 'bsadmin'@'localhost' WITH GRANT OPTION |
+--------------------------------------------------------------------------------+
I have flushed privs as well. I read the article similar to this but it does not state or atleast i do not see how it states that the account can login through localhost. It states about logging in from socket and network. Please help.