I deleted the phpbb mySQL user lastnight by mistake, is there any way I can add a new user and make it work again without having to reinstall?!
Printable View
I deleted the phpbb mySQL user lastnight by mistake, is there any way I can add a new user and make it work again without having to reinstall?!
Howdy...
If you have a backed up copy of the database, then you can just restore the database with the back up. :)
I don't actually have one! I was gonna wait untill I installed everything that I needed to install then backup
Hi
Without actually knowing phpbb: if I understand you correctly,
you simply deleted the user "phpbb_account" (see reference),
but the database still is there?
Then the solution is simple:
1. recreate the user and grant the appropriate permissions to the phpbb_db database[1], ie
2. configure phpbb if you have changed the database owner name ("phpbb_account")Code:mysql> use phpbb_db;
Database changed
mysql> GRANT ALL PRIVILEGES ON phpbb_db.* to phpbb_account@localhost
-> IDENTIFIED BY 'this_password';
or its password during this process[2]
Cheers
[1] http://www.hypexr.org/phpbb.php#mysqlsetup
[2] http://www.hypexr.org/phpbb.php#phpbbsetup
Well then a valuable lesson learnt then, you should always make a backup prior to doing any type of modifications etc, that way if things go bump in the night, you have something to revert back to. ;)Quote:
Originally posted here by Livlee
I don't actually have one! I was gonna wait untill I installed everything that I needed to install then backup
<edit>
Go with what sec_ware posted it looks about right. ;)
</edit>
f2B