Magento2 is using triggers in database. When you are downloading live database to local environment and you are using different database user, you can then have issue that you cant delete product in admin. This is because in trigger is still defined old user from live server

Export triggers to file

mysqldump -u DB_USER -pDB_PASSWORD --triggers --add-drop-trigger --no-create-info --no-data --no-create-db --skip-opt DB_NAME > triggers.sql



Change old user to new user

In your text editor replace old user with new user.

Import updated triggers

mysqldump -u DB_USER -pDB_PASSWORD DB_NAME < triggers.sql