469,287 Members | 2,503 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 17 '05 #1
3 2504
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
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
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.

Similar topics

12 posts views Thread by | last post: by
3 posts views Thread by Bruce A. Julseth | last post: by
4 posts views Thread by Amardeep Verma | last post: by
reply views Thread by Charles Cantrell | last post: by
reply views Thread by Charles Cantrell | last post: by
6 posts views Thread by maxwell | last post: by
6 posts views Thread by Xerxes | last post: by
reply views Thread by Marc | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.