If the operation fails with SQL errors, the database user employed by your wiki (check your "LocalSettings.php" file) probably does not have sufficient permissions. Either grant this user additional permissions to create and delete tables, temporarily enter the login of your database root in the "LocalSettings.php" file, or use the maintenance script setupStore.php, which can use the credentials of an administrator.