MySQL Forums
Forum List  »  MySQL Workbench

Error Code: 1410. You are not allowed to create a user with GRANT.
Posted by: T Kapp
Date: April 24, 2024 09:39AM

Hello,
When using GRANT to limit a user "wouserone" to Select column privileges on "workordernumber"in my table "tbworkorders"

I.E.
[Grant Select (workordernumber) on dbworkorders.tbworkorders to 'wouserone'@'192.168.1.4';]

I get the following error.

Error Code: 1410. You are not allowed to create a user with GRANT.

I'm logged in as Root with full privileges and wouserone was created days ago.

All thoughts and ideas would be greatly appreciated,
Thank you

Options: ReplyQuote


Subject
Views
Written By
Posted
Error Code: 1410. You are not allowed to create a user with GRANT.
529
April 24, 2024 09:39AM


Sorry, only registered users may post in this forum.

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.