Not the answer you need?
Register and ask your own question!

mysql request

elm273elm273 Current User Role Beginner
When creating the tables that have a foreign key, I get a privilege error,
I have added a couple of privileges but nothing
and I can't continue with the practice

Answers

  • vaibhav_upadhyay40vaibhav_upadhyay40 Contributor Current User Role Patron
    Please share the error.
    Please check the privileges of the user. login with user which has super privilege and grant necessary privileges to perform the operation.
    how to check user grant?
    mysql> show grants for [email protected]'ip/host';
    or login to mysql with the user you are getting above error and fire below command
    mysql> show grants; 

    Hope this helps.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.