Deleted mySQL user!!

[Livlee]

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?!

[.:front2back:.]

Howdy...

If you have a backed up copy of the database, then you can just restore the database with the back up.

[Livlee]

I don't actually have one! I was gonna wait untill I installed everything that I needed to install then backup

[sec_ware]

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

mysql> use phpbb_db;
Database changed
mysql> GRANT ALL PRIVILEGES ON phpbb_db.* to phpbb_account@localhost
    -> IDENTIFIED BY 'this_password';

2. configure phpbb if you have changed the database owner name ("phpbb_account")
or its password during this process[2]

Cheers

[1] http://www.hypexr.org/phpbb.php#mysqlsetup
[2] http://www.hypexr.org/phpbb.php#phpbbsetup

[.:front2back:.]

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

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.

<edit>
Go with what sec_ware posted it looks about right.
</edit>


f2B