When I try to run migrations on App Platform during deploy,
php artisan migrate --force, I get the following error even though I granted for db_user: SELECT, GRANT OPTIONS on information_schema, and GRANT ALL on my_schema_name.
In Connection.php line 712: SQLSTATE[HY000]  Access denied for user ‘db_user’@‘IP_ADDRESS’ (using password: YES) (SQL: select * from information_schema.tables where table_schema = my_schema_name and table_name = migrations and table_type = ‘BASE TABLE’)
In Connector.php line 70:
SQLSTATE[HY000]  Access denied for user ‘db_user’@‘IP_ADDRESS’ (using password: YES)
Do you have any idea how to resolve this problem?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.