Deleted mySQL user!!
Results 1 to 5 of 5

Thread: Deleted mySQL user!!

  1. #1
    Banned
    Join Date
    Sep 2001
    Posts
    43

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

  2. #2
    Howdy...

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

  3. #3
    Banned
    Join Date
    Sep 2001
    Posts
    43
    I don't actually have one! I was gonna wait untill I installed everything that I needed to install then backup

  4. #4
    Senior Member
    Join Date
    Mar 2004
    Posts
    557
    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)

  5. #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
  •  

 Security News

     Patches

       Security Trends

         How-To

           Buying Guides