CREATE TABLE utenti(

id int(6) NOT NULL AUTO_INCREMENT,
user char(10) default "",
pass char(10) NOT NULL default "",
PRIMARY KEY (user)
)

Errore:
#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key