ALTER TABLE - Rename a column
The valid syntax is close to your second try, but you need to escape the column names with backticks not with single quotes:

ALTER TABLE `blog` CHANGE COLUMN `read-more` `read_more` VARCHAR(255) NOT NULL;