'user' is not valid at this position, expecting an identifier
You shouldn't use quotes for the names of objects / entities, that stringifies it as a value instead. This would be the correct syntax you're looking for:
CREATE TABLE users
(
    id int(11) unsigned NOT NULL AUTO_INCREMENT, 
    name varchar(75) NOT NULL,
    password varchar(100) NOT NULL, 
    email varchar(100) NOT NULL, 
    PRIMARY KEY (id), 
    UNIQUE KEY email (email) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 
COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;