Create as 'Int' and set to 'Auto Increment'
Don't call the row Index as its a special MySQL word which you'll have to use in quotes if you do.
Feel free to comment if you can add help to this page or point out issues and solutions you have found. I do not provide support on this site, if you need help with a problem head over to stack overflow.