469,287 Members | 2,600 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,287 developers. It's quick & easy.

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
Jul 19 '05 #1
0 1848

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

12 posts views Thread by | last post: by
3 posts views Thread by Marc | last post: by
reply views Thread by Charles Cantrell | last post: by
reply views Thread by Charles Cantrell | last post: by
reply views Thread by Marc | last post: by
8 posts views Thread by binary-nomad | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.