unable to add index to column, duplicate entry
I think you are trying to create a primary key and not a simple index. (Primary key requires all values to be unique) 

To add a index in mysql follow the syntax here: https://dev.mysql.com/doc/refman/5.7/en/create-index.html