Access denied for user 'freepbxuser'@'localhost'

[Mikipalma2 (España)]

Hello. I have a problem accessing the freepbx web admin. I was without a firewall and something happened, I found a capacity failure, then a database failure, without a mariadb connection. I reinstalled, but now I find that I can’t access it.

I tried to do the following:
update user set password = password(‘thepasswordyouwanttouse’) where user = ‘freepbxuser’;

But it doesn’t work, I still have the problem:
SQLSTATE[HY000] [1045] Access denied for user ‘freepbxuser’@‘localhost’ (using password: YES)::SQLSTATE[HY000] [1045] Access denied for user ‘freepbxuser’@‘localhost’ (using password: YES)

Can you help me, please?
Thanks.

[comtech]

Freepbxuser access denied

From the database server, you can do any commands you want as the ‘root’ database user (which shouldn’t have a password, but must be accessed from localhost). Connect to the database server as ‘root’ and log into the UI for MySQL: mysql -u root mysql Once logged in, use a command like: update user set password = password('thepasswordyouwanttouse') where user = 'freepbxuser'; The password is probably stored in one of the config files (I’m not sure which and my test machine is hosed right no…