MySQL Forums
Forum List  »  Newbie

ERROR #1227 - access denied;
Posted by: John carey
Date: June 19, 2022 09:01PM

error #1227 - access denied;
I get this error message. not sure why. I'm using phpmyadmin, version:mysql5.7
-------------
SQL CODE:

select * from 'employees';
create user 'nancy'@'%' identified by '123456';
grant select on dbs6125067.employees to 'nancy'@'%';
show grants;
-------------
ERROR
sql query:
create user 'nancy'@'%' identified by '123456'

MYSQL Said:
#1227 - access denied; you need(at least one of) the
create user privilege(s) for this operation
-------------
URL: my.ionos.com/webhosting/

Options: ReplyQuote


Subject
Written By
Posted
ERROR #1227 - access denied;
June 19, 2022 09:01PM


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.