MySQL Forums
Forum List  »  MySQL Workbench

Forward Engineer fails when creating user
Posted by: Graciano orrão
Date: October 23, 2019 08:23AM

I´m using server version: 8.0.17 MySQL Community Server - GPL and MySQL Workbench 8.0(Version 8.0.17 build 14960816 CE (64 bits) community).

After creating a model with a single table and a user "testUser" Workbenck shows the script:
"
...
CREATE USER 'testUser' IDENTIFIED BY '123';
GRANT ALL ON `exemploLigaBD`.* TO 'testUser';
...
"

This generates an error that i had not in the previous versions:
"
Executing SQL script in server
ERROR: Error 1410: You are not allowed to create a user with GRANT
SQL Code:
GRANT USAGE ON *.* TO testUser

SQL script execution finished: statements: 8 succeeded, 1 failed

Fetching back view definitions in final form.
Nothing to fetch
"

What do i need to configure?
Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Forward Engineer fails when creating user
841
October 23, 2019 08:23AM


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.