However, now I am receiving a permission denied error when I try to do anything database-related from the Forge control panel. For example, if I try to add another user, or change the password, the output of the command is ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES).
Did changing the password manually cause this? Does Forge store their own copy of the password somewhere, and since it has changed, the access denied error occurs? How can I resynchronize these passwords so that the control panel functions as intended?
Laravel Forge stores your root database password as well. Note that it's stored encrypted, but it uses that password to perform actions on the database. Laravel Forge needs to know that password to perform actions as that root user.
Laravel Forge also offers the functionally the change the root password of some database. If you go to the database tab it's at the bottom! This can be done per server. This way you won't have any conflicts. So you might try changing it there as well?
If all above fails just email the support of Laravel Forge, they can help you out ;)
@BOBBYBOUWMANN - Thanks. I'm aware you can change the password from the control panel in Forge. That's the issue though. Even the change password functionality doesn't work. They must use the existing password to login and set the new one, but they don't know the correct current password, so it's not working.
When I used that form, it changed password for non-root DB user (so, my production app stopped working). Still need a way to find/reset my database root password…
