GRANT Causing MYSQL Disconnect
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
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.