1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Need help with XAMPP error!

Discussion in 'PHP' started by omgitsfletch, Sep 21, 2007.

  1. #1
    Ok guys,

    I screwed up my XAMPP install by accidentally deleting the pma user from the mysql.users table, so phpMyAdmin doesn't work now. Anyone that can give me the INSERT query to rebuild this user so phpMyAdmin will work again? I would do it myself but I don't know what the proper settings for it should be.
    SEMrush
     
    omgitsfletch, Sep 21, 2007 IP
    guerilla and Briant like this.
    SEMrush
  2. krt

    krt Well-Known Member

    Messages:
    829
    Likes Received:
    38
    Best Answers:
    0
    Trophy Points:
    120
    #2
    Assuming you want full privileges:
    -- mysql.user table
    INSERT INTO `user` VALUES ('localhost', 'pma', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0, 0);
    Code (markup):
     
    krt, Sep 21, 2007 IP
  3. omgitsfletch

    omgitsfletch Well-Known Member

    Messages:
    1,222
    Likes Received:
    44
    Best Answers:
    0
    Trophy Points:
    145
    #3
    Argh, I inserted it back into the database, but still get this error when I try to log in to phpMyAdmin. Why is it not working when I put the damned password back. Is it possible that pma had a default password, which is what phpMyAdmin is trying to login with?

    #1045 - Access denied for user 'pma'@'localhost' (using password: NO)
     
    omgitsfletch, Sep 22, 2007 IP
    Briant likes this.
  4. krt

    krt Well-Known Member

    Messages:
    829
    Likes Received:
    38
    Best Answers:
    0
    Trophy Points:
    120
    #4
    You can check the config.inc.php in the phpMyAdmin directory to check but the error message mentions a password is not being used.
     
    krt, Sep 22, 2007 IP
  5. myharshdesigner

    myharshdesigner Peon

    Messages:
    147
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    what is pma stands for root ?

    if not then you can able to login with root take your full database backup and reinstall xampp after that import that backup it's Done.

    simple :)
     
    myharshdesigner, Sep 22, 2007 IP
  6. omgitsfletch

    omgitsfletch Well-Known Member

    Messages:
    1,222
    Likes Received:
    44
    Best Answers:
    0
    Trophy Points:
    145
    #6
    Yea I realize a password is not being used. I'm asking for someone who has experience with XAMPP: if the PMA user needs a default password that phpMyAdmin uses to login, what is it?
     
    omgitsfletch, Sep 23, 2007 IP
    Briant likes this.
  7. omgitsfletch

    omgitsfletch Well-Known Member

    Messages:
    1,222
    Likes Received:
    44
    Best Answers:
    0
    Trophy Points:
    145
    #7
    I've also tried using XAMPP's IRC channel, but it's so dead I got no response.

    I just need to know what default password XAMPP uses for PMA
     
    omgitsfletch, Sep 24, 2007 IP
    Briant likes this.