Mysql default security: Access denied for user 'freepbxuser'@'localhost'

[AndreL]

I got this error:
SQLSTATE[HY000] [1045] Access denied for user ‘freepbxuser’@‘localhost’ (using password: YES)::SQLSTATE[HY000] [1045] Access denied for user ‘freepbxuser’@‘localhost’ (using password: YES)

How to restore default Mysql security ?

thanks.

[cynjut (Dave Burgess)]

From the database machine, connect as ‘root’ without a password.

[AndreL]

yes indeed.
I still have the right password but apparently the “Grant” were not ok anymore.
Temporary I just allowed everything for freepbxuser to all dbs.

is that the right access security config ?

[cynjut (Dave Burgess)]

You should be a little more selective with the Asterisk user, but since you are working strictly from localhost, it’s probably fine.