Flarum not opening

DagdiHiman

Hello,
I have installed Flarum on my localhost using xampp and it was working fine. But after I restarted my PC and tried opening Flarum again and was getting this error:-
Flarum encountered a boot error (Doctrine\DBAL\Driver\PDOException)
SQLSTATE[HY000] [1044] Access denied for user 'flarumowner'@'localhost' to database 'flarum'
thrown in C:\xampp\htdocs\flarum\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php on line 31

I tried reinstalling Flarum and again it was working fine for the first time but when I try to open it the second time it shows me the same error again.

So Please anyone help me fox this out.
Thanks 😀

clarkwinkelmann

DagdiHiman it looks like the database password or database name is invalid, or the database user doesn't have permission to access the database. So it must be an issue with the setup and not Flarum.

Maybe your database is setup in a kind of temporary manner ? Temporary password on the user ? Maybe that's an in-memory database instead of on-disk ?

What happens if you restart MySQL ? Does the error change ?

Did you have to delete and create the database again for it to work or just reinstalling Flarum but not the database/user worked again ?

DagdiHiman

clarkwinkelmann
1) If I restart MySQL the error remains the same. No change.
2) ->Yeah, I have to delete the database and the users (i.e., flarumowner) using PHPMyAdmin.
-> And also, I have to reinstall Flarum.
-> Both the things when done then I should setup my Flarum forum again from starting. Whatever Changes I made are lost.

And, Thanks for the quick reply. 😄

clarkwinkelmann

DagdiHiman that's an odd situation.

Have you installed other webapps on your xampp setup (Wordpress for example) ? Does database access work for them ?

DagdiHiman

luceos clarkwinkelmann
I have only xampp installed on my PC. And I tried what Luceos said, but that also didn't work out. Still, I was facing the same error.
Then I reinstalled xampp and Flarum both from the beginning and now the problem has been Solved.

Thanks 😄

luceos

Try using 127.0.0.1 as host instead of localhost in your config.php. Sometimes your database is no longer available through socket.