Having trouble deleting topics?

• Story Topic
• Twitter Topic
• League

etc

even when they have no content in them...

This is a system setup issue that is related to the database user permission in use by Flow.

Database User Permissions Required

The user needs to have these permissions assigned:

ALTER
ALTER ROUTINE
CREATE
CREATE ROUTINE
CREATE TEMPORARY TABLES
CREATE VIEW
DELETE
DROP
EXECUTE
INDEX
INSERT
LOCK TABLES
SELECT
SHOW VIEW
TRIGGER
UPDATE

Setting User Permissions

SQLyog 12

Look for the User Manager icon:

Then select the user and choose to set either global privileges or object level privileges (to limit the user to specific databases)

SQLyog 8.7

Look for the User Manager icon:

Then select the user and choose to set either global privileges or object level privileges (the example above does global and the one below does object)

MySQL Workbench 6.2

Look for Users and Privileges in the management tab/section

Then select the user and choose to set either global privileges or object level privileges (to limit the user to specific databases)

MySQL Workbench 5.2

Select the connection in the Administration list and then click Manage Security below that

Then select the user and choose to set either global privileges or schema level privileges (to limit the user to specific databases)

Global settings:

Schema settings: