Creating New USers in a Database

[Esia0]

Ok i Created a database . .

then how am i going to add a username to it ?

 

and also the password

 

do i need to create a table for it? ? ?

 

 

pls advise ..

 

thanks alot !

[Avalanche]

Yes, you will need to create a table with at least two fields.

 

I would make one named \"username\" and one named \"password\". Try setting both to a varchar of 50.

 

Also, you may want to encrypt the password before you insert it into your table.

[shivabharat]

Esia if u are looking to restrict the database based on the user

 

then u have to set the permission level in the user table

 

select * from `mysql`.`user

[jpjsmith]

i understand the coulumn type for a password should be varchar and encryption is a good idea- the questoin is, how do you encrypt the password?

[shivabharat]

Use md5() function in PHP

 

U cant dencrypt a md5

 

all u can do is compare 2 md5 strings!!

 

like get the password from user convert that to md5 using PHP

 

md5() and then compare it !!

 

Hope this helps!