vierge-noire / cakephp-test-suite-light

A fast test suite for CakePHP applications
MIT License
13 stars 7 forks source link

error: execute command denied to user #71

Open tyler36 opened 1 month ago

tyler36 commented 1 month ago

I'm new to CakePHP so there is a chance I'm doing something wrong, but I get the following error when I try and and use TruncateDirtyTables;

RuntimeException: SQLSTATE[42000]: Syntax error or access violation: 1370 execute command denied to user 'db'@'%' for routine 'test.TruncateDirtyTables'

My setup includes my "normal" database (db) and a test database. I have configured my .env with the following:

export DATABASE_URL="mysql://db:db@db:3306/db"
export DATABASE_TEST_URL="mysql://db:db@db:3306/test"

If I change my DATABASE_TEST_URL to DATABASE_URL, the error disappears.