tip: mysql rejecting access

problem: mysql rejects access no matter what you do

solution, I think:
shut down mysql

run /usr/bin/safe_mysqld --skip-grant-tables
mysql -u root --host=localhost mysql
UPDATE user SET Password=PASSWORD('mynewpassword') WHERE User='root';
after that
GRANT ALL ON *.* TO user@localhost IDENTIFIED BY "";

seemed to work.
I think it was the host field

Share

One thought on “tip: mysql rejecting access”

  1. I tried to e-mail this to you but it got returned.

    A selection of Sons of Sam Horn reactions to tonight's loss:

    "Worst ending ever."

    "FUCK
    FUCK

    FUCK

    FUCK

    FUCK
    FUCK
    FUCK
    FUCK"

    "OH MY FUCKING GOD... I AM JUMPING."

    "FUCK YOU LYON.

    FUCK YOU GRADY."
    (Editor's Note: I don't see how this is Grady's fault.)

    "FUUUUUUUUUUUUUUUUUUUUUUUUUUUUCK

    ASS SHITS"
    (Editor's Note: My personal favorite.)

    "Well that's just a load of ass."

    "Ladies and Gentlemen! Your 2003 Boston Red Sox! Finding new and never before seen ways to lose ballgames on a regular basis!"

Comments are closed.