mysql -u root
show databases;
drop database myblogs;
create database myblogs default character set utf8;
use myblogs;
show tables;
create table user(
id int primary key auto_increment,
username varchar(64) not null unique,
password varchar(128) not null,
filename varchar(128) not null,
sex char(1),
interests varchar(128)
);
insert into user(username, password, filename, sex, interests)
value('tom','1234','a.png','M','books');