WampServer

Well I don't know where to start, but to make a long story short I will just tell what happend.


Well somehow I delted my root user and I can't find a way to get it back. So know I need to copy all sql form my other users but then the problems comes I can't remember the usernames. So I am wondering in which file in the wamp folders i can find all usernames(no need for the passwords).

And if that not posible is there away to get root back?




/thx for all the answers

Do you mean the admin user in phpMyAdmin, or a user in your application, stored in a MySQL table?

Regards,

toivo
Sydney, Australia

The admin user in PhpMyAdmin

hi. i dont think you can get the other usernames back butl the best way to solve it and get the root user back is to is to do this

1.CLOSE WAMP COMPLETELY

2.gotoC:\wamp\bin\mysql\mysql5.0.51b\data\mysql and delete the three files

user.frm
user.MYI
user.MYD


3.download these files again from my server here>> [pampserver.com]


4. replace all 3 back into the folder


5. restart wamp and you should be back in(you will only have the orginal usernames when u first installed wamp)

6.You may need to change the password in phpmmyadmin.conf back to "" because it is root with no password.

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]



Edited 1 time(s). Last edit at 06/15/2008 06:55PM by stevenmartin99.

Will all the databses be gone if I do this?

no

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]