-
May 31st, 2006, 12:21 PM
#1
Banned
Deleted mySQL user!!
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?!
-
May 31st, 2006, 12:38 PM
#2
Howdy...
If you have a backed up copy of the database, then you can just restore the database with the back up.
-
May 31st, 2006, 12:39 PM
#3
Banned
I don't actually have one! I was gonna wait untill I installed everything that I needed to install then backup
-
May 31st, 2006, 12:44 PM
#4
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
Code:
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
If the only tool you have is a hammer, you tend to see every problem as a nail.
(Abraham Maslow, Psychologist, 1908-70)
-
May 31st, 2006, 12:45 PM
#5
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|