Oh dear what have I done !!!!

[wap3]

Hi guys,

I have abt of a problem I was using phpmyadmin to create a database. I done all that and now that I had finished it I thought I better set up passwords for it.

I went into the users page and I got confused with all the different ones which where there. So I thought it would be ok to delete them and start again !!!
:p
:o
:eek:

yep, now when I start phpmyadmin it wont let me in, it says


Error

MySQL said:

Access denied for user: 'root@127.0.0.1' (Using password: NO)


how can i fix this ?? do I need to reinstall phpmyadmin ??

:confused:

[wap3]

Ok its ok. Forget that first question now.
I decided to take it off and then re-install it to see if it would solve it and it did. I didn't lose my database as I saved it somewhere else then imported it back in.
:p

I do have anothere question now though. This site is going to be on the back of a website obviously and users are going to be able to login then add, edit and delete items.

So when setting up the users for the database this time. Should I create one which allows add, delete and edit and the details for this account being those which are using to connect to the database from the site ??

Then another one for me say root with a password where I have all the operatoions assigned to me ??

That sound good ??

basic question but I want to make sure I get it right this time. No deleting the wrong accounts !!! :D