[SOLVED] how to make the tables?

[CyberShot]

I have an html script already made up with a login username and password box. I want to make a database that will store just one user name and one password. The idea is that I can give this info to certain people and they will be able to login to the the site using that info. But I am having trouble creating the table. Not sure it's right for this purpose. Here is what I have

 

CREATE TABLE login(

username varchar NOT NULL,

password varchar NOT NULL,

);

 

  How do I go about asigning the values for username and password in this format? Or should I try that using phpMyAdmin?

[trq]

CREATE TABLE login (
  uname VARCHAR(50) NOT NULL,
  upass VARCHAR(32) NOT NULL
);
INSERT INTO login (uname, upass) VALUES ('yourusername', MD5('yourpassword'));

 

I changed the names of your fields because password is the name of a mysql function and shouldn't be used as a field identifier.

[CyberShot]

good idea.