-CREATE DATABASE IF NOT EXISTS profile;
grant select,
insert,
delete,
- update,
create,
drop,
- file,
- alter,
- index on *.* to user identified by 'user';
+ update on *.* to user identified by 'user';
flush privileges;
-use profile;
-create table list(name VARCHAR(64) NOT NULL,
- age INT,
- height INT,
- weight INT,
- race VARCHAR(64),
- look TEXT,
- password VARCHAR(16),
- etc TEXT,
- PRIMARY KEY(name));
+CREATE DATABASE IF NOT EXISTS webchat DEFAULT CHARSET=utf8;