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
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 username@‘ip/host’;
or login to mysql with the user you are getting above error and fire below command
mysql> show grants;
Hope this helps.