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, 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.