c# - DROP command denied to user X for table 'Y' -

c# - DROP command denied to user X for table 'Y' -

we getting ready big sql migration.

currently, have code written, , testing out info on local machine.

step 1 throw out existing info in table before import new stuff:

using (var txn = m_mysqlconnection.begintransaction()) { using (var cmd = new mysqlcommand("truncate table `blah_blah`;", m_mysqlconnection, txn)) { cmd.executenonquery(); } // other code }

but, truncate command throwing exception whenever seek execute mysql user business relationship running code with:

i tried going mysql workbench give userid drop permission, find way add together drop under view section.

i tried that, did not work.

how go giving user ability remove info in these tables can test populate script?

truncate deletes table. seek using delete table.

c# mysql sql mysql-workbench