Results 1 to 4 of 4

Thread: mysql problem

  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Unanswered: mysql problem

    I was trying to install something and now i got locked out of mysql... i ran these commands

    i was supposed to do
    GRANT USAGE ON webdatabase.* TO 'nobody'@'localhost' IDENTIFIED BY PASSWORD 'nopasswd';

    i put
    GRANT USAGE ON webdatabase.* TO root'@'localhost' IDENTIFIED BY PASSWORD 'mypass';

    then realized i did it wrong, so i put the
    GRANT USAGE ON webdatabase.* TO 'nobody'@'localhost' IDENTIFIED BY PASSWORD 'nopasswd';

    thats all i did

    now it wont let me log onto mysql.... gives me access denied.... is there any way i can get back in or do i have to reinstall now? and if i have to reinstall. whats the best way of getting all traces of old mysql out and put new mysql in... please help.. thanks (this is on linux btw mandrake distro)

  2. #2
    Join Date
    Oct 2003
    Posts
    3
    You can try installing Phpmyadmin and if it gives you access, you can fix it from phpMyAdmin

  3. #3
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: mysql problem

    Originally posted by pun84
    I was trying to install something and now i got locked out of mysql... i ran these commands

    i was supposed to do
    GRANT USAGE ON webdatabase.* TO 'nobody'@'localhost' IDENTIFIED BY PASSWORD 'nopasswd';

    i put
    GRANT USAGE ON webdatabase.* TO root'@'localhost' IDENTIFIED BY PASSWORD 'mypass';

    then realized i did it wrong, so i put the
    GRANT USAGE ON webdatabase.* TO 'nobody'@'localhost' IDENTIFIED BY PASSWORD 'nopasswd';

    thats all i did

    now it wont let me log onto mysql.... gives me access denied.... is there any way i can get back in or do i have to reinstall now? and if i have to reinstall. whats the best way of getting all traces of old mysql out and put new mysql in... please help.. thanks (this is on linux btw mandrake distro)
    Are you connecting from the localhost or another machine?

  4. #4
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    Why are you using
    GRANT USAGE ON webdatabase.* TO 'nobody'@'localhost' IDENTIFIED BY PASSWORD 'nopasswd';

    Instead of

    GRANT USAGE ON webdatabase.* TO nobody@'localhost' IDENTIFIED BY PASSWORD 'nopasswd';
    or
    GRANT USAGE ON webdatabase.* TO nobody@localhost IDENTIFIED BY PASSWORD 'nopasswd';

    and did you use flush privileges ?
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •