What error message did you recieve. It may have been telling you that you don not have authority to grant permissions, which shouldn't be needed on a phpmyadmin type database anyway. Thats really only if your loading the database on your own system. Usually when a database is generated from a hosting company, they set up all the user grant information for you.

If the table is in there, then you should be fine.

The password('password') function is an encryption that MySQL uses for passwords. If you look at the table created

select * from auth;

The first insert in the database is an example of not using the password('password') utility. If you look at the table, you will notice the password in plaintext.

The second insert should show where you inserted password('test123') as 6j9h576KHn86H4mk4 or some other variation of a hash. This just keeps passwords entered into the database secure.

Are you using the testuser login?

Try
login: user
pass: pass

Also try the other,

login: testuser
pass: test123


The databse structure is basically this. The First column is the UserID: If you notice, it is an auto-increment function, that will automatically increase its number by 1 anytime a new user is added to the databse. It is good to have a unique ID attached to all things in the database.

The second column is the username, third is the password, the fourth is the e-mail of the person, and the fifth and sixth are things I added to the system. By default, when someone registers, they are marked as admin no, and activated, no. This was something that was put in to limit access to admin scripts, (add remove user, activate user, etc etc). The activation thing is also in there because at one point I will require user to activate themselves via their email. This ensures that the e-mail provided is actually theirs.

Let me know if you have any more questions.

xmadd