maniruzzamanakash / laravel-role Goto Github PK

After Installing I am getting this error.
I refreshed the page and tried again and again but did not work.

Illuminate\Database\QueryException

SQLSTATE[42000]: Syntax error or access violation: 1142 REFERENCES command denied to user 'test'@'localhost' for table 'test.permissions' (SQL: alter table model_has_permissions add constraint model_has_permissions_permission_id_foreign foreign key (permission_id) references permissions (id) on delete cascade)

at vendor/laravel/framework/src/Illuminate/Database/Connection.php:671
667| // If an exception occurs when attempting to run a query, we'll format the error
668| // message to include the bindings with SQL, which will make this exception a
669| // lot more helpful to the developer instead of just the database's errors.
670| catch (Exception $e) {

671| throw new QueryException(
672| $query, $this->prepareBindings($bindings), $e
673| );
674| }
675|

  +9 vendor frames

10 database/migrations/2021_04_03_053322_create_permission_tables.php:56
Illuminate\Support\Facades\Facade::__callStatic()

  +21 vendor frames

32 artisan:37
Illuminate\Foundation\Console\Kernel::handle()

Expected to effortlessly include new permissions for existing roles, but facing difficulties in modifying role permissions effectively due to the encountered error. I modify you existing code, I think it will be helpful for other.

Hi,

I dont undertand if are there a permissions CRUD operations from the admin or the way to add them is thought DB or initial setup?