create table auth (
userid int unsigned not null auto_increment primary key,
username varchar(10) not null,
password varchar(30) not null,
email varchar(40) not null,
activation varchar(3) not null,
admin varchar(3) default 'no' not null
);
insert into auth values
( '1', 'user', 'pass', '
[email protected]', 'yes', 'no');
insert into auth values
( '', 'testuser', password('test123'), '
[email protected]', 'yes', 'no' );
grant select, insert, update, delete
on auth.*
to databaseusernamehere
identified by 'databasepasshere';