MySQL Forums
Forum List  »  Newbie

ERROR 1396 (HY000): Operation CREATE ROLE failed for 'application_rw'@'%'
Posted by: Elom Atsou Agboka
Date: May 18, 2023 06:06AM

Hello everybody.
I have a small problem in MySQL.
When I try to create a role with this syntax:

CREATE ROLE 'application_rw'@'%';
It does not work.

However, when I try with the following syntax:

CREATE ROLE 'application_rw'@'localhost';
that works.

I feel like when installing and configuring MySQL, I chose an option that restricted me to only placing commands at the localhost level.

How can I change this?

Options: ReplyQuote

Written By
ERROR 1396 (HY000): Operation CREATE ROLE failed for 'application_rw'@'%'
May 18, 2023 06:06AM

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.