MySQL user registration and login

[briankopy]

I'm basically trying to make a database administrator interface web page/app... I'm using Wamp server phpMyAdmin MySQL

 

users sign in using a username that they can input into a database called database1 table called users

 

if the user doesn't have an account he can create one by entering username and a password twice

 

they can access another table called customertable and Display, Insert, Modify, Delete Contacts, and Logoff

 

So I basically need a login page and a admin page.

 

Any help would be greatly appreciated.

[briankopy]

a little extra info, not sure if necessary

 

fields for customer table:

 

firstname, lastname, city, state, zip, street_address, area_code, phone_number

 

 

[ignace]

A DBMS already has tables to manage users and to control access to it's resources (databases, tables, views, procedures, ..) Take a look at the information_schema database

[briankopy]

I checked that out on MySql.com but didn't really get anywhere, could you elaborate or clarify.

 

Thanks, but still at square 1 here.

[ignace]

http://dev.mysql.com/doc/refman/5.5/en/dynindex-is.html

[jcbones]

http://dev.mysql.com/doc/refman/5.1/en/adding-users.html

 

I'm correct in that this is user accounts for the database, and not for a website, or other program?

 

If so, you will need root access to the database (which you aren't likely to get on a shared server).

[AdRock]

have a look here for loads of tutorials from creating a registration script to users logging in and out

 

http://www.plus2net.com