No Grant Privileges

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Marc
    #1

    No Grant Privileges

    Hello,
    I have 3 users in my MySQL server. One of them has Grant access
    (actually: all privileges). I cannot login as this user using
    phpMyAdmin - my password is not accepted (though I' m sure it must be
    the right one).

    I CAN login as any of the other users. When I do this and choose
    'privileges' I get the overview:
    User - Host - Password - Global Privileges - Grant - Action
    I can see the user with all privileges, but the cell under 'Host' is
    empty. Does this mean this user cannot login from any host?

    Since I am now logged in as a limited user, having no Grant
    privileges, I can't change this...

    As far as I understand, I have locked myself out of the server and
    don't know how to get in...

    Is there any way I can get back in?

    Thanks,

    Marc
    Tags: None
    • Andy Hassall
      #2
      Re: No Grant Privileges

      On 3 Jan 2004 07:21:54 -0800, meelzooi2000@ya hoo.com (Marc) wrote:
      [color=blue]
      >I have 3 users in my MySQL server. One of them has Grant access
      >(actually: all privileges). I cannot login as this user using
      >phpMyAdmin - my password is not accepted (though I' m sure it must be
      >the right one).
      >
      >I CAN login as any of the other users. When I do this and choose
      >'privileges' I get the overview:
      > User - Host - Password - Global Privileges - Grant - Action
      >I can see the user with all privileges, but the cell under 'Host' is
      >empty. Does this mean this user cannot login from any host?
      >
      >Since I am now logged in as a limited user, having no Grant
      >privileges, I can't change this...
      >
      >As far as I understand, I have locked myself out of the server and
      >don't know how to get in...
      >
      >Is there any way I can get back in?[/color]

      Log in as the root user and alter the passwords?

      --
      Andy Hassall (andy@andyh.co. uk) icq(5747695) (http://www.andyh.co.uk)
      Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)

        Comment

        • Marc
          #3
          Re: No Grant Privileges

          Hi,
          I can log in as root but then I don't have the 'Privileges' link I
          would have when log in as one of the other users. It says 'No
          Privileges'.

            Comment

            • Ian.H
              #4
              Re: No Grant Privileges

              On Sun, 04 Jan 2004 02:28:52 -0800, Marc wrote:
              [color=blue]
              > Hi,
              > I can log in as root but then I don't have the 'Privileges' link I would
              > have when log in as one of the other users. It says 'No Privileges'.[/color]


              Great! 8)



              Regards,

              Ian

              --
              Ian.H [Design & Development]
              digiServ Network - Web solutions
              www.digiserv.net | irc.digiserv.ne t | forum.digiserv. net
              Programming, Web design, development & hosting.

                Comment

                Previous template Next
                Working...