Access Denied Error When Running PHP Artisan Migrate in AWS RDS

0

I am writing to seek assistance regarding an issue I am encountering while trying to run the "php artisan migrate" command in my AWS environment.

I am relatively new to AWS and have set up an RDS instance with an admin master user. However, when attempting to execute the "php artisan migrate" command, I am encountering the following error message: SQLSTATE[42000]: Syntax error or access violation: 1227 Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN, or SESSION_VARIABLES_ADMIN privilege(s) for this operation (SQL: SET SESSION sql_require_primary_key=0)

Could you please provide guidance on how I can address this issue? I would greatly appreciate your assistance in identifying the appropriate privileges to grant to my admin user in order to successfully execute the "php artisan migrate" command. Additionally, any insights on best practices or security considerations related to granting such privileges would be highly valuable.

mosala
asked 8 months ago62 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions