By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
439,993 Members | 1,984 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 439,993 IT Pros & Developers. It's quick & easy.

No Grant privileges

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.