How can I give All DB permissions to mysql docker

Experience Manager (PaaS/OnPrem)
1

Hi,

How can I give All permissions in mysql DB container to create tables and other actions on creating content in cms console

CREATE
ALTER
DROP
INDEX
SELECT
INSERT
UPDATE
DELETE
LOCK TABLES

Thanks

2

GRANT ALL PRIVILEGES ON *.* TO 'user';

This will give all permissions on everything to the user. You might want to make it more specific. I refer you to mysql documentation/forums for further information.

3

Can I ask as to why you would want to do that?

4

Possibly to import a dump file into an empty database.

1 Like