By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,180 Members | 1,051 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,180 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 17 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On 3 Jan 2004 07:21:54 -0800, me**********@yahoo.com (Marc) wrote:
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?


Log in as the root user and alter the passwords?

--
Andy Hassall (an**@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)
Jul 17 '05 #2

P: n/a
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'.
Jul 17 '05 #3

P: n/a
On Sun, 04 Jan 2004 02:28:52 -0800, Marc wrote:
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'.

Great! 8)

Regards,

Ian

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

Jul 17 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.