MySQL Forums
Forum List  »  Database Administration & Monitoring

Advanced Search
New Topic

Re: Giving SUPER Privileges to remote user
Posted by: Peter Brawley
Date: January 10, 2020 10:09AM

> You are not allowed to create a user with GRANT

MySQL version? Grant/Create User rules changed in 5.7, again in 8.0, and that will continue eg SUPER is already deprecated, is being replaced by dynamic privileges.

Why do you need LOCAL in Load Data Infile? Would FILE priv and an appropriate setting of secure_file_priv do?

https://dev.mysql.com/doc/refman/8.0/en/load-data.html

https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Giving SUPER Privileges to remote user
Samet Şahin
January 10, 2020 01:12AM
Re: Giving SUPER Privileges to remote user
Peter Brawley
January 10, 2020 10:09AM


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.