Please check if you have connected to the server with the ‘Read-Only’ mode enabled. You can verify if the title bar of SQLyog has the text “Read-Only” appended at the end of the connection name.
Send us a screenshot of the window where we can see the problem you are facing. Also, tell us your SQLyog version.