Problem with MySQL. Please help.

[ngu_tri]

I want to create database named guestbook.mysql. Firstly I got problem that the database will not protect by username and password. Secondly attribute "Comments" that should be more than 2000 characters. I used BLOD or TEXT, that doesnot work well. Hope someone can help. Thanks

-u username;// the database will protect by username
-p password; // the database will protect by password

create database guestbook;
use guestbook;
create table guestbook
(
Name varchar(50) not null,
Email varchar(50) not null,
Location varchar(50) not null
Comments BLOD(2000) not null // or BLOD ->>Problem here.
);

[devinemke]

it's BLOB, not BLOD

[ngu_tri]

Hi
I try to set up username and password, but it does not work.
I got error when I type:
1)mysql -u username; or
2)u- username;

So how can I type in username and password first and then create database? thanks for help