MySQL Forums
Forum List  »  Security

GRANT Causing MYSQL Disconnect
Posted by: Ed Lafferty
Date: June 27, 2007 10:22AM

I need to assign privileges to a certain user on a per table basis. Before I knew this I assigned privs at the DB level:

grant all privileges on wprofile.* TO 'wuser'@'%';

This worked fine. I found out I needed to use table level privs so I revoked all and attempted to

grant SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER ON TABLE wprofile.biography TO 'wuser'@'%';

This causes me to lose connection to the MYSQL DB:

ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 8
Current database: wprofile

ERROR 2013 (HY000): Lost connection to MySQL server during query

If I run the DB level grant command immediately after getting disconnected (I never exited mysql, BTW) it works fine.

I get the same disconnect error if I only try to grant SELECT priv.

Am I doing something wrong? I am running MySQL 5.0.27. Thanks in advance for any help anyone can give.

Ed

Options: ReplyQuote


Subject
Views
Written By
Posted
GRANT Causing MYSQL Disconnect
5400
June 27, 2007 10:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.