Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Location
    Canada
    Posts
    1

    Unanswered: Restoring Permission

    I was playing with the users table in mysql database. Not sure what I did, but now, I cant see any of my databases in there when I log in with Root user. I know I have not deleted them, and they still exist in my computer, but I guess I do not have permission to view them.

    From command prompt, when I go to >mysql and try to add a user by:

    mysql> grant all privileges on *.* to abc@localhost identified by 'abc';
    ERROR 1045: Access denied for user: '@localhost' (Using password: NO)


    Looks like I do not have access enough to do that. Can someone please write me, how to go about getting my permissions back?

    Thanks a lot!

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

    Re: Restoring Permission

    Originally posted by Eal
    I was playing with the users table in mysql database. Not sure what I did, but now, I cant see any of my databases in there when I log in with Root user. I know I have not deleted them, and they still exist in my computer, but I guess I do not have permission to view them.

    From command prompt, when I go to >mysql and try to add a user by:

    mysql> grant all privileges on *.* to abc@localhost identified by 'abc';
    ERROR 1045: Access denied for user: '@localhost' (Using password: NO)


    Looks like I do not have access enough to do that. Can someone please write me, how to go about getting my permissions back?

    Thanks a lot!
    Look at: " identified by 'abc';" and "Using password: NO"

    It seems you try connect without password.

Posting Permissions

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