Need help with php/mysql for accounts

[xxzzangxx]

Hi, i am currently new to php and mysql, i was wondering what is the correct way to form an account and password system. I would want them to be able to make accounts, and then log in to the accounts after they make it. Also what are the best security stuff i can use for this system. Thanks

[killerpants]

i'm assuming you'd like to have your users be able to do this from a web-based sort of interface?
anyway, what i would do is go to the mysql machine and make a new user with grant option on whatever database something like

GRANT SELECT,INSERT ON database.usertable to 'usermaker' identified by 'password';

where database is the name of the database where your user information will be stored, and usertable is the table where individual user data are stored.
this table would include columns for username, encrypted password, other info

the form where users enter their information would collect user info, validate whatever it can client side, then pass it to a PHP app that would validate server side data (duplicate users, etc) and then add the new user to the database.
i'm not familiar with PHP, so no dice there, sorry