From The Document Foundation Wiki
Jump to navigation Jump to search
SELECT * FROM mysql.tables_priv

and select native mode in the icon bar. When you have done this you should see your selected table set up with the necessary privileges. If your table does not appear in the list, you should give yourself the rights below. It is not the default setting.