Can't edit "root" user after creating password

  • Resolved adhdcelt

    (@adhdcelt)


    14 years, 3 months ago

    I’m building a wordpress site using WAMP localhost setup on XP NTFS home system.
    Site and database working fine until:
    I backup the database from phpmyadmin using Export.
    I go into phpmyadmin and finally create a password for “root” user.
    I look in the site wp-config.php to make sure the user is “root,” then…
    I delete users “Any” and “127.0.0.1 in phymyadmin and keep the “root” user.
    I go to the “Edit” window for the root user.
    While in there, under Global privileges/Structure, somehow—DUH—I manage to uncheck “Create” and click Go before I catch it.
    Well, I realize what I’ve done, go back to “Edit,” recheck “Create,” and click Go.
    Now, I get this big ole honkin’ error:

    =========================
    Error
    SQL query: Edit
    GRANT ALL PRIVILEGES ON * . * TO ‘root’@’localhost’ WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

    MySQL said: Documentation
    #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
    ==========================

    YIKES!
    For the record:
    Site wp-config.php and WAMP config.inc.php password parameter is set to the password I entered in phymyadmin user edit window.

    WAMP config.inc.php also reads: $cfg[‘Servers’][$i][‘AllowNoPassword’] = false;

    How can I get back to having the “Create” box under Structure in the user window set and saved and make sure this new password thing works?

    I took this to God first, but it’s way over His head, too.
    He ain’t much on mysql and told me to come to you folks.
    Any help here is greatly appreciated.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter adhdcelt

    (@adhdcelt)

    Problem solved.
    Like to have never found it.

    For anyone else to whom this may have happened:
    Went into the mysql database for my site through phpmyadmin.
    Opened the “user” table.
    Clicked on the “Edit” icon for user “root”.
    There it was: Radio button for “Create_priv” set to NO.
    Clicked on YES radio button.
    Clicked GO

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    Generally I would suggest you NOT use ‘root’ for anything like this. I would make a separate SQL user ID just for this, but … it’s a local install, and I don’t know jack about that on Windows.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Can't edit "root" user after creating password’ is closed to new replies.