'user' is not valid at this position, expecting an identifier 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;
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;